Global Quit

[David Mulholland]

I'm down south and am working on a local/offline DB that is designed to
export and feed it's contents offline if we have another Hurricane Katrina. I
want it to automatically create a backup of itself everytime it closes...no
matter HOW it closes. I already have the folder creation/DB backup code
working. I can tie my code to the Close button, but if someone is directly
working in its tables, they could just as easily hit the 'X' to close it. Is
there a way to capture this event before it actually closes??

BTW, I just want to reiterate the poster I read earlier..You guys really do
a great service for us Access guru-wannabes!

 

[David Mulholland]

Whoops...

After digging a little deeper in these threads, I found what I was looking
for. Looks like the only option is the hidden form/OnCose event manuever.

 

[Armen Stein]

Whoops...

After digging a little deeper in these threads, I found what I was looking
for. Looks like the only option is the hidden form/OnCose event manuever.

Yes, and if you want to be able to cancel it (and therefore the entire
closure of the database), use the Unload event instead.

Be aware that even when the Unload event of the form is canceled
during an overall quit of the database, the Global variables are all
cleared, at least in some versions of Access we've tried it on
(specifically 2003). That's another good reason not to use globals
for persistent information.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com