«

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"

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"