Printing From Access and choosing the printer tray

[Matt_T_hat]

For one reason or another I need to be able to print to two different trays on the same printer from Access 2000 / XP. One way is to access the printer and switch trays the other is to install "two" printers (the same one twice) and set each to use a different tray by default.

Both ways requrie that I Use Access 2000 and talk to the printers or select the printer from code.

I've looked at this thread: http://vbforums.com/showthread.php?t...printer+access but Access tells me there is no such object as Printer and I've also found some tutorials for word that access the windoews API.

Despite some pritty good guesses as to the possible references (DLLs) I'm no further along in my quest.

It's gotten a bit desperate as the "boss" has prommised that this project will be installed this tuesday. (thanks "mate".)

Any ideas.

[dannymking]

You can try and change the DefaultSource property in the PrtDevMode on the report..

Check out PrtDevMode in the Access VBA Help, if you don't have it I'll post the full explanation.

The coding method you would need would be to open the report in designview, change the defaultsource to the tray required, save, close and re-open the report in print view and then repeat for the next tray.

[Matt_T_hat]

You can try and change the DefaultSource property in the PrtDevMode on the report..

Check out PrtDevMode in the Access VBA Help, if you don't have it I'll post the full explanation.

The coding method you would need would be to open the report in designview, change the defaultsource to the tray required, save, close and re-open the report in print view and then repeat for the next tray.

That sounds acceptable... any code at this stage even if it is an example will be very helpfull.

I'm off to look this stuff up in the help as advised.