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

MS ACCESS Global Variable Question

How and where to create and assign a Global Variable as Criteria to a Query for searching. that the variable must be static for later use?
0
vkkleung
Asked:
vkkleung
1 Solution
 
brewdogCommented:
If you need the variable to be global, declare it (using the Global keyword) in a general module. As far as the query criteria, it doesn't really matter what you're going to use the variable for -- if it's global, you can get to it from anywhere.

I'm a little confused as to the Static part of your question. Do you mean that you want the value stored in the variable to remain the same no matter where in your code you use it? Then, in the procedure where you are referencing the variable, simply put Static (variablename) at the top of the procedure.

Hope this helps.

brewdog
0
 
MoondancerCommented:
GREETINGS!

This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.  If you are an EE Pro user, you can also choose Power Search to find all your open questions.

This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.  Also in the Community Support link is a question on how experts can help, if they wish, on the cleaning of old and abandoned questions.

http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
http://www.experts-exchange.com/jsp/zonesAll.jsp
 
Thank you,
Moondancer
Moderator @ Experts Exchange
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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