<div>
1) You can call a Function that grabs the value or - but that is VBA. Soooo<br />
<br />
No, unless ... you are in A2010, and you use the TempVar() collection ... <br />
<br />
mx
</div>


1) You can call a Function that grabs the value or - but that is VBA. Soooo

No, unless ... you are in A2010, and you use the TempVar() collection ...

mx

<div>
thats what I thought... &nbsp;ty
</div>


<div>
Here is a good tutorial by Juan Soto (Access MVP):<br />
<br />
<a href="http://blogs.office.com/b/microsoft-access/archive/2010/09/27/power-tip-maximize-the-user-of-tempvars-in-access-2007-and-2010.aspx" rel="ugc">http://blogs.office.com/b/microsoft-access/archive/2010/09/27/power-tip-maximize-the-user-of-tempvars-in-access-2007-and-2010.aspx</a><br />
<br />
mx
</div>


Here is a good tutorial by Juan Soto (Access MVP):

http://blogs.office.com/b/microsoft-access/archive/2010/09/27/power-tip-maximize-the-user-of-tempvars-in-access-2007-and-2010.aspx [http://blogs.office.com/b/microsoft-access/archive/2010/09/27/power-tip-maximize-the-user-of-tempvars-in-access-2007-and-2010.aspx]

mx

<div>
Overall, TempVar() are a pretty cool, long overdue feature ...<br />
<br />
mx
</div>


Overall, TempVar() are a pretty cool, long overdue feature ...

mx

<div>
<div class="content wysiwyg-content">
Access 07<br />
<br />
I've got some vba code that processes some data. &nbsp;During that processing I capture a global variable. &nbsp;Is there a way (NOT IN VBA) to use that variable in a query?
</div>
</div>


Access 07

I've got some vba code that processes some data.  During that processing I capture a global variable.  Is there a way (NOT IN VBA) to use that variable in a query?

MS Access - VBA - Using global Var in query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.