Print to PDF - pass filename in

C

cathywoodford

Hello. Here is the code that I have to print a report in access to pdf
and I was wondering if there was a way to have it so that the filename
is automatically passed into the dialog that pops up. That way the
only thing the user has to do is pick a location to save the file?

Application.Printers("DriverNameOfYourPrinterChoice")
DoCmd.OpenReport "YourReportName", acViewNormal
Set Application.Printer = Nothing

Hope someone can help.

Thanks,
Cathy
 
A

Alp Bekisoglu

Hi Cathy,

In my case, I have set the printer for the report to "Specific Printer" and
chose Acrobat Distiller. When I select print while report is viewed,
distiller automatically gets the report name as the file name to be saved.

Not sure if this is what you are searching for, but hope it makes sense.

Alp
 
Top