ADO parameter queries in Access vba

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Hello all,

I have a query in an Access 2002 db with 3 parameters.
When I try to open this query to a recordset object in
vba, I get the error "To few parameters, expected 3", even
though I had these parameters set to controls on a form.

I'm trying to figure out how to assign the parameters
through ado/vba code, including what to put in the query
itself to be substituted with the parameters in code.

Thanks for any help, Jack
 
Look up the Parameters collection if using ADO.

Look up the QueryDef if using DAO.
 
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

Parameter Query Won't Run 0
Modify Parameter Query 1
ADO Parameter Query 2
Query error, too few parameters 0
Executing Update Query With Parameters As ADO Command 1
Access update query 2
Parameter Queries in Crosstab Query 2
Front-end db run Parameter query in back-end Access db using ADO? 2

Back
Top