[AccessD] Combine 2 PDF reports into 1 PDF file

[Gustav Brock]

Hi Joe

Uh, sorry, I don't use it myself, so I have no idea - I just recognised the topic and, initially, ignored it, as you originally stated that no third-party tools should be used.

You could sign up at UA. Albert will surely be able to help you.

/gustav

-----Oprindelig meddelelse-----
Fra: Joe O'Connell <joeo at appoli.com> 
Sendt: 15. marts 2021 01:43
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Cc: Gustav Brock <gustav at cactus.dk>
Emne: RE: [AccessD] Combine 2 PDF reports into 1 PDF file

Gustav,

This looks like an easy to implement solution.  I downloaded MergePDF.zip, extracted the files, created a.pdf and b.pdf in the same folder, and compiled the access program with no errors.  When I attempted to run Sub TestMerge2, the object MyPDF seemed to be created correctly with the call to CreateObjectNET, but the line to add the first PDF file generated this error:
Run-time error '91':
Object variable or With block variable not set

 Is there a reference that needs to be included?

Joe

-----Original Message-----
From: AccessD <accessd-bounces+joeo=appoli.com at databaseadvisors.com> On Behalf Of Gustav Brock via AccessD
Sent: Sunday, March 14, 2021 4:57 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Cc: Gustav Brock <gustav at cactus.dk>
Subject: Re: [AccessD] Combine 2 PDF reports into 1 PDF file

Hi Joe

A current thread on UtterAccess deals with this:

UtterAccess.com<https://utteraccess.com/topics/2060859>

/gustav

________________________________
Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> på vegne af Joe O'Connell <joeo at appoli.com>
Sendt: 14. marts 2021 19:46
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Combine 2 PDF reports into 1 PDF file

Doug,

I will give it a try.  Thank you.

Joe

-----Original Message-----
From: AccessD <accessd-bounces+joeo=appoli.com at databaseadvisors.com> On Behalf Of dw-murphy at cox.net
Sent: Sunday, March 14, 2021 1:48 PM
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Combine 2 PDF reports into 1 PDF file

The free Bullzip driver is based on biopdf. Use the biopdf printer to programmatically merge pdf files, https://www.biopdf.com/. They do charge for using their driver, but the cost is reasonable. I had to go back and see how I did this work in 2014. Sorry for the previous link.

Doug

-----Original Message-----
From: AccessD <accessd-bounces+dw-murphy=cox.net at databaseadvisors.com> On Behalf Of Joe O'Connell
Sent: Sunday, March 14, 2021 10:30 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Combine 2 PDF reports into 1 PDF file

Thanks for the link.  Access can create PDF files, this product seems to be a replacement for the Access capability.  There is a stand-alone merge program For combining two or more PDF files.  I did not see any way to interface this program from the Access application.  Do you know if there are APIs to this merge capability?

Joe

-----Original Message-----
From: AccessD <accessd-bounces+joeo=appoli.com at databaseadvisors.com> On Behalf Of dw-murphy at cox.net
Sent: Sunday, March 14, 2021 1:12 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Combine 2 PDF reports into 1 PDF file

The pdf print driver from Bullzip allows appending documents and can be controlled programmatically, https://www.bullzip.com/products/pdf/info.php.

-----Original Message-----
From: AccessD <accessd-bounces+dw-murphy=cox.net at databaseadvisors.com> On Behalf Of Joe O'Connell
Sent: Sunday, March 14, 2021 7:38 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: [AccessD] Combine 2 PDF reports into 1 PDF file

I have an Access 2016 application that creates 2 reports in PDF format.
After these PDF files are created, is there any way to combine them into a single PDF file without using third party software like Adobe Acrobat Pro?

Joe O'Connell