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 >