[dba-VB] JIT Subforms, was Merge rows (now: seriously OT)

Max Wanadoo max.wanadoo at gmail.com
Tue Sep 22 13:35:03 CDT 2009


Only one sub form is loaded at any one time.

Max


-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: 22 September 2009 17:41
To: Discussion concerning Visual Basic and related programming issues.
Subject: Re: [dba-VB] JIT Subforms, was Merge rows (now: seriously OT)

Do you have a single subform control?  If so then you can't have 10 subform
controls and all of them 
left bound.

John W. Colby
www.ColbyConsulting.com


Max Wanadoo wrote:
>> With your approach leaving the subforms bound is difficult to say the
> least.
> 
> As difficult as one line of code <g>
> 
> Max
> 
> 
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: 22 September 2009 17:14
> To: Discussion concerning Visual Basic and related programming issues.
> Subject: [dba-VB] JIT Subforms, was Merge rows (now: seriously OT)
> 
> Max,
> 
> It doesn't have to be either / or.
> 
> I used to do the unbind when the user clicked off the tab and William
> objected, saying that his 
> users prefer that it stay bound.  All it takes is removing the form name
> form the form control and 
> voila, it is unloaded.  Leave it there and voila, it stays bound.
> 
> My personal feeling is that unbinding it makes a lot of sense when there
are
> a ton of tabs, and / or 
> the subforms contain a ton of records.  The time to navigate through the
> parent record is a lot less 
> (faster)
> 
> OTOH if there aren't many subforms then it often makes sense to leave it
> bound.
> 
> One way or the other, I do exactly this, decide on a form by form basis
> whether it makes sense to 
> unbind as the user leaves the tab.
> 
> With your approach leaving the subforms bound is difficult to say the
least.
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> 
> Max Wanadoo wrote:
>>> 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
> 
> _______________________________________________
> 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




More information about the dba-VB mailing list