jwcolby
jwcolby at colbyconsulting.com
Sat Feb 21 10:57:53 CST 2009
Tell me you are not using the tag for each control. 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 >