Printing 2 Report by 2 separate printers

  • Thread starter Thread starter Mota
  • Start date Start date
M

Mota

Hello;
I have 2 reports,named OrdersRpt and PricesRpt,and want to print them by two
separate printers connected to my system.I use this code to print them by
default printer:

Private Sub cmdPrint_Click
DoCmd.OpenReport "OrdersRpt"
DoEvents
DoCmd.OpenReport "PricesRpt"
MsgBox "Two reports been printed
Successfully",VbOkOnly+VbInformation,"Printing Reports"
End Sub

The prints are followingly,but since paper sizes are not equal i preffer to
send them to two separate printers and print them synchronizingly.How can i
do this?What to add to my code and where?any suggestion?
Thank you so much in advance.
 
Rename the current reports to CurrentReportName_PrtA. Then copy each report
to CurrentReportName_PrtB. Open each of the *PrtB reports in turn and
select the second printer.

hth

-Larry-
 
Thank you for ur attention;
I want to do this automatically thru code.Do u know a solution?
Thank you.
 
Problem is how to select second printer THROUGH CODE.Can u help me?
Thank you for ur help
 
If you look at the Application.printers object, you can find all the
printers available, and select them by name or number from code. See the
help for some examples.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top