Close Button

L

Larry Linson

"Sheldon" wrote
How can I stop users from closing
the database with the close button
control?
Click to expand...

Why do you want to do this? Perhaps there is another way to accomplish your
purpose.

Larry Linson
Microsoft Access MVP
 
R

Rick Brandt

Sheldon said:
I don't want people closing the database incorrectly. I
disabled the close button in all forms and reports, but it
still is available on the menu bar.
Click to expand...

Open a hidden form at startup with something like this in the form's Unload
event.

If gvOKtoClose = False Then
Cancel = True
End If

Declare gvOKtoClose as a public variable in a standard module. In the
event for *your* close button...

gvOKtoClose = True
DoCmd.Quit
 
Top