[AccessD] DoCmd.OutputTo problem

[Rocky Smolin]

Gustav:

Actually found what seems to be the solution by removing the last three
arguments and just ending the statement with the file name.

I'll have to see now whether that works on the client's box. 

Best,

R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gustav Brock
Sent: Thursday, January 24, 2019 6:44 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] DoCmd.OutputTo problem

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 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com