Function to run upon MS Access quitting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J Welsby - 09 Nov 2006 03:39 GMT

Am stumped and a troll through the usual sources did not turn up anything

How do I get a function to fire when a user either clicks the close window
button on the Access application window or chooses File/Quit? (the database
window itself is hidden in my db)

Thanks for any thoughts
James

Reply to this Message

Granny Spitz - 09 Nov 2006 04:28 GMT

> How do I get a function to fire when a user either clicks the close window
> button on the Access application window or chooses File/Quit?

Create a hidden form that opens when the app starts. Put your closing
function in this form's Close event. When the app quits it will close this
form, executing the code you put in this form's Close event.

Reply to this Message