how to generate multiple files from one report via access and pdf
January 5, 2011 3:38 PM   Subscribe

i need to print an access report to pdf and have it spit out a file for each company in the report. help please.

i have a report in ms access (2003) that consists of 50 companiesʻ monthly data. i want to print this report to PDF and have it output a separate PDF file for each company automatically. i want the file name to be the same as the company name.

how can i do this (easily)? i am not proficient in VB, though i think could modify an existing script, if it were clear enough. i do have the acrobat pdf driver installed.

thanks!
posted by elle.jeezy to Computers & Internet (1 answer total)
 
I've been looking around for something similar for my own purposes and I have seen some VB scripts geared towards Adobe users. This is one of them. My special snowflake situation is that we don't have Adobe where I work. :/

Are you able to get hold of Access 2007? Apparently it has PDF export built-in.

Access World Forums has been a useful place to find answers.
posted by desjardins at 7:52 PM on January 6, 2011


« Older Digital frame with video, sound and motion sensor...   |   splitting a froghair three ways-or, who is right? Newer »
This thread is closed to new comments.


Tags

Share