Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Controlling Quit Event

Status
Not open for further replies.

MadJock

Programmer
May 25, 2001
318
GB
Could anyone tell me what code to put in a database to be sure of capturing a quit event?

I want to execute some code before the database exits, regardless of where the user tries to exit from or how they try to exit.

Thanks in advance

Graeme Taylor website:
 
Came up with workaround -

Splash sceen loads and minimizes an invisible form. Put call to code to be executed in onClose event of invisible form.

Graeme website:
 
Quit is a Method associated with the Application Class.

There is a Terminate Event, when all references to an instance of an object are removed from memory, like what might happen to a UserForm when that Object is set to Nothing.

Then there is the WorkBook_BeforeClose Event, that occurs before the workbook closes.

So what kind of EVENT are you looking to trap? Skip,
metzgsk@voughtaircraft.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top