Report to PDF file

[FoFa]

man, I have been searching, and have tried different code snippets (you should see my registry and .INI files) here is what I need.
VBA code for Access 2003 using Acrobat Standard version 7.x.
I need to run a report, and have it create a specified PDF file name.
Will be running in a VBA loop running the report for each row.
I have to create like 300 each running.
I don't want their acrobat settings changed after it is done running.
I don't want one PDF file named the same as the report.
Anyone got some code to do that?

 

[ByteMyzer]

http://www.lebans.com/reporttopdf.htm

 

[Charmed7]

I didn't ask for, I just did a search and found the post, but that link was awesome. Thanks for the info. It worked great.

-Charmed