[AccessD] DoCmd.OutputTo problem

[Gustav Brock]

Hi Rocky

The format string is incorrect. It is easier to use the constant (resolves to "PDF Format (*.pdf)":

DoCmd.OutputTo acOutputReport, "rptRentalAgreement", acFormatPDF, strRAPDFName, False, , , acExportQualityPrint

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces at databaseadvisors.com> På vegne af Rocky Smolin
Sendt: 24. januar 2019 15:25
Til: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Emne: [AccessD] DoCmd.OutputTo problem

Dear list:

 

This is Access 2010 question.  I have an app which needs to output a report in pdf format.  I'm using the statement:

 

DoCmd.OutputTo acOutputReport, "rptRentalAgreement", "PDFFormat(*.pdf)", strRAPDFName, False, "", , acExportQualityPrint

 

When the program reaches this statement, it does not create the pdf, does not go to the next statement, and does not give a run time error.

 

I can't find anything on the web forums addressing this particular problem.


 

Any ideas?

 

MTIA,

 

 

Rocky Smolin

Beach Access Software

760-683-5777

 <http://www.bchacc.com> www.bchacc.com

 <http://www.e-z-mrp.com> www.e-z-mrp.com

Skype: rocky.smolin