Changing Printer in Reports

Topic

New Reply

Hi,

Does anyone know of a simple way to change printers while printing various parts of a report. To be specific (to change trays). I want to print e.g pages 1, 3, 8 and 15 from a tray containing headed paper and the others (2,4,,5,6,7,9-14) to a seond tray/printer. The page numbers I have found using some vba and I want to change the active printer depending on the page I am currently printing. The layout of the pages will not change as the printers are the same. I’ve read that the PRTDEVMODE property is read only when previewing a report.

Any help or sample code greatly received
Thanks
Jason

Reply | Quote

Replies

Hi Jason,

Here are to Knowledgebase articles that may have your answer. Hope this helps.

How to change printer trays from Access 2000.

http://support.microsoft.com/support/kb/ar…=0&qry=changing printer&rnk=6&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

How to use code to change a reports printer.

http://support.microsoft.com/support/kb/ar…=0&qry=changing printer&rnk=18&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

Warren

Reply | Quote

Thanks for the Access help. I am already using both of those reports, I was just expecting Access97 to offer a more elegant way to produce it.

At present it looks like i have run run the Format or print Event of a report to get all the page numbers. (Page numbers at Group Headers are on a different priter)
Then loop through pages choosing correct printer before opening and printing report.

Jason

Reply | Quote