save as pdf using vba

  • Thread starter Thread starter tricky300
  • Start date Start date
T

tricky300

Hi,

Thanks to anyone that can help.

I have downloaded and installed Microsoft's useful 'extra' to save as pdf
within Access 2007. It works a treat but now I want to automate the SaveAs
procedure on a report using vba but have been unable to find out if this is
possible.

Does anyone out there know how to do it?
 
tricky300 said:
I have downloaded and installed Microsoft's useful 'extra' to save as
pdf within Access 2007. It works a treat but now I want to automate the
Saveas procedure on a report using vba but have been unable to find
out if this is possible.
Click to expand...

This kind of thing should do it:
strDoc = "Report1"
strFile = "C:\SomeFolder\SomeFile.pdf"
DoCmd.OutputTo acOutputReport, strDoc, acFormatPDF, strFile, True
 
Thanks Allen, having done a little experiment, I am sure that has pointed me
in a direction that will lead to a solution.

Tricky300
 
Back
Top