can access pass parameters?
Printable View
can access pass parameters?
Do you mean that you have created a parameterised query in Access and want to implement it through VB code?
If so then use a Querydef and it's parameters properties to pass the param values before executing it to get the results.
eg
Dim paramQ As QueryDef
Dim aRS As Recordset
Set paramQ = CurrentDb().QueryDefs("query")
paramQ.Parameters("ReqDate") = #12/3/99#
Set aRS = paramQ.OpenRecordset
Regards.