Earliest Version for "acFormatPDF"

[sdawson]

Looking for earliest version of Access in which I can format a report as a PDF file to attach to email.

Using this at present - DoCmd.SendObject acSendReport, "Myreport", acFormatHTML

Want to use this - DoCmd.SendObject acSendReport, "Myreport", acFormatPDF

Thanks

 

[Ranman256]

i believe its 2010

 

[Gasman]

I am able to use it in 2007.

Have not used with SendObject though?

    DoCmd.OutputTo acOutputReport, "", acFormatPDF, stFTPpath & stParam & ".pdf", False

 

[HiTechCoach]

Office 2007 was the first version of Office with the ability to save to a PDF format via an add-in. Office 201o and later has the add-in built-in.

see: 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS

 

[Ranman256]

I cannot use it in 2007.

 

[HiTechCoach]

sdawson,

To answer the subject line about acFormatPDF, it was introduces with Office 2007.

My customers have been saving reports to a PDF for many years now using DoCmd.OutputTo with acFormatPDF.

I just noticed that you were also asking about DoCmd.SendObject using the acForamtPDF.

Since I don't normally use DoCmd.SendObject I don't remember if it supports the acForamtPDF option in 2007.

When I get a chance to fire up a VM with Office 20076 I will try DoCmd.SendObject with acForamtPDF.

It maybe the DoCmd.SendObject with acForamtPDF that Ranman256 was referring to with "I cannot use it in 2007. "

 

[The_Doc_Man]

Note also that Access treats "translators" as options, so the question might include whether the option for PDF output was selected at installation time. Nor do I have a copy of 2007 where I could look at the kit to see what the default was for that version.

 

[HiTechCoach]

I was able to test the SendOjbject with acForamtPDF and it works just fine with Access 2007 SP3.

 

[HiTechCoach]

I cannot use it in 2007.

Make sure you have the Office 2007 SP2 update or later installed.

There is a 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS that is required to be installed manually is you have the original release or Service Pack 1 installed.

Starting with Service Pack 2 by default it adds the export and save to the PDF and XPS formats in eight 2007 Microsoft Office programs. It also allows you to send as e-mail attachment in the PDF and XPS formats in a subset of these programs. Which includes Access.

 

[marlan]

It's an old thread, but this post may give a good answer (Iv'e just neede it now )

BTW, if you are runnin .mdb file in a Acc2007 enviroment or higher, DoCmd.SendObject should work, just put in the real value of the constant acFormatPDF (that is "PDF Format (*.pdf)", Iv'e just checked it) it should create the PDF. It depends on the enviroment, not the file type.