jwcolby
jwcolby at colbyconsulting.com
Sat Feb 21 11:28:10 CST 2009
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 >