On application close need to run code

[Andy G]

What is the best way to run code when the application is closed? Is there a
Application_Close somewhere in Access that I have access to? Maybe someone
has a Rube Goldberg 'esk' way of accomplishing this.

The reason I need this is because the user tends to hit the X to close the
application and I have no way to catch that and run the necessary code. I
have a logout button but they don't always use it.

Thanks.
-Andy

 

[Rick B]

The most common way is to include the code in a form's "close" event. Then
have this form automatically open with the database (in hidden mode if you
want).

This will fire when the form is closed.

 

[Darhl Thomason]

Or you can always disable the X so they can't use it to close the db,
forcing them to use the logout button.

d

 

[Andy G]

Where do you disable the application X. The X to close Access down?

Thanks.