OpenReport Action Cancelled in Access 2003

  • Thread starter Thread starter tmc
  • Start date Start date
T

tmc

I have a database created in Access 2002 with a button on
a form which opens a report when clicked. It works fine
on all my machines running Access 2002 but we have a new
laptop running Access 2003 and when the button is clicked
we get an error message saying "OpenReport Action is
cancelled". Any ideas why? Is it a version difference
in Access?

I used the Button Wizard to create the code to open the
report.
 
If the report Cancels itself, the OpenReport will get that error,
unless it suppresses it with an On Error statement. So, maybe the
OpenReport code does *not* check for that error, and there is
something about the *data* on the A2003 laptop that causes the report
to Cancel itself. Perhaps there is no data for the report (on that
laptop)?

HTH,
TC
 
I've learned a little more. When I open the database on
the machine running Access 2003 I can modify or run all
the objects (forms etc.) as expected. However, although
the reports are listed on the Reports tab, I cannot open
or design them. If I click on them the hourglass appears
for a moment and then goes back to the cursor. Any ideas?
 
Back
Top