code referenceing stored procedure put in recordset

[seeker63]

Why would following code give error "invalid property use" at rst



Dim cmd As ADODB.Command
Dim rst As ADODB.Recordset
Set cmd = New ADODB.Command
cmd.ActiveConnection = CurrentProject.Connection
cmd.CommandType = adCmdStoredProc
rst = cmd.Execute("prcRPTPlantPastDuePaymentsReportCO2")

[Dal Jeanis]

It may be just the word "Set" missing before rst =, but your usage doesn't seem to match the parameters of the Execute method for a Command object: http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx

I'd switch the code to something like:

   Set cmd = New ADODB.Command
   cmd.ActiveConnection = CurrentProject.Connection
   cmd.CommandText = "prcRPTPlantPastDuePaymentsReportCO2"
   cmd.CommandType = adCmdStoredProc
   Set rst = cmd.Execute()

You can also try this syntax replacing the last line:

   Set rst = New ADODB.Recordset
   rst.Open cmd

Reference - http://msdn.microsoft.com/en-us/library/office/aa160695

[seeker63]

Seems to have done the trick. Thanks.

[Dal Jeanis]

You're welcome. Please mark thread as solved. Top of page, under thread tools.