ACC: Cannot Process Close Action in Report's OnOpen Property

• Microsoft Access versions 1.0, 1.1, 2.0, 7.0

SYMPTOMS

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

When you attempt to process a Close action in a macro that is assigned to a report's OnOpen property, you may receive the following error message.

In Microsoft Access for Windows 95 version 7.0:

A macro specified as the OnOpen, OnClose, OnFormat, OnRetreat, OnPage, or OnPrint property setting contains an invalid action for the property.

Can't run this action while processing a form or report event

Can't run this action while processing a report event

This action can't be run while processing a form or report event.

RESOLUTION

Do not use a Close action in a macro that is assigned to a report's OnOpen property.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

1. Create the following new macro called CloseForm:
   

   
         Macro Name   Action
         -------------------
         CloseForm    Beep
                      Close
   
         CloseForm Actions
         ---------------------
         Close
            Object Type: Form
            Object Name: Form1
            Save:        No     (In Microsoft Access 7.0 only) 




2. Create the following new macro called CloseReport:
   

   
         Macro Name    Action
         --------------------
         CloseReport   Beep
                       Close
   
         CloseReport Actions
         -----------------------
         Close
            Object Type: Report
            Object Name: Report1
            Save:        No     (In Microsoft Access 7.0 only) 




3. Create a new form. Assign the CloseForm macro to the form's OnOpen property. Save the form as Form1.



4. View the form in Form view.



5. Create a new report. Assign the CloseReport macro to the report's OnOpen property. Save the report as Report1.



6. Preview the report. Note that the computer beeps and you receive one of the error messages mentioned in the "Symptoms" section. Note that you did not receive an error message in step 4 when you opened the form.

Keywords : kbusage RptProp
Version : 1.0 1.1 2.0 7.0
Platform : WINDOWS
Issue type : kbprb