Private Sub Label5_Click()
Dim pegang3 As String
""""user click at radio button for enter daily report
If Option2.Value = True Then
Set General = db.OpenRecordset("select * from GeneralLog WHERE DATE LIKE '*" & Text2.Text & "*'")
Text2 = Combo2 & "/" & Combo1 & "/" & Combo3
"""" combo1 for dare
'''''''combo2 for month
'''''combo3 for year
If Text2 <> "" Then
'Text2 = rsGeneral.Fields!Date
Text2.Text = General.RecordCount
'''' check and loop for result
If General.RecordCount <> 0 Then
Do While Not General.EOF
If General.Fields!Date = Text2.Text Then
Call loadLV
End If
General.MoveNext
Loop
Else
MsgBox ("Record 0")
End If
End If
End If
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.