an equivelant to VB6 queryUnload event?

[belovedcej]

Is there an event in Access that will run even if the program is abnormally shut down? Like in a power outage or a CTRL-ALT-DELETE set up? A VB programmer told me about the queryUnload event, but I don't see that in VBA

 

[LNBruno]

Haven't tried this, but maybe a "quit" macro?

< M!ke >

 

[belovedcej]

Thanks for the quick response. Are you refering to the Quit option in a macro? That simply shuts the program down.

I have a routine that needs to run with the application is shut down, and I have taken care of that - unless something happens to shut things down abnormally. If Access is shut down with CTRL-ALT-DEL, the unload event of a form does not trigger - so I know that following events (like form close) will not. I'm looking for some kind of event that will handle things when a form closes - even if it never makes it as far as the unload event.

Just had a thought - I wonder if deactivate will work. I'll check it out and let you know.

 

[belovedcej]

Neither deactive or lost focus works.

Any other ideas?

 

[LNBruno]

I realized this on the way home yesterday (of course): if the power goes off, NOTHING will run.

< M!ke >