ACC97: Custom Menu Macro Named "Menu Bar" Creates Duplicate Menu (167765)


The information in this article applies to:

  • Microsoft Access 97
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.

MORE INFORMATION

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.

REFERENCES

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:

162822 ACC97: Error Creating CommandBar with Duplicate Name
Modification Type:MajorLast Reviewed:9/26/2003
Keywords:kbprb kbusage KB167765
©2003 Microsoft Corporation. All rights reserved.