If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
many reports into one pdf
Hi,
I have 4 reports; RPT1, RPT2, RPT3, RPT4. My goal is to compile these 4 reports into a single pdf file. When I print a single report into pdf, I used print-acrobat distiller option. Should I change options in pdf or can I do it in Access? Thanks. |
#2
|
|||
|
|||
That's a good question. I've just been creating separate .PDF files for each
report and then assembling them in Acrobat. It'd be much more convenient if there was an option to append to an existing Acrobat file, but I'm not aware that there is. Maybe someone else will know. BTW, what do you do about page numbers? "kunon2" wrote: Hi, I have 4 reports; RPT1, RPT2, RPT3, RPT4. My goal is to compile these 4 reports into a single pdf file. When I print a single report into pdf, I used print-acrobat distiller option. Should I change options in pdf or can I do it in Access? Thanks. |
#3
|
|||
|
|||
Regarding the page number, I created tables for the last pages numbers, and
then use them in the next report. |
#4
|
|||
|
|||
Interesting. How do you get the last page numbers into a table?
I've looked through the Acrobat documentation and it looks to me like it will always create a new file when converting an Office document to .PDF. "kunon2" wrote: Regarding the page number, I created tables for the last pages numbers, and then use them in the next report. |
#5
|
|||
|
|||
Currently, my reports are not compiled yet, but they have consecutive page
numbers. This is what fredg suggested. Add a new table to the database. Add one Field, Number datatype, Integer Field Size. Name this field "LastPage" Enter a 0 as it's value. Name this table "tblLastPage" Code the first Report Detail Print event: CurrentDb.Execute "Update tblLastPage Set tblLastPage.LastPage = " & Me.[Pages] & ";", dbFailOnError Code the second Report Page Footer Format event: Me.[Page] = DLookUp("[LastPage]","tblLastPage") + 1 Done! Good luck. |
#6
|
|||
|
|||
Currently, my reports are not compiled yet, but they have consecutive page
numbers. This is what fredg suggested. Add a new table to the database. Add one Field, Number datatype, Integer Field Size. Name this field "LastPage" Enter a 0 as it's value. Name this table "tblLastPage" Code the first Report Detail Print event: CurrentDb.Execute "Update tblLastPage Set tblLastPage.LastPage = " & Me.[Pages] & ";", dbFailOnError This is a corrected part. In the second report, at the "page number" text box property, set "Data", "Control Source" as =[Page]+DLookUp("[LastPage]","tblLastPage") Really Done! Good luck. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Send Access reports via email - password protect | [email protected] | Setting Up & Running Reports | 2 | May 25th, 2005 12:28 PM |
Blank Pages at the beginning of Parent Report with 5 child or sub reports | Cyndy Sheehan | Setting Up & Running Reports | 1 | March 4th, 2005 10:36 PM |
Need Reports to Reference New Queries | Jenn | General Discussion | 0 | January 31st, 2005 06:17 PM |
Shifting Weeks for Quarterly Reports | setoFairfax | General Discussion | 1 | September 8th, 2004 05:43 PM |
Need help w/ reports | Tom | Setting Up & Running Reports | 0 | June 25th, 2004 05:59 PM |