Can I combine reports into one pdf file?

I am currently running an Access application that creates several reports. I want to put these reports into pdf files, and preferably would love to combine all the reports into one pdf file.

Is there anything out there that can do this, short of Acrobat itself? Has anyone encountered this idea and been successful? Are there any free programs available that can do this, and again, preferably not place their logos, etc. onto the file?

Thanks so much in advance to y'all...... a great bunch of folks!


Post your answer or comment

comments powered by Disqus
Looking for a solution to combine several reports into one single PDF file. Just wanna click on one button & then it creates automatic in a folder a single PDF file with all single reports combined into one PDF that can be easy send to the client. I have to combine like details for a event and a contract together.
Anyone experience with this ?

What is the best way to create PDF files of your reports within VBscript? Like to create PDFs of my invoices with the reference number of the invoice automatically in a specific folder for that project.

Using Access 2003 & Adobe Acrobat 3D 7.0... & this is the first time I gonna do this kind of thing...

thx

Gday all,
Have a bit of code (below) that prints 3 seperate reports all to PDF files with the click of a button, however I would like all these to be COMBINED into one PDF file through the use of the same button without having to go and do this action outside of access.....

Any help?

Private Sub Command12_Click()
Dim strDefaultPrinter As String
Dim intCounter As Integer

'save default printer name
strDefaultPrinter = Printer.DeviceName

'cycle through the printers collection till PDFCreator is found
For intCounter = 1 To Printers.Count
If Right$(Printers(intCounter).DeviceName, 10) = "PDFCreator" Then
'use this printer
Set Application.Printer = Printers(intCounter)

'do your PDF print job here
DoCmd.OpenReport "rpt_wr_report"
DoCmd.OpenReport "rpt_wr_delaytbl"
DoCmd.OpenReport "rpt_wr_Recurrent_Defects_Open"
DoCmd.Close acDefault, "rpt_wr_Recurrent_Defects_Open"
DoCmd.Close acDefault, "rpt_wr_delaytbl"
DoCmd.Close acDefault, "rpt_wr_report"


'set printer back to default printer
Set Application.Printer = Printers(strDefaultPrinter)

'all done
Exit Sub
End If
Next intCounter

'no PDF printer found
MsgBox "No PDF Printer was found!", vbExclamation, Application.Name

Can anyone advise me if it is possible to convert the displayed Access Reports into distributable PDF files & if so what software tools are required & problems I may encounter?

regards

Keith

I want to combine several reports, and also some query outputs, into one pdf file. I can do this currently by running each report or query, using PrimoPDF to print it, and then manually selecting the "append" option to append the next report to the existing file. However, this is cumbersome because there are 7 different reports I want to append to one pdf file, multiplied by about 30 different reporting options.

Rather than peform 210+ manual operations, I would sure like to be able to write some code to do this. However I don't see that PrimoPDF makes anything available through VB. So... any ideas?

The pdf writer that is integral to MS Access does not seem to be able to append to an existing pdf file.

Is there a way to do this? Or is it just a wrong-headed approach? Ideas?

Help needed!!
I have report created in Access 2010 originated from a querybased on a table.
My table is called: tblFiledReconn
In order to manipulate what data I want to see in the reportI created a list query called: RptQry_List_Table_For_Entech_Use
Finally I have a report based on this query called:FieldReconnFormReport

There is a field on my table called FacilityID.
What I need is to print a report for each FacilityID into anindividual PDF file containing the FacilityID as part of the file name. At themoment this would be 817 individual reports.

