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

jwcolby jwcolby at colbyconsulting.com
Sat Feb 21 10:53:47 CST 2009


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
> 



More information about the AccessD mailing list