Return Rows Affected Value 1

[dazzer123]

I'm running a stored procedure in my VBA that runs an Update Query based on certain parameters.

I would like the VBA to then return how many rows were affected by the Update yet I am unsure how to do this.

Does anyone have any ideas?

 

[cmmrfrds]

Assumes an ADODB Recordset. Example.

Dim sql1 As String, recsAffected As Integer, audID As Long
Dim cnt As Integer
sql1 = "Update dbo_Epic_TrackPayorProviderTpins Set " & _
"EpicExtractFlag = '1' " & _
"Where AuditID = " & audID
cn.Execute sql1, recsAffected

Debug.Print "records updated = "; recsAffected; " for AuditID = "; audID

 

[dazzer123]

Thanks for your help, i'll give this a go