I also wish if I can add a date included on the report whichis on another field called: Date. But again this is a wish and not a must.Since I am not an avid code writer I decided to get the need accomplishedbefore attempting this. Since the Date field is a date, I guess I need toconvert it into string or numbers to the format I desire before adding it tothe name which would made the code more complex.
Searching and reading forums I was able to develop thefollowing code. In this attempt I was trying to accomplish the following.
For each facility ID print a pdf individual report with thefacility id as part of the name followed by "_FRECON.pdf". Forexample for facility ID wwMH84303 the report file name would bewwMH84303_FRECON.pdf
Here is the code:
Code: Private Sub Command0_Click() Dim MyDB As DAO.Database Dim MyRS As DAO.Recordset Dim strSQL As String Dim strRptName As String Dim count As Integer strRptName = "FieldReconnFormReport" strSQL = "Select tblFieldReconn.[FacilityID] FromRptQry_List_Table_For_Entech_Use;" Set MyDB = CurrentDb Set MyRS = MyDB.OpenRecordset(strSQL, dbOpenForwardOnly) With MyRS Do While Not MyRS.EOF DoCmd.OpenReport strRptName, acViewPreview, ,"[FacilityID]=" & ![FacilityID] DoCmd.OutputTo acOutputReport, strRptName, acFormatPDF,"C:Temporary FR Forms" & ![FacilityID] &"_FRECON.pdf" DoCmd.Close acReport, strRptName, acSaveNo .MoveNext Loop End With MyRS.Close Set MyRS = Nothing End Sub The problem is when I run the code there seems to be aproblem with the openreport comand line. A window comes out requesting aparameter value. The Enter Parameter Value window shows the Current Facility IDand a text box. If I hit OK it creates a one page report with blank fields butwith the correct file name. If I type the current Facility Id on the text boxit creates the one page report correctly. So I my guess is that it is notunderstanding the instruction that matches the Facility ID in the report withthe corresponding Facility ID from the recordset ( "[FacilityID]="& ![FacilityID]). Since it does creates the correct file name I assume itis creating the desired recordset. I have spent several hours trying to get itwork but no success. Please help!
Now to the wish part:
As I explained there is also a Date field in the table(,query and report). It would be great if the created file name could be acombination of both. For example for FacilityID: wwMH98765 visited ofDate:11/20/2012 it would be great is the file name could bewwMH98765_FR112012.pdf or better if wwMH98765_FR121120.pdf (year,month,day)
Thanks in advance

How do I combine two reports into one master report?

Thank you

Hello,
In the old version of Access I could easily export a report from print preview into a PDF file. I just got the new version (Access 2007) and I can't find a way to do this. Every export method it lets me do changes the format. I just need the PDF as it looks exactly as my report does on screen and others can open it.

Thanks!

Hi,

I've created and formated 3 individual reports and they are all print ready. My users wants to group and print all 3 of them in one go. I've tried to create a new report and then adding 3 individual reports into one but it won't format the pages correctly.

Is there an easy way to merge reports without having to reformat everything again? It looks ok in report view but in print preview and even after publishing to PDF it looks wrong.

This is off the wall but maybe someone out there can help me with my problem.

I have several custom reports that are sorted in various ways. What I need to do is compile all my reports into one printable document. More specific, I need the report to look like it is one continuous document. Anotherwords, not a space between reports as if I printed all ten individually and stapled them together.

Does this make since and can anybody help?

Thanks,
TIM

How can I export different report into same excel file?
Any suggestions are appreciated.
Thanks in advance.



rfan

Greetings,

Does anyone have any ideas on how to convert multiple access reports into one pdf file using vba script.

I am using Access 2007 and Adobe Professional 9....

The new Adobe Prof has some great Add-Ins which allow for multiple report conversions, however I am hoping to figure out how to do this via vba and not have to manual select the Add-In function each time I want to process the reports...

Would SendKeys be a possibility in order to select the Add In if all other methods fail?

Any advice would be appreciated.

Thanks in advance,

How can I export different report into SAME excel file?
Any suggestions are appreciated.
Thanks in advance.





rfan

man, I have been searching, and have tried different code snippets (you should see my registry and .INI files) here is what I need.
VBA code for Access 2003 using Acrobat Standard version 7.x.
I need to run a report, and have it create a specified PDF file name.
Will be running in a VBA loop running the report for each row.
I have to create like 300 each running.
I don't want their acrobat settings changed after it is done running.
I don't want one PDF file named the same as the report.
Anyone got some code to do that?

