Hi
I have a Problem in VBA code in Ms Access 2013
I want to Store Time of login users.
I work with New Ribbon I customized myself and I used lngSelectedUser code in checking Correctness of username and password like this:
Private Sub Command3_Click()
lngSelectedUser = Nz(DLookup("[User-id]", "[Users]", "[Password] = '" & Me!text2 & "' AND [UserName] = '" & Me!Text1 & "'"), 0)
If lngSelectedUser = 0 Then
MsgBox "Wrong Name / Password", vbCritical, "Login"
lngSelectedUser = 0
End If
UpdateRibbon
My question is How to record the daily login and logout time of a particular user?
I have done search in different sites and forums about this, but the result is null. In fact I need a sample database which I can get pattern in my own project.
Please help me and if it is possible send me your Access sample database.
tnx.