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

printing to multiple trays

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.

Nov 12 '05 #2

P: n/a

"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
Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.