Create multiple pdf's from a report using vba

[Guest]

Hello All;

For my laboratory we create lab reports. I have an Access report which
prints lab results for many customers. Most of the lab results are 1 page but
some are 2 or 3 pages. I would like to create individual pdf files for each
customer from that one Access report. Is this possible using VBA so a person
does not have to print each customer's report one at a time and produce the
pdf one at a time?

TIA for any suggestions

Bob Wardlow

 

[Terry]

Bob,

Have a look at:

http://ourworld.compuserve.com/homepages/attac-
cg/acgsoft.htm

We use this library to create individual PDFs from 1
report and it works as suggested by their website. From
memory the cost wasn't exhorbitant. My attitude is "Why re-
invent a wheel".

hth,

Terry

 

[Guest]

Thank You,

I prefer not to "reinvent the wheel"

Bob