Output a report in PDF format ?

[ostraly09]

Hi everybody,

Does anybody know how to ouput and send automatically an Access report in PDF format?

Thanks in advance,
Sydney

 

[jrbarnett]

To output an access report from VBA take this FAQ:

http://www.tek-tips.com/faqs.cfm?spid=703&sfid=2533

and use the output file as an attachment with
DoCmd.SendObject.

John

 

[ostraly09]

Thanks for all this code, it's exactly that i need.
Sydney

 

[ostraly09]

One more thing !! When executing the above module, path to output PDF file is given but doesn't appear when executing. Module ask me where to output the PDF file.

So I guess the following instruction doesn't change the correct Registry key :
SetKeyValue "Software\Adobe\Acrobat PDFWriter", "PDFFilename", strPath, REG_SZ

Does anybody know what key should be changed. We run Acrobat Writer Version 4.0
Sydney

 

[longmot]

The pdf writer is also asking me for the path even though its in the code. Did anyone find a solution to this?

Thanks

 

[dgwilliams]

k