Capturing access closing as an event

[chrisbrooke]

Is there a way to capture microsoft office closing as an event. Ive created a button to close office because I want to time stamp when this event occurs, but inadvertently the main close button at the top of the screen is sometimes used and hence the event is not captured. Any ideas?, or is there a way to disable the main close button in access? Thanks.

 

[Mile-O]

The easiest way is to use a hidden form and a public boolean.

 

[namliam]

if the main allways remains open AND is the first form opened you can use the On Unload event...

If not, then you can make a small (initial) form and open that (hidden) at startup of the DB. This form then stays open untill Application.quit is triggers (again on unload) do stuff for your shut down procedure.

Regards

The Mailman