Continuous report or something similar in Access

I'm working with multiple report pages, each of which contains memo fields with lengthy responses. My ultimate goal is to create a master report that contains all of the "pages" in one report so that the detail for each record prints as collated pages. Because of the memo fields, the number of pages needs to be flexible. I'm able to get three of the original report pages into one report (working perfectly with collation) before I hit the 22" height limitation.

Is there a way for me to build the master report usiing "building blocks" or buttons that reference VBA code for each of the original reports? Like a section that says "insert report A here," "insert Report B here," and so on?

Or does anyone have any other suggestions? Your help, as always, is GREATLY appreciated!!
behestAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

thenelsonCommented:
You could use subreports.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
In addition to Nelson's comment, you can also set your subreports/controls to CanGrow=Yes, and then set the height of those controls to be very small (like .25"). Access will "grow" those reports as needed, and you'll not go outside the 22" restriction.

0
behestAuthor Commented:
I tried to use subreports with grouping but didn't have any success. Since each of the original pages is not a sub of the first page...it contains completely independent fields that are a continuation of the report. None of the data is a summary of the main data. Will that still work?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

behestAuthor Commented:
Found something that is along the lines of what I think I need to do...from tbsgadi...
Private Sub Report_Open(Cancel As Integer)
    LoadItemsData
End Sub  
Used to call a report.  Could something like this be used to program sections of a report? Trying to figure this one out...
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
That code snippet doesn't "call" a report. It's an event that is fired when a report is opened.

Subreports don't have to be related to the main report. They are often used for formatting purposes (as is the case here). I'm still not sure why you have 3 memo fields that take up the entire 22" height of your detail section; I have several report with many memo fields in that report, and the detail section is barely 8" in height - but then I set my fields to be very small in height, and make sure they can grow as needed.

You wrote this:

"Is there a way for me to build the master report usiing "building blocks" or buttons that reference VBA code for each of the original reports? Like a section that says "insert report A here," "insert Report B here," and so on? "

Do you mean you wish to give END USERS the ability to add reports to a single master report?

It seems at this point you would need to clarify what you're asking, as we obviously are on different pages (no pun intended).

0
behestAuthor Commented:
Hi! I'm working with a project that has three different versions of the document. One is a hard copy for people to look at (roughly 10 pages), one is an online piece (used to enter information), and the last is my "report" which is generated after the info is collected and pulled into Access then populated into the pages.
So I started with the premise that I would have all of those pages and just insert each of the fields to populate the information. Since learning that some of the fields needed to be flexible, I changed them to memo for growth potential.
If I'm following you, I should just insert the fields with a minimal size and set the CanGrow property to yes for expansion purposes.
The first page of the "report" is essentially a picture. I added it in at full size, which took up 10" in height. Could I add that as a call to print at the beginning, too?
0
Helen FeddemaCommented:
Just make sure that you don't put controls with CanGrow set to yes on the same horizontal line, because then the CanGrow feature won't work.  Also, the section itself needs to have CanGrow set to Yes (this is not possible in all sections of a report).

I don't see any need for code to do what you want -- the CanGrow property set to Yes should do the trick.
0
Helen FeddemaCommented:
Except for the picture -- make that the appropriate size.
0
behestAuthor Commented:
Thank you for the advice. I ended up creating a form and getting rid of the extraneous space and detail. Works perfectly, adjusts to the size of the answers, and gives the end user editing options, if necessary.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
behestAuthor Commented:
I'm supposed to be able to award points to LSMConsulting and HelenFeddema but didn't see an option for doing so when I closed the question. My intent was to do 200 to LSM and 50 to Helen since there advice was helpful in forming my solution.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can award points by (a) posting your own solution and then (b) selecting the "Select and Award Multiple" option, where you can then select one or more Expert comments, and award as many points as you see fit to those comments.

In order to do that, you'd need to Object to your own action. When doing so, post a comment asking the Moderators to assist you with this and one of them will walk you through doing this.

There's also this help topic:

http://www.experts-exchange.com/help.jsp?hi=407
0
behestAuthor Commented:
I object! I've posted the solution (twice now, even). In neither instance has the lovely green "Accept As Solution" box appeared next to my solution. There isn't a nifty Multiple option either. I've read the handy dandy help notes to no avail. Perhaps I've been a bit overwhelmed the last few days...or maybe I'm just not seeing the trees for the beautiful forest.
I've already "misplaced" some lovely points on another question. Perhaps someone...maybe a moderator...would be kind enough to show me the error of my ways. If you'd like a screen capture, I'd be more than happy to provide one.
0
behestAuthor Commented:
I object! I've posted the solution (twice now, even). In neither instance has the lovely green "Accept As Solution" box appeared next to my solution. There isn't a nifty Multiple option either. I've read the handy dandy help notes to no avail. Perhaps I've been a bit overwhelmed the last few days...or maybe I'm just not seeing the trees for the beautiful forest.
I've already "misplaced" some lovely points on another question. Perhaps someone...maybe a moderator...would be kind enough to show me the error of my ways. If you'd like a screen capture, I'd be more than happy to provide one.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.