Jumat, 03 Agustus 2012

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar