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

• Microsoft Access 97

SYMPTOMS

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 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" (without the quotation marks). 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: