? lvRetVal.Fields(0).Value
gives me
"Member FIELDS does not evaluate to an object" error.

>I never thought second is supposed to work. Where does it say it should work?
Microsoft ADO help file "C:\Program Files\Common Files\Microsoft Shared\OFFICE11\1033\ADO210.CHM"
Connection Object - bottom of the page
"Execute a stored procedure as a native method of a Connection object

To execute a stored procedure, issue a statement where the stored procedure name is used as if it were a method on the Connection object, followed by any parameters. ADO will make a "best guess" of parameter types. For example:

Dim cnn As New ADODB.Connection
...
'Your stored procedure name and any parameters.
cnn.sp_yourStoredProcedureName "parameter"
"