[AccessD] TempVars

It is time to start using senior programmers to build this appliocation and
forget those co-op students. ;-)

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, September 17, 2012 8:08 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] TempVars

 > 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
Website: http://www.databaseadvisors.com