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

vb Syntax (Toggle Plain Text)
  1. Private Sub Label5_Click()
  2. Dim pegang3 As String
  3.  
  4. """"user click at radio button for enter daily report
  5. If Option2.Value = True Then
  6.  
  7.  
  8. Set General = db.OpenRecordset("select * from GeneralLog WHERE DATE LIKE '*" & Text2.Text & "*'")
  9.  
  10. Text2 = Combo2 & "/" & Combo1 & "/" & Combo3
  11. """" combo1 for dare
  12. '''''''combo2 for month
  13. '''''combo3 for year
  14.  
  15. If Text2 <> "" Then
  16.  
  17.  
  18.  
  19. 'Text2 = rsGeneral.Fields!Date
  20.  
  21. Text2.Text = General.RecordCount
  22.  
  23. '''' check and loop for result
  24.  
  25. If General.RecordCount <> 0 Then
  26. Do While Not General.EOF
  27. If General.Fields!Date = Text2.Text Then
  28. Call loadLV
  29. End If
  30.  
  31. General.MoveNext
  32. Loop
  33.  
  34.  
  35. Else
  36. MsgBox ("Record 0")
  37. End If
  38. End If
  39. End If
  40.  
  41.  
  42. End Sub


''''''''''''''''''''''''''''''''''''
this program is to show daily report for student attendance based on date that enter by teacher......example if 30 student attend class on 28/02/2008..show the result will be shown all names of student.

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