Liz
> But wait - this is making me think--- I could have my code look at the form value rather than the report value since they will be identical.
>
> Hmmmmm.....
Duh!
Bill
--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> Bill, Unfortunately, I don't know if this will work since I need to determine which sourceobjects based on the value of a report field.
>
> So, I'm getting that weird "expression has no value" or something that happens when I'm looking at a control that hasn't even been instantiated yet.
>
> I think I'll just have multiple reports (There are only 9) and open the report according to the value on the form ----
>
>
> But wait - this is making me think--- I could have my code look at the form value rather than the report value since they will be identical.
>
> Hmmmmm.....
>
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: Friday, August 03, 2012 12:29 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] RE: dynamic assignment of actual subform/s
>
> Liz
>
> If you are setting the Source for the sub I think it has to be done in the report's Open event.
>
> If all you want to do is show or hide a subreport you can do that in the format event of the section that has the sub.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> My nothing-to-do-with-Access blog
> http://wrmosca.wordpress.com
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@> wrote:
> >
> > John, this is working beautifully for my subforms, so how can I have a similar situation work on a report?
> >
> > Is there an event that triggers where I could set the source object of subforms on a report?
> >
> > Liz Ravenwood
> > Programmer/Analyst
> > Super First Class Products
> > B/E Aerospace
> > O: 1.520.239.4808
> > www.beaerospace.com
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
> > Sent: Monday, July 23, 2012 9:40 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: RE: [MS_AccessPros] RE: dynamic assignment of actual subform/s
> >
> > Liz-
> >
> > Love your "thinking out loud."
> >
> > You could still have all the fields in one table, but develop subforms that are
> > bound to the relevant fields based on the type. In the Current event of the
> > form, load the appropriate subform by setting the Source Object property of the
> > subform control based on what's in test type. If Me.NewRecord = True, just hide
> > the subform control but make it visible and set its Source Object based on what
> > is selected in test type - do this in the AfterUpdate event of test type.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
> > Sent: Monday, July 23, 2012 6:22 PM
> > To: 'MS_Access_Professionals@yahoogroups.com'
> > Subject: [MS_AccessPros] RE: dynamic assignment of actual subform/s
> >
> > Maybe I'll just have a table that has all possible fields (there aren't too
> > many) and then have them set as visible if they are relevant based on the test
> > type. I actually think that would be the best.
> >
> > I need to get a prototype up soon, and am NOT wanting to duplicate a bunch of
> > development across multiple forms.
> >
> > Liz Ravenwood
> > Programmer/Analyst
> > Super First Class Products
> > B/E Aerospace
> > O: 1.520.239.4808
> > www.beaerospace.com
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
> > Sent: Monday, July 23, 2012 9:10 AM
> > To: 'MS_Access_Professionals@yahoogroups.com'
> > Subject: [MS_AccessPros] dynamic assignment of actual subform/s
> >
> > Pros, I'm starting a database for flammability testing with the main form
> > contents being the same across but then the subform elements including the
> > fields are distinct based on test type. (heat issue, oil burn, etc.)
> >
> > I was wondering if it is possible to have some type of beyond late binding main
> > form to sub form and linking happen so that the sub forms come in as they need
> > to.
> >
> >
> > Liz Ravenwood
> > Programmer/Analyst
> > Super First Class Products
> > B/E Aerospace
> > O: 1.520.239.4808
> > www.beaerospace.com
> > 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.
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> > 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.
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> > 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.
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> 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.
>
Tidak ada komentar:
Posting Komentar