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

William Hindman wdhindman at dejpolsystems.com
Sat Feb 21 16:02:16 CST 2009


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