[AccessD] TempVars

jwcolby jwcolby at colbyconsulting.com
Mon Sep 17 10:07:35 CDT 2012


 > 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.
>



More information about the AccessD mailing list