Max Wanadoo
max.wanadoo at gmail.com
Tue Sep 22 10:42:35 CDT 2009
> Does that clarify it for you? It does, so really with the Tabs JIT you are not much better off. With my On-Demand approach, only data that is wanted there-and-now is loaded each time you navigate between records AND furthermore, I give them the option of a blank sub-form which means there is no extraneous data overhead when navigating unless the user wants it. I think my On-Demand approach is better for lots of reasons, but if your are happy with your JIT-Tabs approach then I am happy for you. Max -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: 22 September 2009 15:59 To: Discussion concerning Visual Basic and related programming issues. Subject: Re: [dba-VB] Merge rows (now: seriously OT) It means that once you set the master/child links (in Access), for instance, the subform would stay bound, so you wouldn't have to load it again when you moved to another tab and back. In our .Net apps, we drop a subform control on a particular tab. When the tab is selected, we load the subform and call its custom FillData routine, after that, as long as the parent form is open, we don't have to reload that subform, only point it to the appropriate record. Does that clarify it for you? It's possible to use a single subform control and change which subform is bound to it, but that involves unloading and reloading the subform, so the tabl approach is faster. Charlotte Foust -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Tuesday, September 22, 2009 7:53 AM To: Discussion concerning Visual Basic and related programming issues. Subject: Re: [dba-VB] Merge rows (now: seriously OT) Charlotte. Quick question please. You know when we were talking about the tabs not doing anything unless instantiated, (ie, user clicked on one), does that mean that in that case the "contents" of the subform would be loaded for that tab, and the stay loaded? Thinking about that in bed last night. What am I like, eh! MAx On 22/09/2009, Charlotte Foust <cfoust at infostatsystems.com> wrote: > Hmmn ... > > If wiseGuy = 'Gustav' The Kill(wiseGuy) > > Charlotte > > -----Original Message----- > From: dba-vb-bounces at databaseadvisors.com > [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Gustav Brock > Sent: Tuesday, September 22, 2009 1:10 AM > To: dba-vb at databaseadvisors.com > Subject: Re: [dba-VB] Merge rows (now: seriously OT) > > So Max wins again! > > /gustav > >>>> "Stuart McLachlan" <stuart at lexacorp.com.pg> 22-09-2009 00:55 >>> > > Select Distinct, KeyField, Max(fld2), Max(fld3).......... > > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com