By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,245 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,245 IT Pros & Developers. It's quick & easy.

Saving a report as a ,pdf file in MS2007

P: 167
I want to automate saving a report as a .pdf file in MS2007. I can preview the file and then choose 'Save as' to get it created as .pdf, however, what I need to do is put code behind a button that does some other functions along with automatically running a report that will get created as a .pdf in a designated location.
Currently using MS2000 and use Adobe Pro 8 to accoumplish this. With the add-in feature of MS2007 that allows you to create .pdf's, was hoping to do away with using Adobe to create the .pdf.
Does anyone know how I could automate this?

Jun 15 '09 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 378
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OutputTo acOutputReport, "Report Name", acFormatPDF, "C:\YourReportName.PDF"
This should be exactly what you need.
Jun 15 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.