Re: How to shut off ALL Menus ?

Thankyou for the response.
The suggestion of OnUnload or OnClose of the form does not work
for me, because my VARIABLES LOSE THEIR VALUES in those
states? These two publicly defined Variables get assigned in the
Module1 module and work perfectly throughout the app, but lose
their value without reason, in the unload of the form? This is not an
option. Any other ideas? Can't I shut off the [X] close button of the
MS Access BlueBar?




Rick Brandt wrote:
ApexData@xxxxxxxxx wrote:
Allow me to answer my own question:
Application.CommandBars("Menu Bar").Enabled = False
'Place this in the OnOpen of the form, solves my problem.

BUT

I still get the MS Access bluebar (for lack of better expression) at
the top of
the screen. This has a close button that the user can press to quit
access,
instead of using my CLOSE BUTTON.
How do I get rid of this, or at least shut off that X (access bluebar
close button) ?

If you have a form that is opened at start up and stays open the entire time
that your app is running then you can execute whatever code you are running
now in your [Close] button in the Close or Unload event of that form. That
way you don't have to concern yourself with how they close the app.

If you don't have such a form then create one explicitly for that purpose
and open it hidden at startup.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

.

Quantcast