Access 2003 Menu Bar Issue

  • Thread starter Thread starter mckitlk
  • Start date Start date
M

mckitlk

I was wondering if anyone knows how to fix this problem...

In my databases, I've routinely used CommandBars to hide the main menu
from the users. For myself I can use the Shift-Bypass feature to
bypass the startup options and have access to the main menu. I've
been doing this since Access 97, and it has worked fine.

It's not working so well in Access 2003, however. The menu gets
hidden just fine. The problem is, it doesn't stay UNhidden when I
WANT it to. I keep having to restore it by inputting a CommandBars
instruction in the Immediate Window. It's happening so often that
I've started putting a RestoreMenu sub in a module in many of my
databases. Needless to say, this is exasperating.

Any idea what's happening, and if there's a way to get this to stop?

Thanks so much!

Laura
 
The approach that works for me is:

Always shift-key bypass into the database when you are developing.

Right after you shift-enter into your database, you should see the main
database window.. and no tool bars. If you see any tool bars...simply hide
them.

however, you should, and can, and will see the main ms-access menu
bar...this is fine....
I keep having to restore it by inputting a CommandBars
instruction in the Immediate Window.
Click to expand...

You should not need any code....

So,
you most certainly can, and should hide all of the ms-access interface. 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. This means you do not, and should NOT need any code here in your
start-up.

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

Try my example...and see if it works. If my example with NO code works, then
obviously it is juts a issue of the start-up settings.....
 
I tried an experiment:

1. Create an empty database.
2. Make sure the Menu Bar is functioning right in that DB.
3. Import all the objects from an existing DB.
4. Comment out all the CommandBars instructions.
5. Set up the StartUp options to hide the Access interface.

It works fine for most interface elements. But it's not consistent
for the Main Menu, and I don't see much of a pattern. I went in and
out several times without Shift-Bypass, i.e. letting the startup
options run. The Main Menu was still there. I turned my attention to
something else, using Outlook. When I came back and ran it again, the
Main Menu had disappeared. Using Shift Bypass didn't restore it, and
I had to manually enter 'CommandBars("Menu Bar").Enabled = True' to
get it to return -- and I had to do that twice. Now it won't go away,
no matter how many times I exit and reload the database without Shift-
Bypass.

Looks like a bug to me.

Laura
 
Looks like a bug to me.
Click to expand...

And, what about my sample.....how come it seems to work then?

My example uses NO code, and JUST uses the start-up settings...and it seems
to hide everything...and it is consistent....

Take careful note of my start-up settings..and see how they differ from
yours.
 
Back
Top