Print report to 2 different printers

[Mitch_____W]

I need to print a report one time to the user's default printer and then again to another printer... I print the report using a DoCmd.OpenReport "ReportName" behind a Button on a form. Is there a way to change the page setup properties of a report with code?


Thanks

 

[Calvin]

Its doable but its a complicated subject. Lookup PrtDevMode and PrtDevName , use the following to get started:

http://www.microsoft.com/accessdev/articles/getzch10.htm?&gssnb=1

 

[Mitch_____W]

Whoa!!!! You weren't kidding about it being complicated!! I think I might back up and punt on this one...

 

[simongallop]

Create a copy of the report and in the page setup of the report change the printer on the Page tab (Acc97) and select specific printer. Not pretty but simple!

 

[Mitch_____W]

That is the route I had planned on taking, however it is going to really inflate the size of the DB... I am actually printing 21 pages via 17 reports, once to a printer and then again to the Adobe Acrobat Distiller...

 

[Carol]

Another solution would be to open up the Print Dialog Box through your print command button and manually select the printer. Of course, you would have to run this command twice, but it would save you from having 2 copies of the same report.

 

[Calvin]

Mitch,
You mentioned the Adobe Acrobat Distiller, do you have access to Adobe's ASN developers site? If so writing the code using Adobe's Acrobat SDK and using their API is going to be your solution. That's what they have it for. I beleive they just came out with vs 6.