Is there a to convert multiple reports to one PDF with VBA? I have a large amount of pdfs to produce around 4000. One of my other large problems I can not download any tools to help with this. I am using access 2010 and I have Adobe PDF Writer installed.

Only other problem Im having is the above.

I can setup a macro to print the reports and I can convert each one to PDF on its own.

Can you Output all reports to one PDF?

Thanks in advance

Sam

hello.

I have two related tables WORKER with worker_ID field as primary key, and WORKERInfo whitch also has worker_ID field. I have created simple Data entry form based on thees two tables, but now i need enter worker_ID data twice (into two text boxes): once for table WORKER and once for table WORKERInfo. How can i add data from one text box into two fields of two tables?

thanks for your attention.

I have several objects which have macros linked to them that send their associated data file to the recipient. Some require more than one file to be sent.
How can I send more than one attachment, in the same email, using SendObject command for an email Macro. Or do I REALLY have to send one attached file per email...
I have the gnawing feeling it's gonna be an easy solution, but I'm just not seeing it.

Thank you for your time (in advance)!!!

Hello to everyone, this is my first post here.

I am new at this, so here is my scenario. I am working on a small access 2007 database to search and keep track of our business forms about 300 or so and some forms has between 2 to 10 pages. All forms were converted to PDF for better security and accessibility. All forms are saved using a form code, for example "fc1000, fc1001" and so on. I also have a jpeg snapshot of each form attached to each record, so the user can visually see how the form looks like.

I need help on the following:
Search and Print a specific pdf form

How do I link and open a PDF file with a primary key field via a button? I know that I need some VBA code. I looked and search everywhere but without luck.

Primary field: formCode, will stored the pdf file name which is "fc1000, fc1001, etc"

Primary key field
formCode
fc1000
fc1001
fc1002

C:Forms”.pdf“
Form name
fc1000
fc1001
fc1002


Thanks in advanced

Hi,
I work in the IT department of a large greenhouse. We are required by law to give a daily report of our pesticide usage. However, because of other reports that I need to do, I keep records from our different product lines in two different tables. (one for plug production and one for finished product) Much of the data is similar e.g. date, time, location, chemical, EPA reg no, dosage, etc. How can I combine these into one report using a query. I want to be able to print a report for a single date combining the similar fields from both tables into one nice,neat printout. Any suggestions?

I have a table called Packages, in this table I have multiple fields with just short dates example of fields (ID), (Home_1), (Home_2), (Home_3) and (Home_4). What I was wondering is there a way to comine all of the Home fields into one for the purpose of counting the number of dates for all the records. Total number of dates of all the Home fields? I am using Access 2010

My DB tracks quality assurance inspections. Each inspection can have 1, 2, or 3 nonconformities. Accordingly, there are 3 possible reports that can run as the final report. The argument/condition of the final report is formatted such that (noncon1=true and all others are false, open report 1... noncon1 and noncon2=true and all others are false, open report 2, etc).

Is there a way to open the appropriate report for all inspections at once? That is, inspection1 had 3 nonconformities (therefore, final report3)... inspection5 only had 1 (therefore, final report1)... can I open both reports and merge them into one?

I suppose I'm probably looking for a resource rather than a straight answer as I don't think this is a quick fix but anything that can get me on the right path would be helpful. I have created a form template that I send a SQL query to show a list of statistics based on a date and shift number query. What I'm trying to do now is create is combine those forms together into one large form. Basically it would look like this:

Stats for all

Stats for 1st shift

Stats for 2nd shift

etc

I've uploaded the report to try and clarify what I am referring to but it does not work because it relies on an external call to create the SQL statement and is only the basic stat report template.

I was hoping I could use the original form template I created and basically just copy it however many times for the shifts I need. I thought this might be easy to do with subreports or grouping but I'm not sure how to go about iterating the creation of each report. Any advice would be helpful.

