SteveL13
asked on
How merge three reports into one pdf file
I have a database with three reports that I want to merge into one pdf file. How can I do this via VBA code?
--Steve
--Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried to create a mew master report and put the reports in subreports but some of the report sections don't appear. ???
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Steve,
There is nt a built in Way in Office to merge together PDF files.
The good news is there is a free tool that can merge PDF files together. I have been using it with Access form many years now. Once you import eh modules, you only have to add a few lines of code to your application.
Check out: http://www.lebans.com/reporttopdf.htm
I have use it successfully with Access 2000,2002,2003,2007,2007,2 010, and 2013.
There is nt a built in Way in Office to merge together PDF files.
The good news is there is a free tool that can merge PDF files together. I have been using it with Access form many years now. Once you import eh modules, you only have to add a few lines of code to your application.
Check out: http://www.lebans.com/reporttopdf.htm
I have use it successfully with Access 2000,2002,2003,2007,2007,2
ASKER
Boyd,
I don't have a clue as to how to use it.
I don't have a clue as to how to use it.
The instructions are in the code.
That sample is popular with versions of Access prior to 2007 (that had no direct PDF support)
I had not noticed that it could now merge PDF's
It worked fine for me, the very first time it tried it.
Took about a minute to read/modify the code
Examine the sample fully, I am sure with your experience here with VBA, it will be simpler than you thought...
Jeff
That sample is popular with versions of Access prior to 2007 (that had no direct PDF support)
I had not noticed that it could now merge PDF's
It worked fine for me, the very first time it tried it.
Took about a minute to read/modify the code
Examine the sample fully, I am sure with your experience here with VBA, it will be simpler than you thought...
Jeff
ASKER
I imported these objects from the downloaded mdb file:
clsCommonDialog
modDocumentSource
modReportToPDF
HowToUse
READMEFIRST
Right so far?
But then I don't know where to put the names of the reports I want to combine into one report.
clsCommonDialog
modDocumentSource
modReportToPDF
HowToUse
READMEFIRST
Right so far?
But then I don't know where to put the names of the reports I want to combine into one report.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
To all... I'm still experimenting with this.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER