save as pdf using vba

[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?

 

[Allen Browne]

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.

This kind of thing should do it:
strDoc = "Report1"
strFile = "C:\SomeFolder\SomeFile.pdf"
DoCmd.OutputTo acOutputReport, strDoc, acFormatPDF, strFile, True

 

[tricky300]

Thanks Allen, having done a little experiment, I am sure that has pointed me
in a direction that will lead to a solution.

Tricky300