Change Print Settings

[krnsmartazz]

I have 3 printers hooked up to one computer.
I want to know the code that will let me assign each report tp a different printer.
So if I have 75 reports: 1-25 goes to first printer etc...

 

[LonnieJohnson]

http://www.mvps.org/access/reports/rpt0009.htm

prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

May God bless you in the year 2002.

 

[krnsmartazz]

I can use code from that database. Thanks
However what is the code that will let me assign the reports to different printers?

 

[LonnieJohnson]

I'm not sure what you mean, but SendKeys ^P will open the printer dialog box for you if you want to put this behind a command button or in a report's On Load event.

prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

May God bless you in the year 2002.

 

[krnsmartazz]

Let me clerify what i want to do. I want to have a form that retrives a list of printers installed. Then retrieve a list of reports. I want to be able to assign the reports to a certain printer.

 

[gamble007]

You dont need to do this with code, since it gets more complicated on Win2000 and WinXP. Open the report in design view, click on page setup<page<Use specific printer. Then all you have to do is choose which printer to output to. I did it with code before but realised it was way easier without.

 

[krnsmartazz]

the people that use my db don't know anything about computers. They just know how to use the program. And it is sort of imposssible to change 100 reports and 70 different locations. So could you please give me the code?

 

[gamble007]

Here's a link that will supply all the code that is required

http://www.microsoft.com/accessdev/articles/getzch10.htm#List

Good luck!