I am trying to create a PDF file from within Access 2010. I just converted from Windows XP running Access 2003. Now I am on Windows 7 with Access 2010. The following work on 2003 but the PDF creations doesn’t on 2010. Private Sub PrintInvoiceWithForm_Click() On Error GoTo Err_PrintInvoiceWithForm_Click Dim stDocName As String stDocName = "rptCustomerInvoiceWithForm" DoCmd.OpenReport stDocName, acNormal DoCmd.OpenReport stDocName, acNormal stDocName = "rptTermsOfSale" DoCmd.OpenReport stDocName, acNormal stDocName = "rptCustomerDeliveryWithForm" DoCmd.OpenReport stDocName, acNormal stDocName = "rptCustomerPackingWithForm" DoCmd.OpenReport stDocName, acNormal stDocName = "rptCustomerInvoiceWithFormPDF" DoCmd.OpenReport stDocName, acNormal (This is what does not work now) Exit_PrintInvoiceWithForm_Click: Exit Sub Err_PrintInvoiceWithForm_Click: MsgBox Err.Description Resume Exit_PrintInvoiceWithForm_Click The report has the printer setup for Adobe PDF. If I try using the print process form an open report within Access it works to create a PDF file. Any suggestion would be appreciated.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!