[AccessD] Access VBA code (loop) needed

[John Bodin]

I use PDF995 for any PDF programming.  In your case, you could use the Burst feature to separate the single PDF into multiple PDF's.  Call the EXE with parameters.  Free to use but you get a browser popup nag every time you call it.  $9.95 to buy.   I've been using it for many years.  Good luck.

John

-----Original Message-----
From: AccessD <accessd-bounces+jbodin=sbor.com at databaseadvisors.com> On Behalf Of DENISE A DECENSO via AccessD
Sent: Friday, October 25, 2024 5:13 PM
To: AccessD at databaseadvisors.com
Cc: DENISE A DECENSO <DADECENS at sentara.com>
Subject: [AccessD] Access VBA code (loop) needed

Hello, I have a simple access database used only to create and export reports as pdf files.
It  produces a single large multi-page report for many employers (each having its own page) and I would like to save each employer as its own separate pdf, with the employer as the file name. Currently it is being done manually print/save 1 at a time.

Here is the relevant information:
   the data source to be output to pdf is a report named [FundingReport]
   the critical field in the report is [EmployerName].  The report is grouped and sorted on that field.
   the report has a natural page break with the content for each [EmployerName].
   there are about 550 pages (employers) in total.

   the goal is to output to pdf a file for each Employer report with that [EmployerName] as the file name.

  Other notes:
  Using Access 2016. There is no "DAO" in the library, so any code I've found that has DAO is failing.

I appreciate any help you can give me.

Thank you,
Denise DeCenso


Disclaimer:


This electronic message and its contents and attachments contain information from Sentara Health and is confidential or otherwise protected from disclosure. The information is intended to be for the addressee only.

If you are not the addressee, any disclosure, copy, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify us immediately and destroy the original message and all copies.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com