[AccessD] Problems Exporting to PDF with Access Runtime

Mark,

Thanks for the assistance.

I learned that to export a report to a PDF file (with Access Runtime) it appears that the report needs to be Opened before the Export and then Closed after the Export. 

This is not needed for the Full Version of Access, however.

Brad   


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Mark Simms
Sent: Sat 1/12/2013 7:27 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Problems Exporting to PDF with Access Runtime
 
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


-- 
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.