Writing into the DB before access closes
Posted on 2004-04-30
Help me figure this out please?
I've created a system which writes in the userID and the time when the user logs in. I've also created a logout button which will add the logout time to the same record.
But, the user can choose NOT to click the logout and instead close the entire access.
Now, I have 2 solutions:
1. Detect when access is going to close, write the logout time to the table before closing. The thing is, i don't know how to do that. The detecting part that is...
2. Disable the close buttong (the X button on the top right hand corner) of access.
I'll accept any other solutions if it works too. 8-p