[AccessD] Filtered combos

William Hindman wdhindman at dejpolsystems.com
Thu Mar 5 10:28:14 CST 2009


...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
> 




More information about the AccessD mailing list