how to pass parameters to query that is build in access

S

smriti

Well-known member
Joined
Jan 7, 2005
Messages
54
Dear all,

I am using MS Access Database.
I am building the queries in Access Database and Executing them using stmt "Execute QueryName".
Is there Any way to pass the parameters to Access Queries.
That is i want to Execute the query by passing a value to it.
Is it possible to do so?
If so please mention it.

Thanks.
 
You would just list the parameters in the order the query is expecting them after the queryname (comma delimited) :

Execute QueryName Parameter1, Parameter2 etc...
 
Back
Top