Disable Output To (1 Viewer)

abbaddon223

Registered User.
Local time
Today, 00:38
Joined
Mar 13, 2010
Messages
162
Hi,

I'm using the following command to output a form as a PDF

DoCmd.OutputTo acOutputForm, "Frm_RTA", acPDF, outputFileName

outputFileName is a variable I've created for file path / name etc

When I run this command, I get a popup box asking what format I'd like to export / save the form as. I'd like to disable this and just have it save as a PDF.

Is anyone able to help me please?

Thanks,

Phil.
 

Tiger955

Registered User.
Local time
Today, 09:38
Joined
Sep 13, 2013
Messages
140
It should work like this:
DoCmd.OutputTo acOutputForm, "Frm_RTA", acFormatPDF, "c:\test.pdf"

Michael
 

abbaddon223

Registered User.
Local time
Today, 00:38
Joined
Mar 13, 2010
Messages
162
Yeah I was missing the Format bit - well spotted and thank you!!! :banghead:
 

Users who are viewing this thread

Top Bottom