Im trying to print via vba code in ms access 2010. I have the code in place using application.printer It prints no problems and I can do a drop down box to select which printer to send it to. I can change the page orientation, for some reason however I cannot get it to do copies. I have provided my code below , been working on this for 3 days changing the code around and nothing seems to work. Any help would be greatly appreciated.
this code does indeed change the orientation and print to printer, it wont however do the copies
DoCmd.OpenReport "checkin_blank", acViewPreview
Set rpt = reports("checkin_blank")
rpt.Printer = Application.Printers("hp2050")
.Orientation = acPRORLandscape
.Copies = 2
DoCmd.OpenReport "checkin_blank", acViewNormal