Choosing specific printer tray via code

[April]

Hi,

I have an Access appl. that allows for the printing of
multiple reports with the single click of a button (uses
code). The client would like one of those multiple reports
to go to a different tray in the same printer (which will
hold special paper for this one report). Is this doable in
code?

Thanks in advance...
April

 

[Andy Debaere]

Yes It is do-able... But how far will you Go?

Do you deploy MDE's? Or Mdb's
What access version do you have? XP?
Do not use code with involves prtdevmode ... because these don't work in an
mde db.
Instead if your using Access XP
Under VBA help check out the printer object:
also check this website:
http://msdn.microsoft.com/library/d...ry/en-us/dnacc2k2/html/ODC_acc10_Printers.asp

 

[Petrucci2000]

Hi,

My name is Eric. Thank you for using the Microsoft Access Newsgroups.

You wrote:
"I have an Access appl. that allows for the printing of multiple reports
with the single click of a button (uses code). The client would like one
of those multiple reports to go to a different tray in the same printer
(which will hold special paper for this one report). Is this doable in
code? "

See:
ACC2000: How to Print a Report to Different Paper Trays
http://support.microsoft.com/default.aspx?scid=kb;en-us;200546

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

 

[Gerrit-Jan Linker]

I just worked on a project that required just this. Direct control of
the paper trays from within VB code. I found that the tray id's are
different for each printer. I wrote a program called PrinterTrays to
help me find out what the tray ids are for each printer. It is
available from www.oraxcel.com with source code. Perhaps this is a
starting point for you...

Best regards, Gerrit-Jan Linker
Linker IT Consulting Limited
www.oraxcel.com