"David Trivette" <un********@yahoo.com> wrote in message
news:34**************************@posting.google.c om...
I was wondering if anyone could help me with a MS Access 2002 issue
I'm having.
Problem - I created a db in Access 97 which worked just fine for
several years. In the db the user can generate reports straight to a
printer after a query has run. The user of this db just got a new
computer with Windows XP and Access 2002.
Now when the user runs the report the following error message is
displayed:
"There was a problem retrieving printer information for this object.
The object may have been sent to a printer that is unavailable."
I don't recall specifying a specific printer that this db would use
which I thought I could check in the report's design. But after
converting the db from 97 to 2002 I could not check the report's
design without getting the same error message. I even tried to create
a new report but cannot do that either, I get the same message.
Any and all suggestions is greatly appreciated.
Thanks,
David Trivette
I had this problem once and it was a nightmare!
I did not document the procedure, so I am doing this from 2-3 month old
memory. Hopefully I can remember it correctly...
1. In Windows change your default printer to another printer. If you only
have one printer, install another one and set it as the default.
2. YOU MUST DO THE FOLLOWING STEPS FOR EACH REPORT:
A. Highlight (don't double-click) the report and go to the page setup
(File-->Page Setup)
B. Click the 'Page' tab
C. In the "Printer For NameOFReport" click the "Default Printer" option
(even though it's already selected.)
D. Click OK.
E. Repeat steps A-D for each report in the database (this is the
nightmare part...)
3. In Windows change your printer back to the real default printer.
4. I can't remember, but I may have had to repeat all of the above steps
after the printer was changed back...
Hopefully someone else found an easier solution. I did see one post that
suggested the problem was the printer driver (This was a HP color laserjet
of some sort)...
hth,
--
Jeff Frent
Gargoyle, Inc.
www.gargoyleinc.com