Input Box Again

[dvannoy]

Private Sub Report_Activate()
DoCmd.PrintOut acPrintAll, , , , InputBox("How Many Pages&quot
End Sub

this command worked great...

Now I have another question...Is it possible to choose what printer the above command prints to???

I am printing pin feed labels that cannot print on the network laser printer. I have that code behind a button. what I want to do is, when the input box ask's for the number of copies , I want that to print to another printer..

is this possible??

Thanks for your help

 

[LonnieJohnson]

You're starting to get a bit complex. There is a property in VBA called PrtDevMode that allows you to manipulate printers. Go to the tutorial and type this property for details and examples.

Is there any reason you can't send them to a preview of the report and then have them to use the Microsoft printer dialog box in the File menu options? ljprodev@yahoo.com
Professional Development
MS Access Applications