Hi all,

I need to print to (or publish) an Access report to pdf with code.
This is a standard option with Access 2007 (SP2)

BUT....I don't want to use the option on the ribbon for this.
I need/want to code this.

Any ideas?
Thanks, Arno R

Am 29.06.2010 14:40, schrieb Arno R:
Hi,

you could use:
DoCmd.OutputTo acOutputReport, "repName", acFormatPDF

if you have installed the "save as pdf and xps" addin for Office 2007
and you need a pdf creator.

This function has some more arguments, to get more information, mark
OutputTo and press F1.

Regards
Jörn

Try this:

DoCmd.RunCommand acCmdPublishFixedFormat

Jon

"Arno R" <arracomn_o_s_p_a_m (AT) planet (DOT) nl> wrote

Thanks,
I needed the standard functionality to 'print as PDF' on a custom toolbar.
This is meant for 2003 apps used by the Access2007 Runtime where I do NOT want to show the ribbon.

But this code option is very useful also.

Regards, Arno R


"Jörn Bosse" <joernbosse (AT) gmx (DOT) de> schreef in bericht news:88uec2FqlsU1 (AT) mid (DOT) uni-berlin.de...

Thanks,
Exactly what I needed...
I only needed to search for the value of the constant to avoid a compile error in Access2003

I needed the functionality on a custom toolbar.
Now I can code in Access2003 and distribute the app with the Access 2007 Runtime.

Regards, Arno R


"Jon Lewis" <jon.lewis (AT) cutthespambtinternet (DOT) com> schreef in bericht news:bumdnXyT4ZDbmLfRnZ2dnUVZ8u2dnZ2d (AT) bt (DOT) com...

"Arno R" <arracomn_o_s_p_a_m (AT) planet (DOT) nl> wrote

I have a download sample here:

In the above, I have a PDF button on the ribbon, and ALSO even a email as
PDF button on the ribbon.


Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
NoSpam_kallal (AT) msn (DOT) com

sorry, link here:

http://www.members.shaw.ca/AlbertKal...s/DownLoad.htm

Hi Albert,

Thanks for the link, but I was NOT looking for an option on the ribbon...
I needed the standard functionality to 'print as PDF' on a custom toolbar.
This is meant for 2003 apps used by the Access2007 Runtime where I do NOT want to show the ribbon.

However the XML code maybe useful.

Regards, ArnoR



"Albert D. Kallal" <PleaseNOOOsPAMmkallal (AT) msn (DOT) com> schreef in bericht news:h9vWn.5780$3%3.3668 (AT) newsfe23 (DOT) iad...

"Arno R" <arracomn_o_s_p_a_m (AT) planet (DOT) nl> wrote

Ok, first keep in mind that office 2007 and 2010 don't "print" as pdf. The
feature is native, and thus you save your document as a PDF. It only those
PDF printers you install that work that way, not applications that have pdf
support built in like office.

So, just have your menu bar button call some VBA code to save the report as
PDF.

So, in a standard code module, you can place:

Public Function SaveAsPDF()

DoCmd.OutputTo acOutputReport, Screen.ActiveReport.name, acFormatPDF


End Function

so, then on your menu bar button, just set the on action to the above

eg:

=SaveAsPdf()

So, it only one line of code in a module, and your menu bar button code can
then call the above VBA code as per above. If you not talking about a custom
menu bar button, then just call the code behind a button like:

SaveAsPDF



Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
kallal (AT) msn (DOT) com

Thanks again Albert,

I allready figured this out.
FYI: I also needed to change the (unknown to Access2003) constant acFormatPDF to "PDF Format (*.pdf)" since Access 2003 would not
compile anymore...

Arno R


"Albert D. Kallal" <PleaseNOOOsPAMmkallal (AT) msn (DOT) com> schreef in bericht news:5nXWn.4147$oN4.2379 (AT) newsfe04 (DOT) iad...