Good. :-) btw I'm using 2007.
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 11:45 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] RE: dynamic assignment of actual subform/s
Liz-
No, you should have only one subform. The Navigation Form in 2010 won't work
for you.
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 7:37 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] RE: dynamic assignment of actual subform/s
Crystal, I didn't know we were talking about using tabs as a solution in the
first place... ?
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 Crystal
Sent: Monday, July 23, 2012 10:20 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] RE: dynamic assignment of actual subform/s
Hi Liz,
adding on ...
it would be a good idea to ween yourself away from using tabs ... use the
navigation control introduced in Access 2010 instead, when you can. The
navigation control closes tables on the other tabs that aren't showing, which is
good for performance and data integrity.
The navigation control unloads what is not showing, which reduces the number of
open connections. As your database grows and you put more and more on the tab
control, you may run into issues unless you put code in to load and unload
subforms, which is what you are now asking about ...
~~
also, there is a bug with shortcuts working on subforms in tab controls -- this
is not an issue when the navigation control is used.
for instance, if this is the CAPTION of a label that is associated with a
textbox, or the CAPTION of a command button:
&Close
then C will be underlined, and Alt-C is the shortcut to choose it.
Warm Regards,
Crystal
*
(: have an awesome day :)
*
________________________________
From: Liz Ravenwood <liz_ravenwood@beaerospace.com>
To: "'MS_Access_Professionals@yahoogroups.com'"
<MS_Access_Professionals@yahoogroups.com>
Sent: Monday, July 23, 2012 10:45 AM
Subject: RE: [MS_AccessPros] RE: dynamic assignment of actual subform/s
John, even better. Thanks!
Liz Ravenwood
-----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
-----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
[Non-text portions of this message have been removed]
------------------------------------
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.
Tidak ada komentar:
Posting Komentar