Can not open reports in Access 2003..

S

SJ

Error is "The OpenReport action was cancelled". The reports opened last week but this week some reports will open and other will not. I have downloaded and installed all critical updates for XP and Office 2003 and still some reports will not open, I get the above error message. Any Suggestions!?!
 
A

Abbarition

Are there any macros/code running on the OnNoData or
OnError properties of the report that could be causing
the message?
-----Original Message-----
Error is "The OpenReport action was cancelled". The
Click to expand...
reports opened last week but this week some reports will
open and other will not. I have downloaded and installed
all critical updates for XP and Office 2003 and still
some reports will not open, I get the above error
message. Any Suggestions!?!
 
A

Abbarition

Just another guess here, but have you tried compiling
your VB code to see if it catches any errors in the code
of your report?
-----Original Message-----
Here is the code behind the button.. but i also must
Click to expand...
mention that i cant even open the report in design
either... thats why i think it is more a Access 2003 bug..
 
D

Duane Hookom

Do you have a default printer specified in Windows? If you think you do, try
specify the printer again.

--
Duane Hookom
MS Access MVP
--

SJ said:
Here is the code behind the button.. but i also must mention that i cant
Click to expand...
even open the report in design either... thats why i think it is more a
Access 2003 bug..
 
P

Paul Johnson

This is a long shot, but is there any code in the report's On Open event
procedure setting Cancel = True?

Paul Johnson

SJ said:
nope nothing happened.. still no error mesage but also no report.. ive
Click to expand...
seen others on this message board have had the same troubles but no where is
there a fix!!
 
D

Duane Hookom

Install a new printer and set it as the default. This doesn't have to
actually be a printer and I recommend the Generic - Text Only driver. Make
sure you set this as your default printer and try create a new report in a
new mdb. If that works, try create a new report in an existing MDB. If that
works, try open an existing report in design view.

--
Duane Hookom
MS Access MVP
--

SJ said:
Nope.. its really doesnt make sense how one day the reports open and the
Click to expand...
next they dont.. i take it no one has heard of this before and the fix is
not some Office 2003 update?
 
Top