Close button document time

LVN

New member
Local time
Today, 17:22
Joined
Apr 10, 2006
Messages
7
The DB Im working on is going to be secured.
I've created user ids with passwords.
I want to create a close button and have it document the time in a table.
Log in/out.
Please help.
 
Create a table to hold the log in /out info
Tab_Accessed
User_Name as text
Date_Logged_In as date
Date_Logged_Out as date

When your start up form opens use an update query to write the username and time to the table

On your close button (on click event)
write an update query to update the time logged Out where username = Currentuser and date_logged_out is null
 

Users who are viewing this thread

Back
Top Bottom