PRB: Global Custom Menu Overrides Form or Report Custom Menu

Article ID: Q117162
Creation Date: 22-JUN-1994
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access version 2.0

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

In Microsoft Access version 2.0, a global menu bar should be displayed unless a form or report that is open has its own custom menu bar. If an open form or report has a custom menu bar, then the custom menu bar should be displayed instead of the global menu bar. However, if you use the sample macro on page 46 of the Microsoft Access version 2.0 "Building Applications" manual to set an application's global menu bar, the global menu bar will be displayed instead of the form or report's custom menu bar.

The sample macro on page 46 of the Microsoft Access version 2.0 "Building Applications" manual that demonstrates how to set an application's global menu bar lists the following actions:

   DoMenuItem
   OpenForm
   SetValue

The order of these actions is incorrect.

RESOLUTION

Switch the OpenForm and SetValue actions so that the order of the actions is:

   DoMenuItem
   SetValue
   OpenForm

Changing the order of the macro actions will cause custom menu bars to be displayed when appropriate instead of the global menu bar.

STATUS

This behavior does not occur in Microsoft Access for Windows 95 version 7.0.

REFERENCES

Microsoft Access "Building Applications," version 2.0, pages 45-46

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.