OutputTo pdf?

[HelpTheNewbie]

I am running VBA code attached to a button on a form. Among other things the button imports and Excel file and then asks if the user would like to view a report of the imported data. I would like to allow this to be exported to PDF format, but can't quite seem to get the syntax or something. Here is what I have:

DoCmd.OpenReport "RemittanceReport", acPreview
DoCmd.OutputTo cOutputReport, "RemittanceReport", "*.pdf", "C:\Example.pdf"

I get an error saying "The format in which you are attempting to output the current object is not available." I would greatly appreciate any help.

 

[KernelK]

Do you have the full version of Acrobat? and not just the reader? You will need a specialized plugin to accomplish this as .pdf files are proprietary from Adobe, and Access has no built in features for this. Search on GOogle for more info, heres is one choice link from a quick search:
http://groups.google.com/group/micr...5785ffac300/463c6ddee29cbe7c#463c6ddee29cbe7c

 

[HelpTheNewbie]

Okay. I have the full version of Adobe. How can I do what this one user suggests?

"set that printer as the special printer for that report (and save it in design view)"

Thanks so much for your help!

 

[GUIDO22]

Okay. I have the full version of Adobe. How can I do what this one user suggests?

"set that printer as the special printer for that report (and save it in design view)"

Thanks so much for your help!

In Access 2007 - you cant.... (see link http://allenbrowne.com/Access2007.html#Bugs), at present.... sorry!