I have Access 2010 and Adobe Acrobat 11 Pro.
When I was using Access 2010 with Adobe Acrobat 10 Pro, I used the following code to save my report to a PDF file.
DoCmd.OutputTo acOutputReport, "rptCalendar_Month", acFormatPDF, "c:\TimeOff.pdf", False
Now that I'm using Access 2010 with Acrobat 11, my code no longer works and I get the following runtime error:
VB Runtime Error 2282: The format in which you are attempting to output the current object is not available
I need some VBA code that will save my Access report to a PDF file.
Can anyone help me?
Thanks in advance!