How does one pass a parameter to the EXEC query recordset:

set rs = cnn.execute("EXEC tblListings_qry2")

Assuming that tblListings_qry2 is a stored procedure than you would just
append it

Set RS=cnn.Execute("EXEC tblListings_qry2 5")

if there are multiple parameters, you just separate them with commas

Set RS=cnn.Execute("EXEC tblListings_qry2 5,3,'Bob''s your uncle', 99,
'hello','etc',1")

"jason" <jason@catamaranco.com> wrote in message
news:eWmc5zRXDHA.1888@TK2MSFTNGP10.phx.gbl...[color=blue]
> How does one pass a parameter to the EXEC query recordset:
>
> set rs = cnn.execute("EXEC tblListings_qry2")
>
>[/color]

> set rs = cnn.execute("EXEC tblListings_qry2")

Numeric:

set rs = cnn.execute("EXEC tblListings_qry2 5")
set rs = cnn.execute("EXEC tblListings_qry2 @paramName = 5")

String:

set rs = cnn.execute("EXEC tblListings_qry2 'bob'")
set rs = cnn.execute("EXEC tblListings_qry2 @paramName = 'bob'")

I'd tell you how to pass dates, but you didn't bother telling us which
database you're using...

Thanks -it is a stored qry for Access.

"Tom B" <shuckle@hotmail.com> wrote in message
news:u3ehr5RXDHA.2200@TK2MSFTNGP09.phx.gbl...[color=blue]
> Assuming that tblListings_qry2 is a stored procedure than you would just
> append it
>
> Set RS=cnn.Execute("EXEC tblListings_qry2 5")
>
> if there are multiple parameters, you just separate them with commas
>
> Set RS=cnn.Execute("EXEC tblListings_qry2 5,3,'Bob''s your uncle', 99,
> 'hello','etc',1")
>
> "jason" <jason@catamaranco.com> wrote in message
> news:eWmc5zRXDHA.1888@TK2MSFTNGP10.phx.gbl...[color=green]
> > How does one pass a parameter to the EXEC query recordset:
> >
> > set rs = cnn.execute("EXEC tblListings_qry2")
> >
> >[/color]
>
>[/color]