hello,

I have a report that prints all the transactions for all the accounts into one giant pdf. I email each of the account letters individually to about 35 accounts and right now its a time consuming task to go in to the giant pdf and extract each accounts pdf individually... I would like to be able to have access loop through each account and print a pdf for that individual account into a specified folder.

question is how can I loop through each account and print a pdf for that account and send it to a specified folder?

Thanks in advance!
RM

Our office runs MS Access 2003. I’ve been working on a little database. It’s what you could probably call a “skills” database. A report on the different skill sets is generated from the database and uploaded to the web. Prior to my volunteering to automate all the work that was being done manually people were editing separate look a like word documents, printing to PDF and uploading to the intranet. A lot of it seemed like a waste of time to me. Me and my big mouth.

Up until a short while ago I was stumped as to how I could;

1. Print each group to a separate file, and;
2. Print the files as PDF.
I worked out how to output the reports as RTF (though not separately, but as everyone will no doubt know you lose all your report formatting (lines, graphics, etc) when outputting your report as RTF. It wasn’t good enough.

I hit on the idea of hacking together the code that let me print to RTF and the lebans code that lets you print a report to PDF. This is how I did it;

Ingredients;

Files
dynapdf.dll
StrStorage.dll
And Module modReportToPDF
from http://www.lebans.com/

An access database with a query based report that is grouped on one particular data item. Lets call it DB1.
A form (menu or otherwise) that could hold a combobox and a command button . Lets call it FormA.


Procedure

1. Copy dll files to same folder as the database or system folder as described on http://www.lebans.com/
2. Copy Module modReportToPDF to the module library of database DB1
3. Create a global string variable for use as the individual file names. Lets call it GroupVar

e.g - Global Groupvar as String

4. Create an unbound combobox on FormA. Lets call it cboCombo0
Rowsource Type = Table/Query
Rowsource = SELECT TABLE.iNDEXFIELDNAME, TABLE.GROUPFIELDNAME (IF NOT INDEX FIELD) FROM TABLE ORDER BY [GROUPFIELDNAME];
If Index field is the field your report is grouped on then the bound column would be 1. If it’s a second field then the bound column would be 2.

5. Put a command button on Form A (lets call it cmdReportGen.
6. Open your report in Design View
7. Make a note of the name of the field that displays your group name
8. In the “On Format” event for the section of the report within which your group field is place the following; Groupvar = fieldname
9. Place the following code (appropriately amended) against the “On Click” event of cmdReportGen;

Private Sub cmdReportGen_Click()
'Posted by ADezii 5.23.2009 on bytes.com
'Modified by Gina Whipp 11.4.2009 to OutputTo Multiple Files
'Tested in Access 2003
'Adapted to print multiple PDF files based on report grouping
'and save files named for report groups - Stephan 15 September 2010

Dim intCounter As Integer
Dim cboCode As ComboBox
Dim blRet As Boolean
Dim stDocName As String

stDocName = "ReportName"

Set cboCode = Me![cboCombo0]

'If Your Data Type is a String
For intCounter = 0 To cboCode.ListCount - 1
DoCmd.OpenReport stDocName, acViewPreview, , "[Field name for Report grouping] = '" & cboCode.ItemData(intCounter) & "'"
DoEvents
blRet = ConvertReportToPDF(stDocName, vbNullString, _
"D:Temp" & GroupVar & ".pdf", False, True, 150, "", "", 0, 0, 0)
'The variable "GroupVar" has beeen declared globally and is initialised at the "OnFormat" event of report generation
'It's then passed to the file name here and cleared just before the end of each loop
GroupVar = ""
DoCmd.Close acReport, stDocName
Next

MsgBox "Your files have been saved to D:temp with individual category names", vbOKOnly

End Sub


There’s no error control and it’s hacked to bits but it works. I hope somebody else can use it.

Cheers
Stephan


Not finding an answer? Try a Google search.