convert access reports to pdf using vba

[Alibaba2003]

Hi,
I have an access 2000 database that have some reports that I like to archive as adobe pdf reports. I need to automate the process using vba. I found code on the internet that works with old adobe writers and previous versions of access. Any clue to where I can find an updated code for my issue?

thanks for your help
Alibaba

It's Nice to Be Important But It's more Important to BE Nice

 

[Alibaba2003]

I apologize ladies and gentlemen .. the code is posted under this link.

http://www.tek-tips.com/viewthread.cfm?qid=1119207&page=1

Keep in mind that you need to programatically change the report caption before you convert the file to pdf

Regards
Alibaba

It's Nice to Be Important But It's more Important to BE Nice