How to print a report from a different tray?

  • Thread starter Thread starter Shadow
  • Start date Start date
S

Shadow

It would be great if somebody has an answer and show me how to overcome this
task in a Microsoft Access application.

I have a printer on a small LAN with 4 trays.
Each tray is filled with different paper colors (red-blue-green-white)
In a search result form I have a print button which prints a report based on
the search results.
Is it possible to change the default tray of a printer in vba (when the
print button is clicked)?

this is my situation:
Windows Xp Pro Sp2 (Armed with the latest updates)
Microsoft Office 2003

Any kind of help is much appreciated.
 
Shadow said:
It would be great if somebody has an answer and show me how to
overcome this task in a Microsoft Access application.

I have a printer on a small LAN with 4 trays.
Each tray is filled with different paper colors (red-blue-green-white)
In a search result form I have a print button which prints a report
based on the search results.
Is it possible to change the default tray of a printer in vba (when
the print button is clicked)?

this is my situation:
Windows Xp Pro Sp2 (Armed with the latest updates)
Microsoft Office 2003

Any kind of help is much appreciated.
Click to expand...
Hi,
you have to use Printer object.
Help on line (F1) is very clear

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it
 
Back
Top