Brad Marks
BradM at blackforestltd.com
Fri Jan 11 15:57:35 CST 2013
Doug, Thanks for the help. There might be some legal issues with PDF and Access 2007 - not sure. I conducted many tests and did some more research on the web. I ran across this quote. "apparently in the runtime version you must have the report open first before you can export it through VBA, in the full version that's not the case" Based on this info, I added a "OpenReport" before the Export to PDF, and a Close of the report after the Export. The results from my initial tests look promising. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Friday, January 11, 2013 2:03 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Problems Exporting to PDF with Access Runtime As I recollect there was some legal issue with pdf in Access 2007 so you had to download or add in something to make it work. It may be that you need this added to your runtime installer. Not sure of all this but it is a vague recollection. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Friday, January 11, 2013 11:24 AM To: Access Developers discussion and problem solving Subject: [AccessD] Problems Exporting to PDF with Access Runtime All, I have a small Access 2007 application that reads a CSV file and creates a single report. The report is exported in PDF format with this code - DoCmd.OutputTo acOutputReport, _ Str_Report_Name, _ "PDFFormat(*.pdf)", _ str_Generated_Report_File_Name, _ False, _ "", _ 0, _ acExportQualityPrint When running with the full version of Access (accdb), everything works nicely, every time it is run. The end-users only have Access Runtime. When using Runtime mode, exporting the report to the PDF file will often fail. Not all of the time, but most of the time. When it fails, the first page of the report is shown correctly. However, the second page of the report has "#error" in all of the fields. I am really puzzled. Any help or insights would be greatly appreciated. Thanks, Brad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.