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.