[AccessD] TempVars

Well... I would except that I continue to develop in 2003 when I do anything at all in Access.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 9/17/2012 11:26 AM, Charlotte Foust wrote:
> 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>
>>
>>
>>