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]]

Jack wrote:

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/groups?selm=eE...&output=gplain

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"