Application Close (2000)

[bigsteve520]

I run a query when a user exits the application to remove his/her name from the "current users" table. I run this query from the Yes click on the confirm exit dialog. This all works fine. I run into trouble when the user closes the app from the "X" (close button) in the upper right hand corner of the Access window (which does not launch my confirm exit dialog). Where do I put the code to either: launch my confirm exit dialog from that "X" or run my query when the user exits using the "X". Your help is always appreciated. Thanks.

[HansV]

You can disable the close button of the Access application window. See MSKB article ACC2000: How to Disable the Close Button (X) on the Access Application Window.

You can also prevent the user from closing a form except by clicking a command button on your form. See for example <post#=94249>post 94249</post#>.

[markr1963]

I wondered how that could be done.

Thanks Hans

Mark

[DJLansing]

<img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> Thanks Hans, i have been <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> on this for sometime. Three cheers to you. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>