How to create Access Close Event

[SwingXH]

Is there an event that we can use when Access is closing, like windows is saving settings after one hit turn off computer? I want to write out some infomation when Access is closing.

Thanks,
SwingXH

 

[PHV]

You may consider an hidden form opened by an AutoExec macro and then you may do what you want in the Close event procedure of this form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SwingXH]

I created a macro to open the hidden form, works well.
Just curious, where is the AutoExec macro?
Thanks,
SwingXH

 

[RoyVidar]

he he - it will be found in the macro tab of the database window after you've created it;-)

Point is - a macro named "AutoExec" will be executed automaticly when opening the database.

Roy-Vidar

 

[SwingXH]

Thanks, great

SwingXH