Access fails if printer is out of paper

[tzinno]

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

Thanks,
Tammy

[Steve]

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 http://support.microsoft.com/search/?adv=1
..

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
troubleshooting)?