View Single Post
Old Mar 31st, 2008, 1:21 PM   #1
shidayati
Newbie
 
Join Date: Mar 2008
Posts: 5
Rep Power: 0 shidayati is an unknown quantity at this point
someone plz help me with mh code

vb Syntax (Toggle Plain Text)
  1. Private Sub Label5_Click()
  2. Dim pegang3 As String
  3. If Option2.Value = True Then
  4.  
  5.  
  6. Set General = db.OpenRecordset("select * from GeneralLog WHERE DATE LIKE '*" & Text2.Text & "*'")
  7.  
  8. Text2 = Combo2 & "/" & Combo1 & "/" & Combo3
  9. pegang3 = Combo2 & "/" & Combo1 & "/" & Combo3
  10.  
  11. If Text2 <> "" Then
  12.  
  13.  
  14.  
  15. 'Text2 = rsGeneral.Fields!Date
  16.  
  17. Text2.Text = General.RecordCount
  18.  
  19. frmadmin.txtDate = pegang3
  20.  
  21. If General.RecordCount <> 0 Then
  22. Do While Not General.EOF
  23. If General.Fields!Date = Text2.Text Then
  24. Call loadLV
  25. End If
  26.  
  27. General.MoveNext
  28. Loop
  29.  
  30.  
  31. Else
  32. MsgBox ("Record 0")
  33. End If
  34. End If
  35. End If
  36.  
  37.  
  38. End Sub






""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
i don't what problems with this code..something with their looping and call funtion not work properly.the result no shown like i want and not appear at listview data.

Last edited by big_k105; Mar 31st, 2008 at 3:53 PM.
shidayati is offline   Reply With Quote