Retry-Closing access from x (top right) box

  • Thread starter Thread starter Ian Bayly
  • Start date Start date
I

Ian Bayly

Sorry, finger slipped and prematurely sent last message.
VBA mentions intercepting close from x button using:
Private Sub UserForm_QueryClose(Cancel As Integer,
CloseMode As Integer)
This doesn't seem to work in Access (2000).
Is there a way of intercepting this, and more
particularly, preventing Quit of access using top level "x"

Any help appreciated

Ian B
 
Hi,

I assume you are talking about the main Access "X" close
button here.
I use these techniques. They work great.
Take your pick based on version.

ACC: How to Disable the Close Button (X) on the Access
Application Window (95/97)
http://support.microsoft.com/?id=258049

ACC2000: How to Disable the Close Button (X) on the Access
Application Window
http://support.microsoft.com/?id=245746

ACC2002: How to Disable the Close Button (X) on the Access
Application Window and the Exit Command on the File Menu
http://support.microsoft.com/?id=300688

Alternatively, take a look here:

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

Hope that helps,
Jeff Conrad
Bend, Oregon
 
Perfect response thanks Jeff
Ian B
-----Original Message-----
Hi,

I assume you are talking about the main Access "X" close
button here.
I use these techniques. They work great.
Take your pick based on version.

ACC: How to Disable the Close Button (X) on the Access
Application Window (95/97)
http://support.microsoft.com/?id=258049

ACC2000: How to Disable the Close Button (X) on the Access
Application Window
http://support.microsoft.com/?id=245746

ACC2002: How to Disable the Close Button (X) on the Access
Application Window and the Exit Command on the File Menu
http://support.microsoft.com/?id=300688

Alternatively, take a look here:

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

Hope that helps,
Jeff Conrad
Bend, Oregon

.
Click to expand...
 
You could set the Close Button property of your form to No, which will
disable the "x".
 
Back
Top