[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2026
  • 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?

Thanks!

0
AmadeusC27
Asked:
AmadeusC27
1 Solution
 
Raheman M. AbdulCommented:
User free : http://www.pdf995.com/ 
0
 
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



0
 
AmadeusC27Author Commented:
THANK YOU!  I'm so happy that this question was resolved so quickly.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

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