Print to different trays

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have an Access 97 database. In it there is a report that
prints several 2 page letters. Example (100 pages - 50 2
page letters). I want to print page 1 of each letter on
letterhead from an upper paper tray. I want to print page
2 of each letter on plain paper from a lower paper tray.
How do I do this?

Thanks if you have an answer

Mark
Ontario, Canada
 
Mark,

Buy a duplexer for your printer and print the 2 page
letter onto the letterhead (front and back) alternatively
print your letterhead logos etc from access onto plain
paper. It will be easier than trying to get Access to
switch trays. I have heard of people coding a way around
this limitation but I have no idea what was involved .....
maybe someone more capable than me can offer a solution?

Not much help I'm afraid,

Terry
 
Mark:

There are multiple ways to do this, however none of them are particularly
"elegant" solutions.

The problem is that Access can not change the tray assignment of a report
while it is running, flipping between trays. So you have a few options:

1.) Create two reports, one which represents the first page and one which
represents the second page and send them in succession to the printer so
that the whole thing prints in one batch with two print jobs.

2.) Search the MS knowledge base for an article on how to print the odd or
even pages of a report, and combine that will code that after printing the
odd pages (i.e. the pages that go to letter head), you open the report in
design mode via code, and switch the tray assignment, save the report and
pirnt the even pages, then reverse the process to reset the tray for the
next time you start the process so that it prints to the tray with
letterhead. Again, two print jobs with a bunch of code in the middle to
switch tray assignments for your one report.

3.) Use something like our On the Fly Printing code and classes to switch
the tray assignments for you via code, but to do this, you'd end up having
to filter the report, one recipient at a time, printing first to the
letterhead tray and then to the plain paper tray, so you'd have 50 or so
print jobs. You'll find this on our web.
 
Back
Top