Microsoft KB Archive/90137

PRB: Form or Report Cannot Be Opened or Previewed

Article ID: Q90137
Creation Date: 11-OCT-1992
Revision Date: 30-NOV-1996 The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

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

If you open a form or report in Design view and then preview it, the form or report is not opened for preview. In addition, if you select the form or report from the Database window and click Open or Preview, nothing happens.

CAUSE

This occurs if a macro is attached to the OnOpen property of the form or report and the first action in the macro is StopAllMacros. The StopAllMacros macro action acts like the CancelEvent action, which prevents the form or report from opening.

The StopAllMacros action stops all macros that are currently running. In this case, the form or report's OnOpen property calls a macro that is immediately terminated, which aborts the preview of the report.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

Create a new macro and add StopAllMacros as the first action.
Save the macro as Macro1.
Open a report in Design view.
Set the report's OnOpen property to the Macro1 macro.
Preview the report. Note that nothing happens.

REFERENCES

For more information about the StopAllMacros action, search the Help Index for "StopAllMacros," or ask the Microsoft Access 97 Office Assistant.

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.

KBCategory: kbusage
KBSubcategory: McrActn
Additional reference words: 1.00 1.10 2.00 7.00 97 8.00