Customized menu bar

[TS]

Hi all,
I posted the following question before and got no answer. Please let me know
if I'm posting it in the right place:-

I created a customized menu bar for an access 2K database. When I tried to
open the database from one of the users machines, the menu bar I created
didn't show up. It only shows up on the computer I used to create it at
first. Is there anyway to make it appear on all users computers when they
open the database???

Thanks a lot

 

[Rick Brandt]

Hi all,
I posted the following question before and got no answer. Please let
me know if I'm posting it in the right place:-

I created a customized menu bar for an access 2K database. When I
tried to open the database from one of the users machines, the menu
bar I created didn't show up. It only shows up on the computer I used
to create it at first. Is there anyway to make it appear on all users
computers when they open the database???

Thanks a lot

Did you create a completely new menu bar or did you customize one of the
built in ones? Customizations to existing menus and toolbars are "computer
specific". You will see those customizations in every file you run *only on
that PC*.

Completely new Menus and Toolbars are "file specific". You will only see
them when running that particular file, but they DO follow that file when
you access it from (or copy it to) another PC.

 

[TS]

How to create completely new menus and toolbars? The ones I created was
through View, Toolbars, Customize which allowed me to add NEW menu bars. I
also kept some built-in menu bars. Is there another way to build NEW menu
bars, so they will be carried over to any computer when openeing the same
file?

Thank you for all your help.

 

[Guest]

Best way is to create the custom menu programaticly.
I know how to do that in excel but not access. search MS
support or KB.

 

[Albert D. Kallal]

How to create completely new menus and toolbars? The ones I created was
through View, Toolbars, Customize which allowed me to add NEW menu bars. I
also kept some built-in menu bars. Is there another way to build NEW menu
bars, so they will be carried over to any computer when openeing the same
file?

If you made new ones..and are NOT talking about customized built in menus,
then you are fine. It just needs pointing out that customizing existing ones
do NOT travel with he database, but any NEW menu bar you crated does travel
with the application. So, it sounds like you got this part right.

As for showing the menu bar, remember, if you hide the bar (just right
clicking, and un-checking it), then it will remain closed. To kind throw out
some menu bars..and then "hope" that they stay shown is a bad approach here.
(I mean, where did you specify in the application what menu will show
where?...you can't leave this up to the wind!!!).

You need to either:

a) specify the menu bar in the tools->startup
b) specify the menu bar you want to show for a given form (this setting
if found in he forms properties "other" tab).

If you don't do one of the above two things, then you can resort to coding,
but that becomes a real mess real quick, as then you have to use code to
decide which menu bars show with which forms..and when you chance focus
between forms, then again you would have to run code. So, use the
tools->startup to specify your menu bar, and for forms that you want specify
menu bars to show, then use the property settings in he "other" tab.

If you want to see a sample of the above process where each form has a
different menu bar (and, for forms that have NO menu specified, then it
default to the one you set in tools->startup). You can grab this sample
here, and note how the menu bars change, and all of the standard ones are
hidden, and also not that this approach TAKES NO CODE!!!

(grab the 3rd download from above with "ms-access interface hidden")