Run-time error ‘2501’ for One User

A

AlwaysFroosh!

I'm trying to figure out why one user of my MDB file is getting this error
when opening a report. As is suggested in all the posts I could find on this
topic, the error happens at this point in the code:

DoCmd.OpenReport Datasheet, acViewPreview

but it's only happening for this one user. When I tried to debug it on his
computer, I found that I can't even open the reports in design view. Does
anyone have any idea what may be causing this??

Thanks,
Graham
 
M

Maurice

Is there a printer installed. If no printer is installed you won't get a
preview.
 
A

AlwaysFroosh!

Yup, there's definitely a whole pile of different printers on our network
that are installed. And remember that I can't even open the report by right
clicking and selecting design view.

Graham
 
J

John Spencer

Is one of those printers designated as the default printer on the
computer that is having the problem? If so, try choosing a different
printer as the default printer. If not, choose one.

Beyond that I can't think of anything else.

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

AlwaysFroosh!

The user has the same default printer as I do, and I have no problems.

I understand that this printer problem could cause the report not to open
into print preview, but I think I should reiterate that the report will not
open in design view either. Has anyone ever heard of that happening? Maybe I
should just get our IT department to reinstall Access...

Graham
 
A

AlwaysFroosh!

Alright, I'm now even more convinced that there is something wrong with
Access. I didn't think of trying this earlier, but I just tried to creat a
new MDB file on the users computer and create a report from scratch. I
couldn't even do that. Same thing, I select create new report and then select
design view, and it does absolutely nothing. I just automatically assumed it
was my fault!!

Thanks for the suggestions anyways, I'll let you know if this fixes it, but
the rate our IT department runs at it could be a while!! ; )

Graham
 
J

John Spencer

Check the printer driver and make sure it is the same/latest version as
the one you have on your computer.

If you can't print then you probably can't create a report either, since
Access uses the printer's metrics when it builds a report format. If it
can't access the printer's metrics then it won't let you build the report.

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