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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
behestConnect With a Mentor Author 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
 
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
 
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 )Connect With a Mentor 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 FeddemaConnect With a Mentor Commented:
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:
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
All Courses

From novice to tech pro — start learning today.