Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms
of Use |
ACC97: Custom Menu Macro Named "Menu Bar" Creates Duplicate Menu
This article was previously published under Q167765
Moderate: Requires basic macro, coding, and interoperability skills.
When you convert a Microsoft Access for Windows 95 version 7.0 database
that contains a custom menu bar called Menu Bar to Microsoft Access 97, the
database will contain two toolbars named Menu Bar once the menu bar macro
is run. One toolbar is the default toolbar that comes with Microsoft Access
97, and the other toolbar is the converted menu bar from Microsoft Access
To avoid the confusion that may arise from having two toolbars with the
same name, you should rename the converted menu bar to something other than
Steps to Reproduce Behavior
- In Microsoft Access 7.0, create a new database and use the Menu
Builder to create a new menu. Save the menu as Menu Bar.
Close the database.
- Open Microsoft Access 97 and convert the Microsoft Access 7.0 database
to a Microsoft Access 97 database.
- In the Database window, click the Macros tab and select the Menu Bar
- On the Tools menu, click Macro, and then click "Create Menu from
Macro." The new toolbar appears.
- On the View menu, click Customize, and then scroll down the Toolbars
list. Note that there are two toolbars called Menu Bar. You can delete
or rename the converted menu bar.
For more information about converting menu bar macros, search the Help
Index for "menus, menu bar macros," and then "Maintain or update menus
previously created with macros."
For more information about converting custom menu bars in code, please see
the following article in the Microsoft Knowledge Base:
ACC97: Error Creating CommandBar with Duplicate Name
Article ID: 167765 - Last Review: January 19, 2007 - Revision: 3.1
- Microsoft Access 97 Standard Edition
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate