saving a pdf automatically 1

[Razor1]

I have a program that creates a pdf from a report. Acrobat PDF opens a dialog box to save the PDF. I need a way to have the PDF document saved to a specific location and a specfic name without intervention from the end user.

Any help would be greatly appreciated.



Razor1

 

[MajP]

What version of access? If in 2007 it is very simple

Public Sub saveReport(rptName As String)
Const path = "C:\"
DoCmd.OutputTo acOutputReport, rptName, acFormatPDF, path & rptName & ".pdf"

End Sub

Public Sub testrpt()
saveReport "rpt1"
End Sub

 

[MajP]

http://www.lebans.com/reporttopdf.htm

for prior versions.

 

[Razor1]

I am using Access 2003.

Razor1

 

[MajP]

OK, I think you need the lebans file.

 

[Razor1]

Thanks. That stops the dialog box. How do I stop adobe from opening up. I do not need to see the report. I just need to save it in a folder which the code does.


Razor1

 

[seaport]

It is up to the PDF Writer software's configuration whether a pdf file is opened by the default reader right after the file has been created.

 

[Razor1]

Thanks for the help.

The opening of adobe after the creation is in the printer settings under Adobe PDF Settings. Uncheck View Adobe PDF Results. To change the saving of the file with out being prompted you can select Adobe PDF Output Folder.

THis solution works in QAdobe Version 9. I don't know about other versions.

Razor1