[AccessD] Using macros - good thing or bad?

Steve Schapel miscellany at mvps.org
Tue Feb 23 12:39:11 CST 2010


Ken,

--------------------------------------------------
From: "Kenneth Ismert" <kismert at gmail.com>
Sent: Wednesday, February 24, 2010 5:16 AM
To: <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Using macros - good thing or bad?

> This means they still don't support variables.

Access 2007 introduced TempVars.  These are very cool critters.  They can be 
created in macros or in VBA, and once created can be used similar to global 
variables or local variables in macros or VBA, but also can be used for 
example in query criteria, and in calculated fields, and then Control Source 
expressions of form or report controls.

Access 2010 goes a step further.  This is still not to the extent that you 
would no doubt desire, but it's still worth noting that "don't support 
variables" isn't quite true.

Regards
Steve 




More information about the AccessD mailing list