Update query on access close

K

Kuraige

Hi I was wondering if you can run a update query, when a user presses the X
button (closes all access forms down)

I need to report that they have left the system in my tracking table

Thanks in advanced
 
A

Allen Browne

When Access starts, open a hidden form.

Use the Unload event of this form to simulate an application close event,
and execute your logging query.
 
K

Kuraige

Very smart Thanks

Allen Browne said:
When Access starts, open a hidden form.

Use the Unload event of this form to simulate an application close event,
and execute your logging query.
Click to expand...
 
Top