terminating Access

[Robert M via AccessMonster.com]

Does anyone know how I could prevent - or warn - users from closing Access
2000 directly? I would prefer that they use my Exit button and associated
code so that I can execute my application clean up code and then close/exit
Access 'gracefully'.

 

[Keith W]

Does anyone know how I could prevent - or warn - users from closing
Access
2000 directly? I would prefer that they use my Exit button and associated
code so that I can execute my application clean up code and then
close/exit
Access 'gracefully'.

Have your exit code run frm your form's Unload event - you can make use of
the Cancel property in an "Are you sure" message box. That way your code
will run regardless of how the form is closed.

HTH - Keith.
www.keithwilby.com

 

[Robert M via AccessMonster.com]

Thanks, Keith. I'll give your suggestion a try.

Have your exit code run frm your form's Unload event - you can make use of
the Cancel property in an "Are you sure" message box. That way your code
will run regardless of how the form is closed.

HTH - Keith.
www.keithwilby.com