jwcolby
jwcolby at colbyconsulting.com
Sat Feb 21 12:14:22 CST 2009
Well ya don't. John W. Colby www.ColbyConsulting.com Rocky Smolin at Beach Access Software wrote: > 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 >