Printing access reports into pdf 1

[ElGuapo]

Hello!

I have an access report that I am outputing to pdf for use on a web page. I do this by using the Pdf writer. That works fine.

However I have multiple reports that need to be saved as pdf files, so I have automated the process by using the VB. I now control the pdf writer dialogs by using the Sendkeys() function, which is unreliable and some of the settings can not be set this way.

So I would like to use the Acrobat Object library to control the dialog. I found it, but am do not know quite how to use it, as I am new with using object libraries.

Anybody knows where I could learn more about it?

Rok

 

[20132]

Can you please post a code on how to print Access report into .PDF.

Thank you

 

[RMS10]

This may help.

http://www.planetpdf.com/mainpage.asp?WebPageID=336

 

[20132]

Not really. I need to produce .pdf, rather then print an existing one. Do you have any other suggestions?

 

[RMS10]

Download the adobe sdk. Look for examples at planetpdf.com.

 

[accessguy52]

Guapo - you said you had code that prints multiple reports into .PDF form from Access. Can you please share your code with us? We'd all appreciate it. Many thanks! accessguy52

http://www.aspensys.com

 

[accessguy52]

OK, does anyone know how to SAVE an access report in .pdf or can that be done?

accessguy52

http://www.aspensys.com

 

[KyleS]

Yeah, it can be done. I have the code burried somewhere and am looking for it right now. I used Distiller to "print" the report to PDF. The only pro9blem was getting it to give your report a name other than the report name or putting the file somewhere other than the default folder (I believe it's "Output" or something to that effect). So I used simple NT commands Move and Rename to move the file and/or rename it after it had "printed". Kyle

 

[accessguy52]

Kyle - good. When you find the code can you please post it here for everybody (including me?). I can only get it work in Excel. Many thanks! accessguy52

http://www.aspensys.com

 

[DH]

Anyone find a solution for this yet? or have a code example?

DH

 

[accessguy52]

DH - looks like we're in the same bind. If it helps you any, see also JabbaTheNuts' code for saving Excel to pdf thread under Adobe Acrobat threads. Good luck. accessguy52

 

[KyleS]

Hi guys,
Sorry for the delay, can't find the code to save my life, which is bad since it took me quite a while to perfect...

Check this link out though:

http://www.mvps.org/access/reports/rpt0011.htm

It's pretty good, and if you guys have any questions, let me know.

Kyle

 

[accessguy52]

Thanks, Kyle. I went and downloaded from that link and I'll give it a try. But, keep an eye out for that code, anyway.

take care

accessguy52

 

[KyleS]

I will, if I find it, I'll post it, whether it's really needed or not, just on principle!

I hate rewriting code, and this was a lot of code! Kyle