Procedure at Access Stutdown

[Jim Evans]

Is there a way to assure that a certain procedure is called before Access is
allowed to Quit? I know that there are things you can do such as removing
the Exit option from the File menu and requiring the use of a Logoff form
but, what about the user that just clicks the Close button in the
Application Control Box?

 

[Jack Leach]

Read here:

http://www.mvps.org/access/general/gen0005.htm



As far as the control button for the access application, that can be disabled:

http://support.microsoft.com/default.aspx/kb/245746



p.s. - I'll get the rest of the MenuBar code tomorrow, I don't have access
to it at the moment

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Stuart McCall]

Is there a way to assure that a certain procedure is called before Access
is allowed to Quit? I know that there are things you can do such as
removing the Exit option from the File menu and requiring the use of a
Logoff form but, what about the user that just clicks the Close button in
the Application Control Box?

Call your procedure in the close event of a loaded form (hidden or
otherwise). Access will run the code before unloading the form, then close.

 

[ChrisO]

Actually, there isn’t.
If you want to ensure a procedure runs then look into running the procedure
at startup.

 

[ChrisO]

Loss of electrons.
Thermal shutdown.
Application software crash.
Access crash.
Hardisk failure.
CPU failure.
Memory failure.
Network failure.

Each can prevent ensuring code runs.
It’s to do with the definition of ensuring.

If we can do it at startup most, but not all, of the above are ensured.

 

[Jim Evans]

Thanks for your input, Chris.

Loss of electrons.
Thermal shutdown.
Application software crash.
Access crash.
Hardisk failure.
CPU failure.
Memory failure.
Network failure.

Each can prevent ensuring code runs.
It's to do with the definition of ensuring.

If we can do it at startup most, but not all, of the above are ensured.

 

[Jim Evans]

Thanks for your input, Stuart.

Call your procedure in the close event of a loaded form (hidden or
otherwise). Access will run the code before unloading the form, then
close.

 

[Jim Evans]

Thanks again, Jack. Works exactly as I needed.

Jim