ACC97: Cannot Rename or Delete Custom Shortcut Menus

• Microsoft Access 97

SYMPTOMS

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

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 or delete the shortcut menu using Visual Basic for Applications in the Debug window.

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

1. Open the Debug Window by pressing CTRL+G on the keyboard.

2. 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.

MORE INFORMATION

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.

REFERENCES

For more information about popup or shortcut menus, ask the Microsoft Access 97 Office Assistant, "How do I create a custom popup menu."