Use a Temporary Variable in a Macro

  • Thread starter Thread starter tstevens
  • Start date Start date
T

tstevens

I have just upgraded to Office 2007 and am trying to make use of a temporary
variable TempVar created by a SetTempVar action. That seemed to go well
enough. However, I can't for the life of me find how to reference it later
in a macro SetValue call.

I see lots of advice about translating the macro into VBA and referencing it
there - but I think that is more sophisticated than my application deserves.
 
Thank-you, Steve,

That works nicely. Is there a reference I should have found? I have been
looking for a usual reference manual pertaining to Office 2007 Access but
have not found it yet. I do not expect to have to ask such a trite question.

Tom


Steve Schapel said:
Tstevens,

[TempVars]![NameOfYourVariable]

--
Steve Schapel, Microsoft Access MVP


tstevens said:
I have just upgraded to Office 2007 and am trying to make use of a
temporary
variable TempVar created by a SetTempVar action. That seemed to go well
enough. However, I can't for the life of me find how to reference it
later
in a macro SetValue call.

I see lots of advice about translating the macro into VBA and referencing
it
there - but I think that is more sophisticated than my application
deserves.
Click to expand...

.
Click to expand...
 
Tom,

I didn't regard it as a trite question.

I regret to say that I don't think this is covered well in Access Help. I
think I first learned about it in a book, probably "Access 2007 Inside Out"
by Viescas & Conrad.
 
Here is a Help article that might assist:
http://office.microsoft.com/en-us/access/HA101202161033.aspx?pid=CH100728921033

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

tstevens said:
Thank-you, Steve,

That works nicely. Is there a reference I should have found? I have been
looking for a usual reference manual pertaining to Office 2007 Access but
have not found it yet. I do not expect to have to ask such a trite question.

Tom


Steve Schapel said:
Tstevens,

[TempVars]![NameOfYourVariable]

--
Steve Schapel, Microsoft Access MVP


tstevens said:
I have just upgraded to Office 2007 and am trying to make use of a
temporary
variable TempVar created by a SetTempVar action. That seemed to go well
enough. However, I can't for the life of me find how to reference it
later
in a macro SetValue call.

I see lots of advice about translating the macro into VBA and referencing
it
there - but I think that is more sophisticated than my application
deserves.
Click to expand...

.
Click to expand...
Click to expand...
 
Back
Top