Print Reports to PDF

[Walter]

Hello,

I put all my report as subreport into one report and I want to print the new
all report as a PDF file. I have the below coding behind a button and it
works great, but I would like to choice a file name and directory to save the
PDF file. Is this possible? If yes, how would I do it.

Thank you,

Walter


Private Sub cmdExportToPDF_Click()

DoCmd.OutputTo acOutputReport, "rptMetricAll", acFormatPDF,
"cDFReports\" & "rptMetricAll" & ".pdf", False

End Sub

 

[Benjamins via AccessMonster.com]

Hi,

Try this to choice file name and location
http://www.mvps.org/access/api/api0001.htm