Run code on closing db

[Yugo]

Hi all,

I would like to run a piece of code when my database is closed. At the moment I have a button that the users can press to exit the db and obviously i could attaach an event to that button However i have noticed some of my users click on the cross in the top right of the application windown rather than use my exit button.

Is it possible to still get the code to run if the user closes in this way?

Failiing that is it possible to disable that cross button to close the application hence forcing them to use my command button anyway?

Cheers

 

[Yugo]

I forgot to say, this is using Access 97.

 

[bmacr]

Try this trick:
http://www.accessvba.com/showthread.php?s=&threadid=2680

 

[Yugo]

Thanks buddy that'll come in useful

 

[paulhorn]

why not prevent users from using the form close control in the first place? You can do this by setting the controls proerty in design mode
HTH