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