• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2064
  • Last Modified:

Split one MS Acess report into multiple .pdfs

I have a MS Access report that is grouped by Location.  I would like to give the end-user the ability to push a button and the result would be that the report would be exported into multiple .pdf reports - one for each location.

Can anyone tell me how I could do this in vba?


1 Solution
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
User free : http://www.pdf995.com/ 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Access 2007 has a free add-in from Microsoft to add a the built in ability to create a PDF. No need need for a printer drive solution.

I actually have an example I built that does exactly what you want.  

See: Batch Printing and Save As PDF

AmadeusC27Author Commented:
THANK YOU!  I'm so happy that this question was resolved so quickly.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now