Warning Message when closing Access

[stupiet]

To anyone who can help,

In access when you click on the close button in the top right corner the database will immediately close.

Is there a way to make sure a warning message pops up when you click on this, or when you use File->Exit?

This is to prevent someone from accidentally closing the database so that they don't have to keep logging on again.

Thanks for the help!

Tan

 

[KornGeek]

http://www.mvps.org/access/general/gen0005.htm

This site shows how to use a hidden form to prevent Access from exiting until you give the OK.

Keep in mind that they can always use Task Manager or the power button to forcefully exit, but this will prevent accidental exiting.

 

[ZmrAbdulla]

Here is a simple way to close db with message box. Use this code in the UnLoad event of main form.

Private Sub Form_Unload(Cancel As Integer)
    If MsgBox("If you want to quit the program Click 'Yes'", vbYesNo, "Are you sure !!") = vbNo Then
        Cancel = True
    Else
        DoCmd.Quit
    End If
End Sub

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[stupiet]

Thanks to both of you!

It's doing exactly what I wanted it to do.

Tan