Error 2501 on OpenReport

[JediBMC]

First, let me say that I have done my due diligence and researched this
error till the cows came home. Unfortunatly, with one exception, the
resolutions all seem to point to an issue with either a coding mistake
or a null data report. In my case, it does not seem to be either.


The brief synopsis of the problem:
Within one of my Access 2003 databases, I have a function which opens a
report for either preview or print. On my system, the report is
generated correctly, with no errors. Once the database is deployed to
a client computer I am finding that the OpenReport call is causing an
Error 2501.


Now, here is where it gets really strange. In my searching, I found
one reference to this being related to the HP Laserjet 5 series of
drivers. So I decided to test this theory out. I changed the default
driver to something other then the HP Laserjet driver and... (trumpets
sounding...) the report was generated perfectly. Therefore, I am
guessing that the information I found was on the right track.


I have played around with several different HP Drivers, but every
single one of them seems to cause this error. My question to the group
is this:


Has anyone else run up against this problem? If so, what have you been
able to do to resolve it? (Changing the users default printer is NOT a
valid option.)


Thanks in Advance!




-Brian-
I'm not an actor, but I play one on TV.

 

[Zygor]

Are you conected to a HP Laserjet 5 series printer?

 

[JediBMC]

The printer is an HP Laserjet 2200, but the driver does state HP Laserjet 2200 /5e.

-Brian-
I'm not an actor, but I play one on TV.

 

[TheAceMan1]

How are ya JediBMC . . . . .

Error 2501 has to do with canceling and can appear for many objects.

This you may find of great interest: Printer Selection Utility

Other than the above, you may have to do some [blue]error traping using [purple]Resume Next[/purple].[/blue]

Hope this helps! . . . . .

See Ya! . . . . . .

 

[PHV]

Have you tried to use a LJ 2200 PCL 6 driver ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886