By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,317 Members | 1,329 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,317 IT Pros & Developers. It's quick & easy.

Access fails if printer is out of paper

P: n/a
I'm running an Access 2000 application on users' desktops as a runtime;
the back-end is on a server.

When the user prints an item (a Packing List), I have it coded to print
1 copy of a report to the default printer, and 1 copy of a different
report to a specifically-selected printer. If the specific-destination
printer is out of paper, the entire program shuts down. I have two
identical reports since it was easier for me to create one report with
"default printer" and store the specific destination printer within the
other report.

If there is no paper in the default printer, the code continues as
normal. I see the print job in the printer queue, but no error occurs.

I am using this code to print the report:
DoCmd.OpenReport "rptPackingList_SpecificDest", acViewNormal


Dec 15 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Printers are not my specialty (in fact, not much is), but you may wish
to check your print driver for the specific printer. One of my clients
had all sorts of troubles in Access 2003 until I asked them to change
their network printer driver to a non-PostScript driver. There's a
Knowledge Base article on it - I don't have the specific link handy,
but the Knowledge Base is at

In truth, it seems to me that if your reports are identical, and only
one is having issues, it's probably not the report itself. My first
guess would be the printer driver. Is there another printer of the same
type available that you can specify and run the report to (for

Dec 15 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.