Microsoft KB Archive/162830

= ACC97: Cannot Rename or Delete Custom Shortcut Menus =

Article ID: 162830

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q162830



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



SYMPTOMS
If you create a custom shortcut menu, you will be unable to rename or delete the menu until you change its type to Toolbar.



RESOLUTION
In order to rename or delete a custom shortcut menu, you must first change its Type property back to Toolbar (Method 1), or delete the shortcut menu by using Visual Basic for Applications in the Debug window (Method 2).

Method 1 - Changing the Type Property

 * 1) Open the application where you created your custom shortcut menu. Using the example from the "More Information" section below, open the sample database Northwind.mdb in Microsoft Access 97.
 * 2) On the View menu, point to Toolbars, and then click Customize.
 * 3) Under the Toolbars tab, click Properties.
 * 4) Choose Custom 1 from the Selected Toolbar list.
 * 5) Choose Toolbar from the Type list. Click Close.
 * 6) Under the Toolbars tab, select Custom 1 from the Toolbars list.

Note that the Rename and Delete buttons are now enabled in the Customize dialog box.

Method 2 - Using Visual Basic for Applications code in the Debug Window
 Open the Debug Window by pressing CTRL+G on the keyboard. Type the following line in the Debug Window

Application.CommandBars("Custom 1").Delete

and press ENTER.

Note that the shortcut menu is deleted. You need to be cautious using this method because there is no confirmation dialog box presented to allow you to choose not to delete the shortcut menu.



STATUS
This is behavior by design.



Steps to Reproduce Behavior

 * 1) Open Microsoft Access 97.
 * 2) Open the sample database Northwind.mdb.
 * 3) On the View menu, point to Toolbars, and then click Customize.
 * 4) Under the Toolbars tab, click New. Call the new toolbar Custom 1.
 * 5) Under the Toolbars tab, click Properties.
 * 6) Choose Popup from the Type list. Note that you receive an informational message. Click OK.
 * 7) Click Close in the Toolbar Properties dialog box.
 * 8) Under the Toolbars tab, select Shortcut Menus from the Toolbars list. This will display the Shortcut Menus toolbar.
 * 9) On the Shortcut Menus toolbar, click Custom 1 on the Custom menu.

Note that the Rename and Delete buttons are disabled in the Customize dialog box.

