save as pdf in access 2007

[sumGirl]

I have the add-on to allow saving objects as xps & pdf. Could someone
post an access module/vba script that demonstrates how to export an
access report to pdf? Its easy enough to do manually, but I would like
to program my form to allow a user to save to pdf without any required
interaction.

 

[Allen Browne]

The basic idea is:

DoCmd.OutputTo acOutputReport, "Report1", acFormatPDF, strFile, True

 

[sumGirl]

The basic idea is:

DoCmd.OutputTo acOutputReport, "Report1", acFormatPDF, strFile, True

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.






- Show quoted text -

Wow - an easy answer from a famous Access guy! Thanks Allen!

 

[Guest]

Hi Allen,

Can you tell me where to find the Access2003 add-in to convert to PDF?
Unfortunately, its only available for Access 2007.

Sarah

 

[Guest]

Check out Stephen Lebans' site at:

http://lebans.com/reporttopdf.htm


Set up a button and you get a report a PDF of the report - 1 step!!

HTH

 

[Guest]

How would you print a report using a where such as this in the
Docmd.openreport:

DoCmd.OpenReport "CharacterReport", acViewNormal, , "[Character
Database].[ID] = " & CharacterT

I tried embedding this syntax in place of Report1 in your example and no joy.