DAO querydef parameters

  • Thread starter Thread starter Craig Buchanan
  • Start date Start date
C

Craig Buchanan

Is there another way to work with a querydef's parameters than
querydef!Param? Perhaps querydef("Param")?

Thanks,

Craig
 
It would go something like:

querydef.Parameters("Parameter Index/Name")

HTH,

Neil.
 
Try:
QueryDef.Parameters("Param")

Doubt you can omit the ".Parameters" bit, as I would expect Fields to be the
default collection for a QueryDef.
 
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

passing params to multiple querydefs and transferspreadsheet 8
record set for pass through query 1
Set Querydef SQL to Null (Open an empty query editor) 20
Working with the querydef object issues... 2
Runnign a QueryDef from CmdBtn on a form 4
Display Yes/No instead of -1, 0 on Search Forms 1
working query fields... 1
Deleting newly created QueryDef 2

Back
Top