Link to home
Start Free TrialLog in
Avatar of behest
behestFlag for United States of America

asked on

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!!
Avatar of thenelson
thenelson

You could use subreports.
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.

Avatar of behest

ASKER

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?
Avatar of behest

ASKER

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...
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of behest

ASKER

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?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Except for the picture -- make that the appropriate size.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of behest

ASKER

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.
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:

https://www.experts-exchange.com/help.jsp?hi=407
Avatar of behest

ASKER

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.
Avatar of behest

ASKER

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.