display resultset

[simma]

Hello
Can the resultset from sp with parameter input from form can be displayed in immediate window?
Thanks

 

[wokkie]

you can do something like:

do while not rs.eof
debug.print rs("myField")
rs.movenext
loop

This will show the the selected field from the rs for each row.

Does this help?

 

[cmmrfrds]

Return the results from the SP to an ADO recordset.

Something like;
Dim rs as New ADODB.Recordset
Dim cn as New ADODB.Connection
'set up connection.
Set rs = cn.Execute dbo.yoursp

Debug.Print rs.GetString

Look up GetString as it will take arguments to further format the results.

 

[simma]

Thanks Guys!!