Run Query

  • Thread starter Thread starter hockey6789player
  • Start date Start date
H

hockey6789player

I need to run an append query that pull data from a table given the
criterion from the command prompt. I understand how to pass the
parameter to access, but I do not see how I am going to get the
parameter into the query. Any help would be much appreciated. Thanks,
Mark
 
You could create a Function in VBA and pass it in the field of the
query.

Function GET_Information(pass your variables)


GET_Information=
End Function
 

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

Variable Criterion for Query 2
Query Parameter using multiple options 0
Parameter Value error in a Subform 0
Too few parameters error with a IIF statement 5
Access Invalid bracketing of parameter name 1
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
query criterion management 2
Error on Access Query 10

Back
Top