Parameter Passing

  • Thread starter Thread starter Gary B
  • Start date Start date
G

Gary B

In regards to running a Query against an Access database through Jet,
how can one supply a value of a parameter that exists in the SQL?
 
Gary said:
In regards to running a Query against an Access database through Jet,
how can one supply a value of a parameter that exists in the SQL?
Click to expand...


Well there's several ways, but since you didn't provide any
context for running the query, I'll just say that the
QueryDef's Parameter collection can be set before using the
OpenRecordset or Execute methods on the QueryDef object.
 
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

Calling Parameterized Query Using SQL Syntax 3
Parameter Query help - Not passing parameter? 3
USING PARAMETERS IN A CROSSTAB QUERY 4
query too complex to pass optional parameters 1
query parameters 2
Update pass through query of report recordsource 2
pass throught query by parameter 1
How to pass parameter between parameter queries 10

Back
Top