Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

In Memoriam

Terms of Use


VB Petition

Queries: Use a variable in a field's criteria

Author(s)
Erika Yoxall

(Q)    Can I use an Access Basic variable as a criterion in a query?

(A)     The only way to refer to an Access Basic variable is by using Access Basic code. therefore, you need to create a function that equals the value of that variable, it could look like :

function GetValue()
  getvalue = variablename
end function


© 1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer