Liz-
John, so it would still be a while not rs.eof deal or am I completely misunderstanding? I think I am.
What does it mean to reset the recordsource? Set it to one record or geez. Splain please lucy!
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Wednesday, March 12, 2014 9:21 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] report with dynamic recordsource subforms and varying main recordsource
Liz-You could TRY resetting the Record Source of the SUBREPORTS 😃 in the Format event of the Detail section of the outer report - or in whichever section you can first detect the test type change when you have records from multiple test types in the outer report's Record Source.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Mar 12, 2014, at 5:06 PM, Liz Ravenwood <liz_ravenwood@beaerospace.com> wrote:
Duh! And subreports. Geez.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Wednesday, March 12, 2014 9:04 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] report with dynamic recordsource subforms and varying main recordsource
Pros,
Greetings. ARRGH. So I have this report that works delightfully well. On the open event of the form, it grabs a test type value from an open form and uses it to dynamically set the recordsources for the subforms as they are different subforms entirely. Nice.
Now… I'm going to have to print multiple records that have various test type values and don't know how to have each record produce the page with its respective subforms as they vary.
Things I'm brainstorming are and I apologize for the chaotic thinking here…
Getting a recordset, and running through each one and sending it with the rs("TestType") to the "SetItUp" procedure, sending the pdf to an output file, keeping a list of all the output files, and then concatenating them together.
This is kludgy and would work, (unless I get better ideas here) but the thing that would snag me up is the concatenation of the pdf's. Apparently, there is code out there, but when I run it I get an error that when googled, says I need to be able to add some keys to the windows registry (help desk submitted to corporate IT for that one).
Anyone?
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar