Query criteria a variable

  • Thread starter Thread starter kon
  • Start date Start date
K

kon

How can I use in a query in design view in criteria a variable (A variable
used in VBA code)?
 
Create a public function (in a regular module) that reads the value of the
variable -- note that the variable must be a global variable:

Public Function GetMyVariable()
GetMyVariable = NameOfTheVariable
End Function

Then call the function in your query using GetMyVariable().
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA: How can I use a string variable as autofilter criteria? 4
Can I use a number variable in a Query? 10
Using global variable in criteria 10
SQL Delete Stored Procedure 2
Using Variable as criteria 4
Can I use a variable as criteria? 1
using a date variable in query criteria 3
Query Field Name : Variable 5

Back
Top