Log in and Exit recording.

[Christopherusly]

All Ii am after quite simply is a table which produces a log in and an exit time and person / machine name when opening my database, (I do not want to go down the route of using the inbuilt user level permissions for access)

I have scripts which work very nicely for getting the current user and the current user machine =()Fosusename and =()Fosmachine name produced by dev amish, what i think i need is a littl bit of VBA which runs on the form load event .. any suggestions on how i might achieve this ?



Thanks guys and gals.

 

[vbaInet]

1. Create a hidden form that will open up when the application loads and will remain open
2. Use the On Load event to write a logged-in record
3. Use the On Unload event to write a logged-out record

 

[Christopherusly]

thanks vbaInet

 

[vbaInet]

You're welcome

 

[DCrake]

Here is a link to a demo of what you are looking for.