Print report to file using code?

[gwilton]

I would like to send a report to a specific printer which uses "File" as the port. Using code I would like to output the report and give it a directory and filename without user intervention. Any help would be greatly appreciated.

 

[AWithers]

Did you know you can save printer settings for each report see

http://msdn.microsoft.com/library/d...ry/en-us/dnacc2k2/html/ODC_acc10_Printers.asp

this is what I copied from there

Saving Printer Settings with a Form or Report
Whether a form or report uses the settings of the default application printer (the settings managed with the Application.Printer object) is determined by whether the form or report has previously saved printer settings. Printer settings for a form or report can be saved two ways:

A user can save printer settings by opening the form or report in any view, and then clicking the Page Setup command on the File menu.
You can make changes to the Printer object of a form or report in code, and those changes will be saved with the form or report if you use the DocCmd.Save method before closing the form or report, or specify acSaveYes for the Save argument when using the DoCmd.Close method to close the form or report.

Hope this helps

Andy