[AccessD] TempVars

Charlotte Foust charlotte.foust at gmail.com
Mon Sep 17 10:26:58 CDT 2012


I, too, built similar devices and kept them for backwards compatibility as
time moved on.  Since MS has left backwards compatibility in the dust,
maybe we should too, John.

Charlotte

On Mon, Sep 17, 2012 at 8:07 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> > Oops! In my last post I referred to a new feature of Access and
> mistakenly called it the Parameters collection. It's actually called the
> TempVars collection.
>
> I did my own tempvars a decade ago and have used it ever since.  It uses a
> static collection inside of the function with an optional parameter to add
> new variables to the collection.  No optional parameter retrieved values
> using a name passed in.
>
> SysVar "MyVarName", MyVarValue to add
> MyVar = SysVar("MyVarName") to retrieve.
>
> This is so common a requirement, why does it take MS a decade to come up
> with the same functionality native to Access?
>
> Oh yea, I remember... pretty toolbars are *much* more important.
>
> And you wonder why there is not more real Access traffic on the list?
>  Back in the day we were discussing the stunning advances of 97 over the
> old version 2.0, and then the equally stunning bugginess of Access 2000 and
> how to work around the issues and how to migrate 97 to 2000, and how to use
> the new code editor.  And then we were discussing the bug fixes that came
> with Access 2002 and 2003.  Classes and Events were available and stable
> and a lot to figure out there.
>
> And then things went quiet.  Access 2003 was, all things considered, a
> stable mature product.  The serious bugs that did still exist were never
> going to be fixed, even to this day.
>
> And then 2007 hit with its oh so enormous enhancements. and its oh so
> enormous new bug list.  So there was a burst of traffic re that version.
>  But of course it was pretty much not "developer" kind of stuff so mostly
> it was griping about the lack of developer support.
>
> And down hill from there.
>
> I now program mostly in C# and I absolutely love it.  I mostly use SQL
> Server for my BE and I absolutely love it.  So I for one don't have much to
> say because I am just lurking now.  You guys are still friends and I will
> probably never leave because of that.  I still pipe up when I have
> something useful to say.
>
> In the end the list is quiet because the Access world is quiet, at least
> from a developer's perspective, and we started as a developer list.
>
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
>
> On 9/17/2012 10:35 AM, Arthur Fuller wrote:
>
>> Oops! In my last post I referred to a new feature of Access and mistakenly
>> called it the Parameters collection. It's actually called the TempVars
>> collection. Sorry about that, folks. Another senior moment.
>>
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
>
>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>
>
>


More information about the AccessD mailing list