save as pdf in access 2007

  • Thread starter Thread starter sumGirl
  • Start date Start date
S

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.
 
The basic idea is:

DoCmd.OutputTo acOutputReport, "Report1", acFormatPDF, strFile, True
 
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 -
Click to expand...

Wow - an easy answer from a famous Access guy! Thanks Allen!
 
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
 
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.
 
Back
Top