Have Report Print to a Specific Printer Paper Tray in MDE

[Bill Hymel]

RE: Have Report Print to a Specific Printer Paper Tray in MDE



Just wondering if you have a solution for this problem -



I need to be able to print an Invoice with the 'terms and conditions' on the
back side of an Invoice. To do this, I would load preprinted paper (with
the terms and conditions already printed on the back side) into a different
paper tray than the default paper tray. Then, somewhere in my code, I need
to instruct some of the Invoice 'copies' to print to the paper tray
containing the preprinted forms. The 'Access Program' is an 'mde' and I won't
know what dual-tray laser jet printers my customers will be using.



Thanks in Advance!

 

[SA]

Bill:

This is practically impossible to do in an mde, because you can't set the
tray assignment at run time via code (of course you can do it if you preview
the report or use the print dialog). The work around might be to set up
multiple copies of the report to target different tray assignment numbers,
however in this day and age, many printer drivers use non-standard numbers
for tray assignments (i.e. the tray value is above 256), especially if the
tray is an add on option for the printer. Because of that you'd need to
specify the tray number as required by the printer at run time and there's
no way to modify that in code in a mde. Again, if you want a specific tray
in an MDE the only way to do that is to preview the report and/or then
select the tray using the print dialog. Otherwise, you need to use an mdb.