Code which tray to print from

[flaviooooo]

Hey,

I have a database that is being used by 2 different users.

There is a report that will always need to print from their printer tray 2 (labels), but they use a different printer (2 different types as well off course)

If I set in the page setup of the report that the tray 2 needs to be used from the default printer... it doesn't seem to work on both printers

I tried this link, to no avail

http://support.microsoft.com/kb/179321

(the report always prints from the default tray 3)

Any idea how to force this in VBA?

I'm using Access 97 btw

Grtz
Fabian

 

[genomon]

XP (2002) and later has a redesigned printer object model. If there is any way you can develop on one of the newer platforms, this link will show you all you need, plus a bunch of other neat stuff:

http://msdn.microsoft.com/en-us/library/aa139946(office.10).aspx

All I ask is a chance to prove that money can’t make me happy.