Private Sub rs_RecordChangeComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal cRecords As Long, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
End Sub
在其中加上你的统计代码,例如:
Private Sub rs_RecordChangeComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal cRecords As Long, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
Dim rs1 As New ADODB.Recordset
Set rs1 = cnn.Execute("SELECT Sum(Price) AS TotalPrice FROM Table") 'cnn是你已经定义的连接
Text1 = rs1!TotalPrice & ""
rs1.Close
Set rs1 = Nothing