I have a report in Access which pulls from one table in an Access databse. In the table there is one record for each "Region" and when I run my Access report it then creates one big pdf file containing a one page report for each region. How can I write a peice of VBA code that will loop the report and create a seperate pdf file for each record in the table the Access report is pulling from? Basically instead of getting a big pdf file with 1000 pages I need to have it broken out into 1000 seperate pdf files when it prints. Any help would be appriciated. Thanks
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!