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!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: