Passing parameters in a query

  • Thread starter Thread starter Ivan Debono
  • Start date Start date
I

Ivan Debono

Hi all,

I've got a union query that requires 2 parameters. I'm using vb6 to make a
select statement based on this query but i don't know how to pass the
parameters automatically so no parameter dialog pops up.

Is it possible to pass parameter values automatically with the query?

Thanks
Ivan
 
Try creating the Select SQL String from scratch with the parameters resolved
to explicit values in the SQL String so that your SQL String is not
parametrised.
 
Problem solved. I left the parameters inside. In VB, I just created an ADO
command object and set the parameter values accordinly. Works like a charm!!

Ivan
 

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

Parameter Query Won't Run 0
Parameter Query help - Not passing parameter? 3
Like "* " and function to pass parameters into a query 4
query too complex to pass optional parameters 1
Parameter Queries in Crosstab Query 2
Pass Parameter to stored procedure in pass thru query 7
Parameter passed from a form to a query 3
Queries with Parameters 2

Back
Top