How to pass a parameter in a stored Access query

[Jack]

Hi,
I have a stored access query which is corresponding to a particular id.
However, I am using a login script to capture the value of an id. Now, I want
to dynamically open the stored query by passing the id captured via login.
Which means, I need to erase the static id value associated with the stored
query GMISExpenseCombo.
My question is how do i open this stored query by passing the id value to
the stored
query. I am using this stored query to retrieve some financial data for the
corresponding record. Any help is appreciated.
Currently, I am opeing the static stored query as follows
RS.Open "GMISExpenseCombo"

 

[Bob Barrows [MVP]]

Hi,
I have a stored access query which is corresponding to a particular
id. However, I am using a login script to capture the value of an id.
Now, I want to dynamically open the stored query by passing the id
captured via login. Which means, I need to erase the static id value
associated with the stored query GMISExpenseCombo.
My question is how do i open this stored query by passing the id
value to the stored
query. I am using this stored query to retrieve some financial data
for the corresponding record. Any help is appreciated.
Currently, I am opeing the static stored query as follows
RS.Open "GMISExpenseCombo"

Assuming the name of your connection variable is Conn, do this:

idvariable = ...
Set RS=createobject("adodb.recordset")
Conn.GMISExpenseCombo idvariable, RS

See here for more information (I've already provided this link to you -
didn't you read it?)

http://www.google.com/[email protected]&oe=UTF-8&output=gplain

Bob Barrows