The OpenReport action was Cancelled

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bmac - 26 Nov 2007 14:55 GMT

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.

Signature

bmac

Reply to this Message

mscertified - 26 Nov 2007 15:01 GMT

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.

Reply to this Message

bmac - 26 Nov 2007 15:16 GMT

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.

Signature

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
[quoted text clipped - 8 lines]
> > This problem is happening in an Access database I created. I copied over
> > the database and tried to recreate the error but can't.

Reply to this Message

John Spencer - 26 Nov 2007 16:49 GMT

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

Signature

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

>I have the following information in the form:
>
[quoted text clipped - 22 lines]
>> > over
>> > the database and tried to recreate the error but can't.

Reply to this Message

bmac - 26 Nov 2007 18:01 GMT

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

Signature

bmac

> I would try surrounding the name with square brackets. It is possible that
> the + sign in the name is confusing the issue
[quoted text clipped - 29 lines]
> >> > over
> >> > the database and tried to recreate the error but can't.

Reply to this Message

mscertified - 26 Nov 2007 19:51 GMT

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

> Well, this is so strange.
> The User went back to her current Dell Printer and she can now print preview
[quoted text clipped - 40 lines]
> > >> > over
> > >> > the database and tried to recreate the error but can't.

Reply to this Message