|
|
Close event for Access
Unfortunately, although Access has a Close event for Forms, it does not have a Close event for the database itself as a whole. One way to get around this is to create a form that has a height and width of 0. This form is the form that is opened from the Startup options for the database, and in turn opens a Switchboard form. As this form is kept open, but hidden, when the database closes, either by a method that you have added to the database (such as a command button with the OnClick event set to 'Application.Exit') or the Close button from Access itself, the Form's Close event will occur just before the Close Event for the database itself, so you place any code that needs to be performed when the database closes, such as resetting any database options set on Startup, in that event.
Top
HOME |
NEW |
TABLES |
QUERIES |
FORMS |
REPORTS |
GENERAL |
API |
DOWNLOADS |
TUTORIAL |
RESOURCES
E-MAIL
Copyright & Disclaimer
|
| |
