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

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Sat Feb 21 11:40:31 CST 2009


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




More information about the AccessD mailing list