I can use the following code to call a "select * from...." stored procedure from VBA
Dim cmd as ADODB.Command
Dim paramRegionCode As ADODB.Parameter
Set cmd = New ADODB.Command
Set paramRegionCode = New ADODB.Parameter
.Name = "@my_param"
.Type = adVarChar
.Size = 2
.Value = rs!parameter
.ActiveConnection = CurrentProject.Connection
.CommandType = adCmdStoredProc
.CommandText = "my_stored_proc"
After I call the stored procedure, i need to know if any results were found or not - i.e. a true or false value. (The same thing as using "if rs.EOF = False then..." with recordsets)
Is this possible? How?