The OpenReport action was cancelled.

[tcosmas]

When I click on two buttons on my form which should open reports, I
get an error message ("The OpenReport action was cancelled."). As far
as I know, nothing has changed in the database forms or reports since
I was last able to open and print these reports. Another user (with
similar rights) was able to open both reports and had no problem
printing them out. I am the administrator and use a copy of the
database that none of the other users would be using. As administrator
for the db, I have given myself full rights; but I can't open the
reports in Edit mode. I have tried opening the earliest backup copy
and get the same message.

Since my office was reorganized (reconfigured offices and moving from
one area of the building to another), I wonder if the LAN hookup
location change (new IP address??) may be causing this; but it only
seems to be those particular reports (so far!).

Does anyone know how to fix this situation??

 

[SLB]

We have been having a similar problem in the last two months. All the users
in our department use a shared application on a shared drive. Each user has
a shortcut that is loaded each time they log in as part of their profile.
When some of the users click on a button to print a report, the message
"OpenReport action was cancelled" is seen. Other users get the report. The
application is being run with Access 2003. The code that opens the report is:

stDocName = "ApprovedRequestByDateRange"

If vbNo = MsgBox("Click Yes to Print and No to Preview", vbYesNo) Then
DoCmd.OpenReport stDocName, acPreview, , , acDialog
Else
DoCmd.OpenReport stDocName, acNormal
End If

This code has been running for over 3 years. I have made no changes to the
application in the last year.