ACC: How to Reset Toolbar Options

• Microsoft Access versions 2.0, 7.0

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

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.

MORE INFORMATION

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.

REFERENCES

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

Keywords          : kbusage GnlGlobl 
Version           : 2.0 7.0
Platform          : WINDOWS 
Issue type        : kbhowto 

Last Reviewed: April 7, 1999