Confirm close when clicking the close button

[btaber]

When the user clicks the close button on the man access window, I would like to ask the user "Are you sure you want to exit", with a yes no msg box, and if no is clicked, keep access open, and if yes, exit access. I have found methods to disable the close buttons, but it is too confusing for users used to using the X button. Is this possible? I have seen it before in regular VB...

 

[hermanlaksko]

This should do the trick:

Private Sub Form_Unload(Cancel As Integer)
Dim Rply
Rply= MsgBox("Are You shre U want etc etc.", vbYesNo, "Your App&quot
If Svar = IDYES Then DoCmd.Quit Else Cancel = True
End Sub

 

[btaber]

I wish it was that easy, but I need it for the database, not the forms...

 

[gerard1979]

same principle.
set the code in your startup form
or else; make an invincible form. when you close the app. you unload this form.

 

[btaber]

That was too easy, I have been looking for this for days, Thanks!!!