[AccessD] Access VBA code (loop) needed

[Stuart McLachlan]

I use Bullzip PDF Printer for personal use, but DoCmd.OutputTo works fine for client Access 
applications and doesn't depend on an external application.  


On 26 Oct 2024 at 12:29, John Bodin via AccessD wrote:

> 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 -- AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd Website:
> http://www.databaseadvisors.com