Macro: Print using two printers?

[DeanRowe]

Hi,

I have a standard Laser Printer called "Lexmark" which I obviously use to print my reports onto paper.

Occasionally I need a PDF copy so I open the report, click "Print..." and select my "PDF Printer" to make a PDF version

I'm now requiring equal amounts of printed paper reports and PDF versions....

I would like one macro to tell access to print the report using the "Lexmark" printer, and another macro to tell access to print using the "PDF printer".

Does anyone know if this is possible, or do I need to continue to do this manually?

Thank you for your time.

Dean

 

[MSAccessRookie]

Hi,

I have a standard Laser Printer called "Lexmark" which I obviously use to print my reports onto paper.

Occasionally I need a PDF copy so I open the report, click "Print..." and select my "PDF Printer" to make a PDF version

I'm now requiring equal amounts of printed paper reports and PDF versions....

I would like one macro to tell access to print the report using the "Lexmark" printer, and another macro to tell access to print using the "PDF printer".

Does anyone know if this is possible, or do I need to continue to do this manually?

Thank you for your time.

Dean

If I recall, you can direct any report to either the standard default printer (In your case LexMark?) or any other specific printer (in your case PDF?). This is done in the report settings options, although I am not exactly sure how.

 

[DeanRowe]

Thank you for your post, I've taken a look at the settings and nothing jumps out at me to suggest it would be possible. The other problem with this option would be I would have to set the report to just one or the other. For example "ReportOne" would have to be "PDF" only, or "lexmark" only.

 

[JohnLee]

Hi

I would suggest that you create another instance of that report based on the same underlying table/query and then assign each instance of the report to each printer in the properties of each report, then create a macro that triggers each report to run at the same time, and assign that macro to a button on your form or call that macro if you are using code to initiate the printing of the reports.

Hope this is helpful.

John

 

[DeanRowe]

Hi JohnLee,

I had considered that option as a worst case scenario but was looking to see if there were any alternatives - the report is redesigned frequently and so I worry that I'll have to redesign the report twice, or more likely the person who takes over the database after myself won't remember to change the design of both reports.

It's the best option so far, and I think I may have to go with it as I haven't been able to find any alternatives when I've been looking around.

Thanks for your time JohnLee