Application Exit

[NattyP]

Can anybody please advise me of how to trap the quit event for a database.

I wish to trap the event and ask the user to confirm that he/she really wants to exit.

Regards

 

[930driver]

Create a form, leave it hidden but open all the time. In it's OnClose event do your dirty work.

"The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[NattyP]

930driver......you are a gentle genius! Thank you very much

 

[930driver]

Actually, I made a mistake. Use the On Unload event because it is the one that can be cancelled.

If MsgBox("Exit",vbYesNo) = vbYes then
'exit
Else
Cancel = True
End If
"The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"