[AccessD] Find First in an Array? - The Solution

jwcolby jwcolby at colbyconsulting.com
Sat Feb 21 18:38:26 CST 2009


We need to get our web design person to do the posting. I am hoping to get Drew's solution as well, 
he might use classes as well, even if not it would give another perspective.

John W. Colby
www.ColbyConsulting.com


William Hindman wrote:
> ...ouch! ...so simple ...so obvious ...the old thing about too busy looking 
> at the trees to see the forest :)
> ...still ...assuming JC posts the mdb sample ...we got a good look at using 
> classes and collections in the real world.
> 
> William
> 
> --------------------------------------------------
> From: "Max Wanadoo" <max.wanadoo at gmail.com>
> Sent: Saturday, February 21, 2009 2:55 PM
> To: "'Access Developers discussion and problem solving'" 
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Find First in an Array? - The Solution
> 
>> No Rocky,
>> You have missed the WHOLE concept!   Sorry to be pedantic, but:-
>> 1. You do this  ONCE on each installation for each language , or
>> 2. You do it for them BEFORE you distribute the app, or
>> 3. You  ALLOW them to do it themselves if you decide that is ok.
>> 4. There is no "open form, run the translation code to change the captions
>> EACH AND EVERY time we open  the form".  The captions are correct ALL THE
>> TIME.  This is could easily be, "ok, not you have to restart the  app 
>> before
>> your selection are implemented, etc - how many apps have we installed 
>> where
>> it says something similar, but it is actually changed there and then!!!
>> 5. Once you have run this code, you never have to run it again (unless you
>> want to).
>> 6. No, you don't have to restart, but I would recommend it.
>> 7. No, repeat NO overheads at run time.  No Collections, no Containers, no
>> Classes (sorry JC), no nothing... your code is now showing the captions as
>> if you had given it to them "exactly as" when you sent it to them.
>>
>> If that doesn't solve your problem, then I  leave to others to come up 
>> with
>> a better solution then RUN ONCE AND FORGET!
>>
>> Max
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
>> Beach Access Software
>> Sent: 21 February 2009 17:41
>> To: 'Access Developers discussion and problem solving'
>> Subject: Re: [AccessD] Find First in an Array? - The Solution
>>
>> Max said so.
>>
>>
>> Rocky Smolin
>> Beach Access Software
>> 858-259-4334
>> www.e-z-mrp.com
>> www.bchacc.com
>>
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
>> Sent: Saturday, February 21, 2009 9:28 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] Find First in an Array? - The Solution
>>
>> Why do you have to restart the app?
>>
>> John W. Colby
>> www.ColbyConsulting.com
>>
>>
>> Rocky Smolin at Beach Access Software wrote:
>>> So, I'll spill the beans.  When the user changes languages Max's
>>> solution opens the form hidden in design mode, updates the captions
>>> from the language table, and save it back.  Then you have to restart
>>> the app to see then new captions.
>>>
>>> Two problems for me: 1) since there are about 90 forms and 60 reports,
>>> so there would be some delay in changing languages but since that
>>> wouldn't happen very often I suppose it would be tolerable, and 2) and
>>> more important, I distribute my app as an mde so I don't think I can
>>> open the forms in design view at run time.
>>>
>>> But for an mdb, good solution.
>>>
>>>
>>>
>>> Rocky Smolin
>>> Beach Access Software
>>> 858-259-4334
>>> www.e-z-mrp.com
>>> www.bchacc.com
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: accessd-bounces at databaseadvisors.com
>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
>>> Sent: Saturday, February 21, 2009 8:54 AM
>>> To: Access Developers discussion and problem solving
>>> Subject: Re: [AccessD] Find First in an Array? - The Solution
>>>
>>> Have you patented it yet?
>>>
>>> ;)
>>>
>>> John W. Colby
>>> www.ColbyConsulting.com
>>>
>>>
>>> Max Wanadoo wrote:
>>>> There is no comparison.  Nothing else comes even close.
>>>>
>>>> Can't post to list as it is an mdb -I will send to your email.
>>>>
>>>> Off to pub now.  Hope you like it.
>>>>
>>>> Max
>>>>
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: accessd-bounces at databaseadvisors.com
>>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky
>>>> Smolin at Beach Access Software
>>>> Sent: 21 February 2009 15:04
>>>> To: 'Access Developers discussion and problem solving'
>>>> Subject: Re: [AccessD] Find First in an Array? - The Solution
>>>>
>>>> YES! Post it to the list. I'll drop it into Colby's demo and set a
>>>> switch so it can go back and forth.
>>>>
>>>> In fact, that demo could be the template for making comparisons among 
>>>> all
>>>> the solutions.
>>>>
>>>>
>>>> Rocky Smolin
>>>> Beach Access Software
>>>> 858-259-4334
>>>> www.e-z-mrp.com
>>>> www.bchacc.com
>>>>
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: accessd-bounces at databaseadvisors.com
>>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max
>>>> Wanadoo
>>>> Sent: Saturday, February 21, 2009 4:47 AM
>>>> To: 'Access Developers discussion and problem solving'
>>>> Subject: Re: [AccessD] Find First in an Array? - The Solution
>>>>
>>>> Hello Rocky,
>>>> Well, I have read with interest all the to-ing and fro-ing from the
>>>> various contributors.
>>>> So, I laid me down laterally and started thinking laterally.
>>>> The solution came to be sometime around my 3rd drink.
>>>> I consolidated my thoughts in bed.
>>>> When I woke this morning, I tested them out with a sample mdb using
>>>> English, French and German.  All work beautifully.  Add as many
>>>> languages as you want.
>>>>
>>>> The solution I have has the following benefits:
>>>>
>>>> Instantaneous
>>>> No variables
>>>> No Collections
>>>> No Classes (although the solution could be said to be upper class
>>>> <ha!> No Arrays No Memory overheads Forms shown the language required
>>>> every time with no overheads.
>>>> Unlimited Languages
>>>>
>>>> Should I post the sample mdb to you?
>>>>
>>>> Max
>>>> Ps. Bet your intrigued - you will love this solution.
>>>>
>>>> -----Original Message-----
>>>> From: accessd-bounces at databaseadvisors.com
>>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky
>>>> Smolin at Beach Access Software
>>>> Sent: 20 February 2009 23:48
>>>> To: 'Access Developers discussion and problem solving'
>>>> Subject: Re: [AccessD] Find First in an Array?
>>>>
>>>> In the case of this app, however, there can be multiple back ends in
>>>> different locations.  So to get them updated I'd have to send out an
>>>> update program.  Or embed the updates in the next release of the
>>>> front end.  And check each back end that gets opened to see if the
>>>> latest updates were in there.  Actually, keeping the latest Language
>>>> table in the front end and transferring it to the back end on opening
>>>> each time would ensure that the back end was up to date.
>>>>
>>>> But at that point, with the language table in the front end anyway,
>>>> wouldn't it make sense just to run the translations from the front
>>>> end
>>> table?
>>>> Rocky Smolin
>>>> Beach Access Software
>>>> 858-259-4334
>>>> www.e-z-mrp.com
>>>> www.bchacc.com
>>>>
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: accessd-bounces at databaseadvisors.com
>>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
>>>> Sent: Friday, February 20, 2009 1:50 PM
>>>> To: Access Developers discussion and problem solving
>>>> Subject: Re: [AccessD] Find First in an Array?
>>>>
>>>> And this is where Global Classes come into play.
>>>>
>>>> In the case of your multi-lingual app, your data may not change very
>>>> often, but it has the potential to change.  That being the case, by
>>>> putting the data in the BE, you don't have to update the FE for a
>>>> simple
>>> data change.
>>>> However, instead of constantly pulling the data across from the BE,
>>>> you load the class when your app starts up, and the data is simply
>>>> kept in
>>> memory.
>>>> Pulling a few thousand records really isn't a big deal, as long as
>>>> they aren't memo fields with megs of information.  2.5k records, with
>>>> even 1k cay of information is only going to use 2.5 megs of RAM
>>>> (roughly)  In the case where you are storing a few bytes of info,
>>>> it's negligent, especially on machines where 1 to 2 gig is standard RAM.
>>>>
>>>> Even in situations like a State table (TX, AL, FL, etc.).  Sure,
>>>> there are 50 states now, but putting lookup tables in the FE can lead
>>>> to unnecessary mass updates.
>>>>
>>>> Drew
>>>>
>>>> -----Original Message-----
>>>> From: accessd-bounces at databaseadvisors.com
>>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky
>>>> Smolin at Beach Access Software
>>>> Sent: Friday, February 20, 2009 2:06 PM
>>>> To: 'Access Developers discussion and problem solving'
>>>> Subject: Re: [AccessD] Find First in an Array?
>>>>
>>>> " I am not going to get into the "this is a local table so it goes in
>>>> the FE... oh damn, now I gotta go update the data in 5 different FEs".
>>>> BEs are for data (in my world)."
>>>>
>>>> In my case, where the 'data' is really static, and is needed by each
>>>> user, wouldn't the design be better with the language tables in the FE?
>>>>
>>>>
>>>> Rocky Smolin
>>>> Beach Access Software
>>>> 858-259-4334
>>>> www.e-z-mrp.com
>>>> www.bchacc.com
>>>>
>>>>
>>>>
>>>> The information contained in this transmission is intended only for
>>>> the person or entity to which it is addressed and may contain II-VI
>>>> Proprietary and/or II-VI Business Sensitive material. If you are not
>>>> the intended recipient, please contact the sender immediately and
>>>> destroy the material in its entirety, whether electronic or hard copy.
>>>> You are notified that any review, retransmission, copying,
>>>> disclosure, dissemination, or other use of, or taking of any action
>>>> in reliance upon this information by persons or entities other than
>>>> the intended
>>> recipient is prohibited.
>>>> --
>>>> 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
>>>>
>>>> --
>>>> 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
>>>
>> --
>> 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
>>
>> -- 
>> 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