[AccessD] DoCmd.OutputTo problem

Rocky Smolin rockysmolin at bchacc.com
Thu Jan 24 09:47:37 CST 2019

Bob:  I found that removing the last three arguments solved the problem on
my box.  Not sure why but you gotta love Access.  Always a treasure hunt!



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


I've found that sometimes I need to open the report (in hidden mode) before
it will let me output it.
Not always, but sometimes...


From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of Rocky
Sent: Thursday, January 24, 2019 6:25 AM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: [AccessD] DoCmd.OutputTo problem

[Attn: This is an external email.]

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?


Rocky Smolin

Beach Access Software




Skype: rocky.smolin

AccessD mailing list
AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>
Website: http://www.databaseadvisors.com<http://www.databaseadvisors.com>

HealthInsight is a private, nonprofit, community-based organization
dedicated to improving health and health care, with offices in four western
states: Nevada, New Mexico, Oregon and Utah. HealthInsight also has
operations in Seattle, Wash., and Glendale, Calif., supporting End-Stage
Renal Disease Networks in the Western United States. The information and any
materials included in this transmission may contain confidential information
from HealthInsight. The information is intended for use by the person named
on this transmittal. If you are not the intended recipient, be aware that
any disclosure, copying, distribution, or use of the contents of this
transmission is prohibited. If you have received this message in error,
please inform the sender and delete all copies.
AccessD mailing list
AccessD at databaseadvisors.com
Website: http://www.databaseadvisors.com

More information about the AccessD mailing list