I wonder if anyone has taken on this particular problem before:
There is a particular contract I use in some of my business transactions. There are several blanks in the contract where I fill in appropriate information according to the transaction. I only have this contract in a .pdf format so I print it out each time and write in the necessary information. I am trying to create a Report in Access (where I store the data that I enter into the blanks on the contract) that will save me the time of hand-writing each contract.
The closest I have come so far is this:
I saved each of the 8 pages of the contract as an .eps and use that graphic as the backdrop in my Access report. I inserted the necessary fields from Access into the appropriate places in the report and it printed out fine. Unfortunately, the contract is eight pages long and I cannot fit eight full-page size .eps graphics into the details section of my Access Report. Apparently Access only allows detail sections of its reports to be 22 inches long, max. With each page 11 inches tall, I can only fit two pages on one report.
Ultimately, I would like to use one command button in my form to print out this long report. If that means the command button pulls up 4 reports (pages 1 and 2, 3 and 4, 5 and 6, and 7 and 8) and somehow merges all of those into one report then so be it. Even if it merges them and exports them to MS Word, so be it. I've even tried putting the contract .eps graphic in MS Word and tried to use a mail-merge-like function to draw the data from Access into Word. No luck.
I checked to see if there is a way to make Access allow a bigger details section. Nothing.
And so here I sit, after about 3 hours of experimenting, and I must finally turn to the experts at tek-tips for their suggestions.
Got any ideas?
--rj
There is a particular contract I use in some of my business transactions. There are several blanks in the contract where I fill in appropriate information according to the transaction. I only have this contract in a .pdf format so I print it out each time and write in the necessary information. I am trying to create a Report in Access (where I store the data that I enter into the blanks on the contract) that will save me the time of hand-writing each contract.
The closest I have come so far is this:
I saved each of the 8 pages of the contract as an .eps and use that graphic as the backdrop in my Access report. I inserted the necessary fields from Access into the appropriate places in the report and it printed out fine. Unfortunately, the contract is eight pages long and I cannot fit eight full-page size .eps graphics into the details section of my Access Report. Apparently Access only allows detail sections of its reports to be 22 inches long, max. With each page 11 inches tall, I can only fit two pages on one report.
Ultimately, I would like to use one command button in my form to print out this long report. If that means the command button pulls up 4 reports (pages 1 and 2, 3 and 4, 5 and 6, and 7 and 8) and somehow merges all of those into one report then so be it. Even if it merges them and exports them to MS Word, so be it. I've even tried putting the contract .eps graphic in MS Word and tried to use a mail-merge-like function to draw the data from Access into Word. No luck.
I checked to see if there is a way to make Access allow a bigger details section. Nothing.
And so here I sit, after about 3 hours of experimenting, and I must finally turn to the experts at tek-tips for their suggestions.
Got any ideas?
--rj
