Run code when user tries to exit Access.

[crook_n_flail]

Running a macro or module when Access first starts up is straight forward enough; but how do i get a form to display when a user hits the "X" button on the title bar of the main Access window?? Any information on this matter is greatly appreciated.

 

[Rich]

Put it on the close event of a hidden form.

 

[Peter D]

I agree with Rich that putting the code in the OnClose event of a hidden form is a good solution, but it's not perfect because the user may close the database window and leave Access open. In this case, the code would execute.

Just FYI.

Peter De Baets
Peter's Software - MS Access tools http://www.peterssoftware.com

 

[Rich]

Use a popup custom built navigation form!