• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 610
  • Last Modified:

MS Access - VBA - Using global Var in query

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?
0
keschuster
Asked:
keschuster
  • 4
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I guess A2007 also has TempVars() also ... which are essentially ... Global Variables that do not get reset if there is an error or reset ...

mx
0
 
keschusterAuthor Commented:
thats what I thought...  ty
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Overall, TempVar() are a pretty cool, long overdue feature ...

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now