To design a toolbar that's available in all your Microsoft Access databases and Microsoft Access projects, add buttons to the blank built-in toolbars, Utility 1 and Utility 2.
- On the View menu, point to Toolbars, and then click Customize.
- On the Toolbars tab, select the check box for Utility 1 or Utility 2 in the Toolbars box.
- Close the Customize dialog box. Access displays the toolbar you selected in step 2.
- To complete the toolbar, add buttons from the Customize dialog box, move or copy a button from another toolbar, or add menus.
- On the Tools menu, click Customize.
- Click the Toolbars tab.
- Click New.
- In the Toolbar name box, type the name you want, and then click OK.
- Click the Commands tab.
- Do one of the following:
- Click a category in the Categories box.
- Drag the command you want from the Commands box to the displayed toolbar.
Add a built-in menu to the toolbar
- In the Categories box, click Built-in Menus.
- Drag the menu you want from the Commands box to the displayed toolbar.
- When you have added all the buttons and menus you want, click Close.
Note Custom toolbars that you create are specific to the Access data file. If you want to use a custom toolbar in a different Access data file, you must re-create or import the custom toolbar.
- In the Database window, click Macros under Objects, and then click the name of the macro you want to create a toolbar from.
- On the Tools menu, point to Macro, and then click Create Toolbar from Macro.
Note Microsoft Access won't delete the original macro (or macros if you're working with a menu macro and the associated menu macro groups) after it creates the new toolbar. The new toolbar still depends on the original macro or macros, except for macros that contain only AddMenu actions or RunCommand (formerly DoMenuItem) actions.
Create a custom menu bar for the current Access data file
- On the View menu, point to Toolbars, and then click Customize.
- On the Toolbars tab, click New.
- In the Toolbar Name box, type the name you want, and then click OK.
The new menu bar is now placed next to the Customize dialog box.
- On the Toolbars tab, click Properties.
- In the Type list, click Menu Bar.
- Set any other properties you want, and then click Close.
- To complete the menu bar, add custom menus or built-in menus.
Note You can attach the custom menu bar to a form or report or you can designate the bar as the global menu bar.
- On the View menu, point to Toolbars, and then click Customize.
- On the Toolbars tab, click New.
- In the Toolbar Name box, type the name you want, and then click OK.
- On the Toolbars tab, click Properties.
- In the Type list, click Popup.
- Set the AllowCustomizing property the way you want, and then click Close.
Microsoft Access adds the shortcut menu to the Shortcut Menus toolbar, from which you customize all shortcut menus.
- In the Toolbars box on the Toolbars tab, click Shortcut Menus.
- On the Shortcut Menus toolbar, click the Custom category.
- To complete the menu, add commands from the Customize dialog box and move or copy commands from other menus.
Note You can attach the custom shortcut menu to a form, report, or control, or designate the menu as the global shortcut menu.
When you delete a built-in menu, the menu remains in the Customize dialog box. However, when you delete a custom menu, it is permanently deleted. To remove a custom menu and save it for later use, create a storage toolbar for storing your unused custom menus.
- Show the toolbar that contains the custom button you want to store.
- On the View menu, point to Toolbars.
- Do one of the following:
- If the toolbar name is listed, click the toolbar name.
- If the toolbar name is not listed:
- Click Customize.
- In the Customize dialog box, click the Toolbars Tab, and then double-click the toolbar you want to show.
- On the Tools menu, click Customize, and then click the Toolbars tab.
- Click New.
- In the Toolbar name box, type the name you want for the storage toolbar.
- Click Close.
The new storage toolbar remains showing on the screen.
- Do one of the following for each custom toolbar button you want to store:
-
To move a button, hold down ALT and drag the button to the new storage toolbar.
-
To copy a button, hold down CTRL+ALT and drag the button to the new storage toolbar.
-
- To hide the storage toolbar, right-click the storage toolbar and clear the check box next to its name on the shortcut menu.