VBA Looping In Access
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
Software/Hardware used:
Software/Hardware used:
ASKED:
October 19, 2009 4:10 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
