Microsoft KB Archive/103992

= ACC: Cannot Add Security Items to Custom Menu =

Article ID: 103992

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q103992



SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.

If you add a security command to a custom menu with a DoMenuItem action, the security command will be unavailable.



CAUSE
You can only perform DoMenuItem actions with commands available from the current context. If you have a form open, you can only perform menu items available to a form. Since security items are available only from the Database window, they will not work when invoked from a form.



RESOLUTION
You can add the security command Change Password to a custom menu using the following sample macro:

  Macro Name         Action        Defined Below --  Change Password    Echo               1 SelectObject      2 DoMenuItem        3 DoMenuItem        4 SelectObject      5

Change Password Actions -  1. Echo Echo On: No  2. SelectObject Object Type: Form Object Name:  In Database window: Yes 3. DoMenuItem Menu Bar: Database Menu Name: Security Command: Change Password 4. DoMenuItem Menu Bar: Database Menu Name: Window Command: Hide 5. SelectObject Object Type: Form Object Name:  In Database window: No

NOTE: Actions 1 and 5 are used if you need to have the Database window hidden while using the retail version of Microsoft Access. The Echo action in step 1 ensures that the Database window is not visible when it is activated in step 2. Step 4 hides the Database window again. If you are using the Microsoft Access Distribution Kit (ADK), steps 1 and 5 can be omitted since the Database window is always hidden.

The only side effect to this workaround is that when the Change Password dialog box appears, you will see the Database window menu items in the background. However, you will not be able to choose them.



STATUS
This behavior no longer occurs in Microsoft Access version 7.0.



Steps to Reproduce Behavior
  Create the following macro and save it as Security Menu:

     Action      Defined Below -     AddMenu          1

Security Menu Actions -     1. AddMenu Menu Name: Security Menu Menu Macro Name: Security Menu Password Status Bar Text: Change Password   Create the following macro and save it as Security Menu Password:

     Macro Name        Action     Defined Below --     Change Password   DoMenuItem       1

Security Menu Password Actions --     1. DoMenuItem Menu Bar: Database Menu Name: Security Command: Change Password  Create a form and set the OnMenu property to Security Menu.</li> View the form in Form view and note that Change Password is unavailable on the Security menu.</li></ol>

Keywords: kbfix kbprb kbusage KB103992

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.