Parameter Passing

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?
 
M

Marshall Barton

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.
 
Top