Charlotte Foust
charlotte.foust at gmail.com
Wed Dec 31 12:53:42 CST 2014
Don't get started, Arthur. Access is what it is. There is still a niche market for it, and I'll keep using it. TempVars and LocalVars have their uses in web apps where you can't use VBA. Yes, static functions can be used but again, only where you can use VBA. I'm not defending the things, but I've found that in Data macros at the table level, you may need to use them (at least LocalVars) to hold field values to check. Charlotte On Wed, Dec 31, 2014 at 8:21 AM, Arthur Fuller <fuller.artful at gmail.com> wrote: > My little take on this is: > > a) none of these approaches will be portable to any other FE; > > b) it's always helpful to encapsulate your logic in a function rather than > a TempVars variable; c) sad as I am to say this, it appears from > Microsoft's behavior that Access has become an abandoned child. I write > this with great sorrow because I have invest years and years in this > technology, but I have made this mistake before, and subsequently licked my > wounds and moved on (you want details? I got them: I spent more than a year > writing a book about CA-Visual Objects, which was so buggy it was almost > impossible to write about, and the result was I made a bad choice and > suffered loss of income for about a year, give or take a month.) > > Back to the topic at hand. Expect that Access will soon be abandoned by MS. > All the evidence for this thesis is their abject failure to provide any new > tools for developers, since, wait, let me guess, 2007? Don't get me > started! > > Not to sidetrack this conversation, but just to add that MS's abject > failure to deliver for developers is why I moved to Alpha Anywhere. That > firm has vision; MS, imo, does not. > > So, Brad, my advice is to refrain from TempVars and instead use Functions, > and even better, Static Functions. Not only do they work perfectly within > Access, but they also provide you a portable way out of Access and into new > platforms (yeah, I champion AA but am also cool with good old friends such > as PHP and a couple of other JS libraries.) > > On Wed, Dec 31, 2014 at 9:40 AM, Brad Marks <bradm at blackforestltd.com> > wrote: > > > All, > > > > I have just started to experiment with TempVars. > > > > I am curious if there is any advantage of using TempVars instead of > > Functions in queries (in Criteria). > > > > Thanks, > > > > Brad > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > > -- > Arthur > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >