Adding a last page to a report in MS Access

ebooyens
ebooyens used Ask the Experts™
on
I'm looking for some help with adding a last page to a report in MS Access 2010.  Basically my client gave me their T&Cs as a scanned PDF, they don't have the original text, and this needs to be added on a report so it can be e-mailed in PDF to customers, the T&Cs need be the last page with no footers etc. but I can't see how to do this.  If I add this in as an image on the footer of the report it creates chaos, for some reason the resulting PDF is 8 pages long...

Any suggestions would be appreciated!  Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I'd type the text into a report of its own - series of text boxes and/or labels.
Then add this at the end as a subreport - perhaps add a page break immediately before it, so it is always a new page.


Kelvin

Author

Commented:
Thank you Kelvin but I expected this to have the same results as an image and it does.  I've managed to get it down to four pages, I think my image was running over to four pages.

I should say that I'm still using the image, it's a LOT of text to retype or even OCR, correct and format, and I can't see how this will make a difference in how many pages I'll end up with.

Thanks
Can you OCR into a rtf document? You can then format it and paste it in. How many pages in their pdf - if 4 in that, then you'll struggle to reduce that.
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

Author

Commented:
No it's one page but 4 columns with lines etc. and the page has been turned 90 degrees so it prints landscape even though the report is portrait.  I just struggle to see how if the sub report contains text and not an image it will solve my problem.  Thanks.
Firstly, if main report is portrait, then you're going to have to to have to somehow get the image/rtf to rotate as alandscape subreport will spill over pages when printedin a portrait report - probably where your issue is coming from. Now Access does allow for text in labels to be vertical (rotate through 90 degrees)  so you may be able to pull something off there. You have to scan into a rtf and pick the bits off bit by bit and paste in and assemble a bit like a jigsaw. If the text can fit in one page as a pdf, then it can be made to fit on one page in an Access report, but a simple paste won't deliver. You MUST get it into text - you can control fonts and size from there and eventually make it fit a single page. Don't see it as a problem that can't be solved - just a new challenbge to overcome. That's what makes programming and development worth doing.

Kelvin
Commented:
Kelvin, you're missing the problem completely, whether the terms and conditions are text or image doesn't make any difference to how many pages they occupy, it's all about the sections in the report and they amount of space the objects take up which determines how they get split across pages.  Of now removed the page header and page footer sections and moved everything into the report header and report footer (and details of course) sections and it's doing what I want, if the details run into two pages though it's going to look weird.

Thanks anyways.
No, I did not miss the point.  A lanscape image will not fir a portrait report. You can make any text fit within a single page with patience - even taking headers an footers into account - but it will have to be done bit but bit so you can manage fonts etc. By using a subreport, you can size it to fit inside one page of your main report. Once you have those sizes, you make you text fit. If you print this on its own it will be one page. Add it to the main report with a page break immediately before it. If you got the subreport height & width right in design, it will fit one page.

You could try scanning as an image and sizing the image to fir one page (can't remember of you can rotate an image though as I rarely use images).

Kelvin

Author

Commented:
The image is a landscape image turned 90 degrees to fit on a portrait page and it is now working correctly because of the change I've made in the report sections, nothing to do with whether it's text or an image or whether it's in a sub form or not.
Good, please you could solve it.

Author

Commented:
Placing the image at the end of the report footer section just smaller than a full page and making sure the page header and page footer sections are empty gets the result I'm looking for

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial