The OpenReport action was Cancelled

  • Thread starter Thread starter bmac
  • Start date Start date
B

bmac

Hello,
Could someone explain the above message to me please.

This problem is happening in an Access database I created. I copied over
the database and tried to recreate the error but can't.
 
do you have an On Error trap in the procedure that opens the report?
are you sure the report you are opening exists and that the query/table
feeding the report exists?
is the report empty and do you have a No Data event.

-Dorian
 
I have the following information in the form:

Private sub Form_Activate()
stdocname = "macupdateReqPrint+"
docmd.RunMacro stdocname
docmd.RunCommand acCmdrefresh Page

the form has information displayed that pulls information from a query. WHen
I run the query separately I get the information, but not when I use it via
the Form.
 
I would try surrounding the name with square brackets. It is possible that
the + sign in the name is confusing the issue

stdocname = "[macupdateReqPrint+]"
docmd.RunMacro stdocname
docmd.RunCommand acCmdrefresh Page

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Well, this is so strange.
The User went back to her current Dell Printer and she can now print preview
the reports and is no longer getting the Microsoft Office Access message "The
OpenReport action was canceled". Her IT dept. had changed her to diffent
Dell printer when this message started to appear and she could print preview
any reports at all.

Thanks for all your feedback. It was very much appreciated.

bmac


--
bmac


John Spencer said:
I would try surrounding the name with square brackets. It is possible that
the + sign in the name is confusing the issue

stdocname = "[macupdateReqPrint+]"
docmd.RunMacro stdocname
docmd.RunCommand acCmdrefresh Page

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
Click to expand...
 
Yes that's one possibility I forgot. If the printer the report is connected
to does not exist. This is checked when a report is opened. It's happened to
me too.

-Dorian

bmac said:
Well, this is so strange.
The User went back to her current Dell Printer and she can now print preview
the reports and is no longer getting the Microsoft Office Access message "The
OpenReport action was canceled". Her IT dept. had changed her to diffent
Dell printer when this message started to appear and she could print preview
any reports at all.

Thanks for all your feedback. It was very much appreciated.

bmac


--
bmac


John Spencer said:
I would try surrounding the name with square brackets. It is possible that
the + sign in the name is confusing the issue

stdocname = "[macupdateReqPrint+]"
docmd.RunMacro stdocname
docmd.RunCommand acCmdrefresh Page

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

bmac said:
I have the following information in the form:

Private sub Form_Activate()
stdocname = "macupdateReqPrint+"
docmd.RunMacro stdocname
docmd.RunCommand acCmdrefresh Page

the form has information displayed that pulls information from a query.
WHen
I run the query separately I get the information, but not when I use it
via
the Form.






--
bmac


:

do you have an On Error trap in the procedure that opens the report?
are you sure the report you are opening exists and that the query/table
feeding the report exists?
is the report empty and do you have a No Data event.

-Dorian

:

Hello,
Could someone explain the above message to me please.

This problem is happening in an Access database I created. I copied
over
the database and tried to recreate the error but can't.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top