ACC1x: How to Add Items to the Help Menu

Last reviewed: August 6, 1997
Article ID: Q88648

The information in this article applies to:

- Microsoft Access versions 1.0, 1.1

SUMMARY

The Help menu items that appear at the top of the screen in Microsoft Access can be supplemented so that your own custom menu items appear. This can be done by creating an entry in the MSACCESS.INI file.

MORE INFORMATION

You can add your own entries to the [Menu Add-Ins] section of the MSACCESS.INI file. You can use this feature to invoke a macro, an Access Basic program, or an Access Basic function from a Help menu item. To add to this section of the MSACCESS.INI file, follow these steps:

Close Microsoft Access if it is open.
From your Windows Program Manager, start Notepad.
In Notepad, open the file MSACCESS.INI (this file is located in your Windows directory).
Scroll down to the bottom of the file, add a blank line, and type the following:
```
      [Menu Add-Ins]
```
Add any menu items that you want to appear in the Help menu below the line you just typed. Add lines using the following syntax:
```
      <menu label>=<menu action>
```
Substitute the text that you want to appear in the Help menu for <menu label>, and the macro name, user-defined function, or Access Basic function that should be run for <menu action> in the example above.

For example, to add a Help menu item called Customer Form that runs a macro called OpenCustForm, the [Menu Add-Ins] section of the MSACCESS.INI file would read:

   [Menu Add-Ins]
   Customer Form=OpenCustForm

To add a Help menu item called Run Daily Update that runs a user-defined Access Basic function called RunUpdate(), you would add the following to the MSACCESS.INI file:

   [Menu Add-Ins]
   Run Daily Update==RunUpdate()

Note that the second equal sign (=) in the above example is required for running user-defined or other Access Basic functions.

You can also define an underlined character in your Help menu item that is accessible with the ALT key. To do this, place an ampersand (&) in front of the character that should be underlined. For example, to create a Help menu item called Show Message with the M underlined that calls the Access Basic MsgBox() function, add the following to the MSACCESS.INI file:

   [Menu Add-Ins]
   Show &Message==MsgBox("This is a message")

You can add multiple items to the [Menu Add-Ins] section of the MSACCESS.INI file. The example below includes all the examples in this article:

   [Menu Add-Ins]
   Customer Form=OpenCustForm
   Run Daily Update==RunUpdate()
   Show &Message==MsgBox("This is a message")

After you have made these changes to the MSACCESS.INI file, save the file and then close Notepad. When you restart Microsoft Access, the items in the [Menu Add-Ins] section will be available from the Help menu.

Keywords          : UifOthr kbui
Version           : 1.0 1.1
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbhowto

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: August 6, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.