Catch when Access is closed (1 Viewer)

Zaeed

Registered Annoyance
Local time
Tomorrow, 01:29
Joined
Dec 12, 2007
Messages
383
Hi all.. Long time no see..

I've got a form that sets a flag when opened, and taken away when you navigate away from the form. My issue is that if the form is open and you close Access, the flag is not reset.. This also occurs if my db crashes..

Is there a way to catch this?
 

Banana

split with a cherry atop.
Local time
Today, 08:29
Joined
Sep 1, 2005
Messages
6,318
It seems to me that you'd just reset the flag on the form's Open, and if the flag is actually bound to a data table, you could then use the info to identify if the form was closed abnormally. As for catching the normal closing, you'd clear the flag on the form's Close event as normal Access closing should fire those events as well.
 

Users who are viewing this thread

Top Bottom