Microsoft KB Archive/167765

= ACC97: Custom Menu Macro Named "Menu Bar" Creates Duplicate Menu =

Article ID: 167765

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q167765



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
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 7.0.



RESOLUTION
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 Menu Bar.



Steps to Reproduce Behavior

 * 1) 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.
 * 2) Open Microsoft Access 97 and convert the Microsoft Access 7.0 database to a Microsoft Access 97 database.
 * 3) In the Database window, click the Macros tab and select the Menu Bar macro.
 * 4) On the Tools menu, click Macro, and then click "Create Menu from Macro." The new toolbar appears.
 * 5) 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.

