Hi
I want to keep track the login and out time of the users. After the users login in the login form, it goes to main form. I have the following codes in the Load event in the main form. After I add the code in RED, it doesn't work, no update in the tblLgInTime. qryLogInTime is an append query to the tblLogInTime.
Please help how to fix.
Code:
Private Sub Form_load()
Me.txtlogin = Environ("username")
Me.txtFullName = DLookup("username", "tbluser", "[userlogin]='" & Me.txtlogin & "'")
Code:
Dim strDocName As String
strDocName = "qryLogInTime"
DoCmd.OpenQuery strDocName, acViewNormal, acEdit
End Sub
Regards