ACC: How to Reset Toolbar Options (120970)



The information in this article applies to:

  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0

This article was previously published under Q120970
Novice: Requires knowledge of the user interface on single-user computers.

SUMMARY

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

Modification Type:MajorLast Reviewed:6/24/2002
Keywords:kbhowto kbusage KB120970