printing to multiple trays

[Justin]

Does anyone know how to set this up in Access 2000?

I need to be able to print packing slips to multiple trays on a single
printer. (ie. two paper colors)
Thanks.

[Allen Browne]

The simplest solution is to create two reports.
In report design view, choose Page Setup from the File menu, and specify the
printer for each.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Justin" <Ov*********@hotmail.com> wrote in message
news:8c**************************@posting.google.c om...

Does anyone know how to set this up in Access 2000?

I need to be able to print packing slips to multiple trays on a single
printer. (ie. two paper colors)
Thanks.

[Sigurd Bruteig]

"Justin" <Ov*********@hotmail.com> skrev i melding
news:8c**************************@posting.google.c om...

Does anyone know how to set this up in Access 2000?

I need to be able to print packing slips to multiple trays on a single
printer. (ie. two paper colors)
Thanks.

You could try out this code, that opens the printer dialog and select trays
from there:

DoCmd.RunCommand acCmdPrint

Sigurd

[Tony Toews]

Ov*********@hotmail.com (Justin) wrote:

Does anyone know how to set this up in Access 2000?

I need to be able to print packing slips to multiple trays on a single
printer. (ie. two paper colors)

The most complex solution is to use PrtDevMode which requires significent expertise
in VBA code and that you can't use an MDE.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm