Jumat, 03 Agustus 2012

RE: [MS_AccessPros] RE: dynamic assignment of actual subform/s

 

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