Menu Bar will NOT disable

[LeftyLeo via AccessMonster.com]

Hi all,

I am trying to disable the menu bar at runtime/startup. I have researched
this site and used the solutions presented such as, application.commandBars
("menu bar").enabled = False (tried = 0, too!) and code options. Placed the
code in the form_Open and form_load events. I haven't had any success? I
have unchecked all setting in the Tools --> Startup and the Tools --> Options
that deal with toolbars and shortcut menus, this was not successful, too. I
am at a loss.

Can anyone direct me what to do next?

This site is VERY helpful I use it as a reference all the time, thanks so
much!

 

[Albert D. Kallal]

I actually don't use any code to hide the existing menu bars.


the trick is simply hide all of the tool bars (and menus) that are NOT IN
USE. You simply wind up with the main ms-access menu bar.

Then, in the tools->start-up,, you specify your own custom menu bar (perhaps
with just a exit button on it).

The other important thing to remember is thus you ALWAYS need to shift-enter
into your database to developer, or the whole above process breaks down...

The options to complete hide and keep people out of the ms-access interface
can easily be done using the tools->start-up options. Using those options
allows you to complete hide the ms-access interface (tool bars, database
window etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

If my example works on your machine, and I have no code to hide anything,
then it well shows one approach to doing this....

 

[LeftyLeo via AccessMonster.com]

Thank-you Albert!

I think the trick was to create your own. I didn't want any menu bars but
the example in your application works for me.

Thanks again