Connecting Tech Pros Worldwide Forums | Help | Site Map

Using MS2007, can not ouput report to .pdf format - possible Add-in issue

Member
 
Join Date: May 2007
Posts: 103
#1: Oct 9 '09
I am trying to create a pdf file for a report and I am using the following:
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OutputTo acOutputReport, "MyReportName", acFormatPDF, "C:\MyReportName.PDF"
After running this code, it does not print my report in the specified location "C:\MyReportName.PDF" . I am wondering this.... When I got to the big 'Office' button, go down to "Access Options" and look at 'Add-Ins',
there is one listed for:
'Acrobat PDFMaker Office COM Addin', however, above this in light grey lettering it says "Disabled Application Add-ins".

I am assuming that this is the add in that allows pdf's to be created. Looks like mine is disabled so I figure that is why I can not create the report in the pdf format (it does not give me error, just doesn't create it). If this is the case, how to I 'enable' this feature/add-in?
best answer - posted by ChipR
At the bottom of the Access Options window, Add-ins tab, I have a combo box that says
Manage: [Com Add-ins] Go...
Do you have that?

Expert
 
Join Date: Jul 2008
Location: Maryland
Posts: 1,186
#2: Oct 9 '09

re: Using MS2007, can not ouput report to .pdf format - possible Add-in issue


At the bottom of the Access Options window, Add-ins tab, I have a combo box that says
Manage: [Com Add-ins] Go...
Do you have that?
Member
 
Join Date: May 2007
Posts: 103
#3: Oct 9 '09

re: Using MS2007, can not ouput report to .pdf format - possible Add-in issue


Yes I do have that same combo box.
Expert
 
Join Date: Jul 2008
Location: Maryland
Posts: 1,186
#4: Oct 9 '09

re: Using MS2007, can not ouput report to .pdf format - possible Add-in issue


So...problem solved?
Member
 
Join Date: May 2007
Posts: 103
#5: Oct 9 '09

re: Using MS2007, can not ouput report to .pdf format - possible Add-in issue


Yes! I checked the box next to the 'Adobe PDFmaker' and clicked on okay. That must have enabled the add-in. I just ran my code again and the pdf was created and in the correct folder!! THANK YOU!!! We just upgraded to MS2007 so I am still learning the differences for 2007 and 2000.
Reply