Close Button

L

Larry Linson

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

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top