[AccessD] Array as source for query

Well... I am not a member.  Sigh.

But now that you have advised me that it is possible, I shall not be
deterred.

;) 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ken Ismert
Sent: Tuesday, January 23, 2007 4:46 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Array as source for query


John,
> I too make heavy use of Just In Time subforms, on tabs, connecting and 
> disconnecting the subforms as the user clicks on and then off of tabs.  
> That definitely helps but doesn't solve the problem.  If I can build 
> into my framework a method of caching the data for combos and then 
> using a callback that would definitely help.  Combos are about 90% of 
> the problem and this is an issue that really can cause problems as your
forms get complex.

Susan Harkins and I wrote an article in Access Advisor, "Get Better
Performance from Microsoft Access List Control-Based Forms", which talks
about using ADO disconnected recordsets as a rowsource for Combos and List
boxes. Works for Access 2000 and later.

You could cache the recordsets when they are first needed, and play them
back to any combo on any tab that needed it.

As far as callbacks, true callbacks are probably a bridge too far using just
VBA, but you should be able to satisfactorily simulate one using interfaces
and the appropriate wrapper classes for the combos.

-Ken
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com