capturing Log out time in table

[vajeeth]

Hi Guys,

I am new to Access creation, now am trying to create an Access which capture Log in and Log out for the data base.

Actually the problem is i don't know how to capture the Log out time.

There are two forms one is Log in form where i can capture the log in time and date and there is one main form where member update their details and in end of the day they will log out.The time and date of logging out must be captured.

Table where login and Log out time is captured:
Table Name: Logon_Capture
Fields:

ID
System_Name
User_Name
Logon_Date
Logout_Date
Logon_Time
Logout_Time

Please help me to get a VBA or update query to update the log out time while the usre log out from main form.

Sorry for the lengthy explanation.

Thank You!
Regards,
Vajeeth

[Luuk]

I don not see how my answer is going to help you,
but you asked for it:

UPDATE Logon_Capture 
 SET Logout_Date = DATE(Now()),
 SET Logout_Time = TIME(Now())
WHERE UserNAme = 'vajeeth' AND Logout_Date IS NULL()
 

This assumes that, when you logon, you do not fill the Logout_Date, and that NULL is allowed in that column.

[vajeeth]

Hi lukk,

Thanks for the reply. But the problem is there are multiple operators will log in. If there is look up option to check the system name (window login name) and logon date (which is updated one logged into access) to update log out date it will be more accurate.

Please check if it is possible and I will work on the above code also.

Thank you!

[NeoPa]

I suggest that you store the date and time values as a single value rather than split them across date and time.

I can say that determining who is logged in is no part of this question. That is a separate question to which there already a number of answers to be found on Bytes.com, but if you feel you need to you can ask again - but not in this thread.