My Customized Menus Change Standard MS-Access Menu

[Guest]

Hello:

I am using the menuing objects (CommandBar, CommandBarControl, etc.) to
customize the "Menu Bar" menu for my app. The problem is that is Access
crashes (before my code reverts menu back to the standard Access menu) or if
a user opens my app and then MS-Access afterward, they see my app's menu, not
the standard MS-Access Menu.

Would anyone have a workaround for this?
thank you in advance for any advice you might have.

Regards
Harvey

 

[Rick Brandt]

Hello:

I am using the menuing objects (CommandBar, CommandBarControl, etc.)
to customize the "Menu Bar" menu for my app. The problem is that is
Access crashes (before my code reverts menu back to the standard
Access menu) or if a user opens my app and then MS-Access afterward,
they see my app's menu, not the standard MS-Access Menu.

Would anyone have a workaround for this?
thank you in advance for any advice you might have.

Regards
Harvey

I don't understand this. Changes you make to built in command bars stay on your
machine only and show up in all files you open. Totally NEW command bars that
you create are stored within the file and should show up on all PCs running that
file (but only in that file).

If you are modifying built in command bars from code in your app then STOP doing
that. Your app should not be changing things on other's PC. Create a new
command bar for your app and then remove the code that is doing the modifying.

 

[Guest]

thanks Rick. However, the same problem still exists. I am not overwriting
the menu now, but I still need to conceal it (for some reason, using .Enabled
property - the .Visible property on the built in Menu Bar gives an error).
So if the user opens access at the same time my app is open, now, they see no
menu.

In addition, I have 2 custom menu bars and they always appeared properly
before, the first taking the space of the access menu bar, was always pinned
at the top, the 2nd below it. Now, the second one appears above the first,
which is not the way I can have this appearing (both must use msoBarTop, but
the first must stay at the top). Is there any way of controlling order of
appearance?

thanks in advance to you or anyone else who might have an answer.

regards,
Harvey

 

[Rick Brandt]

thanks Rick. However, the same problem still exists. I am not
overwriting the menu now, but I still need to conceal it (for some
reason, using .Enabled property - the .Visible property on the built
in Menu Bar gives an error). So if the user opens access at the same
time my app is open, now, they see no menu.

In addition, I have 2 custom menu bars and they always appeared
properly before, the first taking the space of the access menu bar,
was always pinned at the top, the 2nd below it. Now, the second one
appears above the first, which is not the way I can have this
appearing (both must use msoBarTop, but the first must stay at the
top). Is there any way of controlling order of appearance?

thanks in advance to you or anyone else who might have an answer.

All built in menus can be disabled in the startup properties of your file.
Then you supply replacements that only have the functionality you want
exposed. Various menu and toolbars can be set to show/hide with every form
and report in your app by simply setting those properties in the form/report
design.