[AccessD] Access VBA code (loop) needed

[DENISE A DECENSO]

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.