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?


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