Printing to Adobe Printer

[RevDocJeff]

How can I specify an adobe printer and the variables it asks for, ie. file name, location..., when printing a report using a module?

Thanks

 

[trucktime]

Printer

RevDocJeff,

here is a file with MDB's in Access 97 and 2003 which demonstrate
how to select a printer at runtime and subsequently print a report.
The user can select name and destination.

 

[ghudson]

You can call the print dialog if you want to allow your users to select the printer of their choice. The Adobe "printer" option will allow them to choose where the file will be saved to and the file name to be saved.

DoCmd.RunCommand acCmdPrint

Ensure that you trap for error # 2501 [if the user clicks the Cancel button].

You could open the report in the print preview mode and then call the print dialog or give the user a toolbar button to call it when needed.

 

[RevDocJeff]

Ok, but I'm trying to figure out how to specify the file name and location in code. I have about 20 reports that I run daily and for each one I have to open it up, print to the adobe printer, and specify the path and name. I want to be able to do all this in code. The path will be the same for each, but they will all have different names. My goal is to push a button and have them all print out to the same location with different names.

 

[Tiro Cupidus]

You can use SendKeys.