Set printer options programmatically

[byurow]

Hello,

I am trying to help my non-technical users I have a Access 2003 report that I need to print 6 pages on 1 sheet and rotate it 180 degrees. It is easy enough (for most people) to just go into the printer settings (i.e. rotate printer orientation 180 degrees and print 6 pages per sheet) and set them. However, my users are not your normal users and are having issues. So, my question is.....is there a way, in VBA to automate printer settings without user interation?

Thanks!

Brenda

 

[genomon]

Have a look here:

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

There is also a sample mdb with code to download.

Ever notice how fast Windows runs? Me neither.