Mark Simms
marksimms at verizon.net
Sat Jan 12 19:27:25 CST 2013
Did you try changing to a lower quality ? Print quality really not needed for most applications. BTW: I experienced the same recently....PDF failed, but XPS format option succeeded....despite it being a much larger size... Go figure. > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd- > bounces at databaseadvisors.com] On Behalf Of Brad Marks > Sent: Friday, January 11, 2013 2:24 PM > 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