Print each report to a different printer tray: Access 2003

[Hector Robles]

Hi,

We have the need to print color coded work order cards. So we bought a
multi-tray printer in order to have diferent color paper loaded per tray. We
are looking for a way that the operator has to do the minimun to direct the
print jobs into a specific tray. The first try was to make several printer
installations each configured with a different tray and they work ok when we
pick the printer from the normal Windows Print Screen. But in Access when we
use the comand:

Set Application.Printer = Application.Printers("HP LaserJet Tray 2")

"HP LaserJet Tray 2" is configured to use as paper source "Tray 2". So by
having this command the report gets printed automatically to that printer but
it uses the default Tray "Tray 1" and ignores the settings that I put on the
printers preferences on the Printer and Faxes Screen.

PS: the printer has 6 trays.

Regards.

 

[Tom van Stiphout]

On Wed, 16 Jul 2008 16:49:01 -0700, Hector Robles <Hector
(e-mail address removed)> wrote:

I don't know why this does not work, but I do know that you can set
the printer tray programmatically using the Printer object. HOWEVER,
there is a nasty bug in that code that does not allow you to set the
PaperBin to a number greater than 255. Higher numbers are quite common
and AFAIK Access cannot deal with them.
So I created 6 copies of the same report, called them rptWorOrder1
through 6, and at design time set the correct printer+tray. That
worked for me.

-Tom.