From: Albert D. Kallal on
"Arno R" <arracomn_o_s_p_a_m(a)planet.nl> wrote in message
news:4c29e9ad$0$14124$703f8584(a)textnews.kpn.nl...
> 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
>

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(a)msn.com


From: Albert D. Kallal on
sorry, link here:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm


From: Arno R on
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(a)msn.com> schreef in bericht news:h9vWn.5780$3%3.3668(a)newsfe23.iad...
> sorry, link here:
>
> http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm
>
>


From: Albert D. Kallal on
"Arno R" <arracomn_o_s_p_a_m(a)planet.nl> wrote in message
news:4c2b79df$0$14122$703f8584(a)textnews.kpn.nl...
> 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.
>

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(a)msn.com



From: Arno R on
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(a)msn.com> schreef in bericht news:5nXWn.4147$oN4.2379(a)newsfe04.iad...
> "Arno R" <arracomn_o_s_p_a_m(a)planet.nl> wrote in message news:4c2b79df$0$14122$703f8584(a)textnews.kpn.nl...
>> 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.
>>
>
> 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(a)msn.com
>
>
>