The toolbars in Microsoft Access are fully customizable. This article
describes how to reset the toolbars to their original settings so that
only the toolbars that are appropriate for a given view are displayed.
Back to the top
The following example demonstrates a macro that you can use to reset the
toolbars to their original settings:
| 1. | Create a macro called Reset Toolbars with the following action and
arguments:
Macro Name Macro Actions
------------------------------
Reset Toolbars ShowToolbar
Reset Toolbars Actions
--------------------------
ShowToolbar
Toolbar Name: Database
Show: Where Appropriate
|
| 2. | Click the selector (the box to the left of the ShowToolbar action)
to select the ShowToolbar action.
|
| 3. | On the Edit menu, click Copy.
|
| 4. | Click Paste on the Edit menu 19 times to create a total of 19
ShowToolbar actions in the macro.
NOTE: In version 2.0, click Paste a total of 18 times.
|
| 5. | Change the Toolbar Name argument for the rest of the ShowToolbar
actions to match the following table:
ShowToolbar Action # Toolbar Name Argument
-----------------------------------------------
In Microsoft Access version 7.0:
2 Relationships
3 Table Design
4 Table Datasheet
5 Query Design
6 Query Datasheet
7 Form Design
8 Form View
9 Filter/Sort
10 Report Design
11 Print Preview
12 Toolbox
13 Formatting (Form/Report Design)
14 Formatting (Datasheet)
15 Macro
16 Visual Basic
17 Microsoft
18 Utility 1
19 Utility 2
In version 2.0:
2 Relationships
3 Table Design
4 Table Datasheet
5 Query Design
6 Query Datasheet
7 Form Design
8 Form View
9 Filter/Sort
10 Report Design
11 Print Preview
12 Toolbox
13 Palette
14 Macro
15 Module
16 Microsoft
17 Utility 1
18 Utility 2
NOTE: Setting the Microsoft toolbar to Where Appropriate will cause it
to be shown in all views; therefore, you may want to set it to No.
|
| 6. | Run the macro. All the toolbars will be reset to their original
settings.
|
Back to the top
For more information about toolbar options, search on "toolbars," and then
"restoring default toolbars", using the Microsoft Access 7.0 Help Index.
Microsoft Access "User's Guide," version 2.0, Chapter 24,
Macro Basics," pages 605-625
Back to the top
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Help and Support
