[AccessD] Filtered combos

William Hindman wdhindman at dejpolsystems.com
Fri Mar 6 11:26:11 CST 2009


...I'll extract a sample and send it to you off-line to look at.
William

--------------------------------------------------
From: "jwcolby" <jwcolby at colbyconsulting.com>
Sent: Friday, March 06, 2009 9:24 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Filtered combos

> Does this object source automation events?  Have you tried a class 
> wrapper?  That might be the way
> to go.  That class could then load the menu data and keep it cached, as 
> well as sinking the events etc.
>
> I have never used the treeview but if it is something that would benefit 
> from a wrapper class I
> might be willing to dive in, to obtain more material for the book.
>
> John W. Colby
> www.ColbyConsulting.com
>
>
> William Hindman wrote:
>> ...I use something like that for treeview switchboards to pass an OpenArg
>> stored in the table
>> ...caching that table would be useful in that its available to the user 
>> at
>> all times and is subject to frequent calls
>>
>> William
>>
>> --------------------------------------------------
>> From: "jwcolby" <jwcolby at colbyconsulting.com>
>> Sent: Thursday, March 05, 2009 10:51 AM
>> To: "Access Developers discussion and problem solving"
>> <accessd at databaseadvisors.com>
>> Subject: Re: [AccessD] Filtered combos
>>
>>> Mike,
>>>
>>> I can see how this might be advantageous in some processes.  I have 
>>> never
>>> actually done this before
>>> but I have read about the process.  I thought it was more for 
>>> translating
>>> strings and such, or the
>>> ability to use a common string for message boxes, labels and so forth. 
>>> I
>>> never really thought of it
>>> in terms of holding SQL Strings.
>>>
>>> Does anyone out there use this technique?  A class to cache these 
>>> strings
>>> might be useful if you
>>> were going to use such a table.
>>>
>>> If anyone uses it, what kinds of strings do you put in the table?
>>>
>>> John W. Colby
>>> www.ColbyConsulting.com
>>>
>>>
>>> Mike Mattys wrote:
>>>> OK, what I was thinking was that you'd have a global class
>>>> that is instantiated while the database is open and you'd just
>>>> call a method in the class with the record number of the string
>>>> that would be the new recordsource of the combo.
>>>>
>>>> -
>>>> Michael R Mattys
>>>> MapPoint and Database Dev
>>>> www.mattysconsulting.com
>>> -- 
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>>
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list