ExecuteComplete event (ADO)
Applies to: Access 2013, Office 2013
The ExecuteComplete event is called after a command has finished executing.
Syntax
ExecuteCompleteRecordsAffected, pError, adStatus, pCommand, pRecordset, pConnection
Parameters
| Parameter | Description |
|---|---|
| RecordsAffected | A Long value indicating the number of records affected by the command. |
| pError | An Error object. It describes the error that occurred if the value of adStatus is adStatusErrorsOccurred; otherwise it is not set. |
| adStatus | EventStatusEnum. Before this event returns, set this parameter to adStatusUnwantedEvent to prevent subsequent notifications. |
| pCommand | The Command object that was executed. Contains a Command object even when calling Connection.Execute or Recordset.Open without explicitly creating a Command, in which cases the Command object is created internally by ADO. |
| pRecordset | A Recordset object that is the result of the executed command. This Recordset may be empty. You should never destroy this Recordset object from within this event handler. Doing so will result in an Access Violation when ADO tries to access an object that no longer exists. |
| pConnection | A Connection object. The connection over which the operation was executed. |
Remarks
An ExecuteComplete event may occur due to the Connection.Execute, Command.Execute, Recordset.Open, Recordset.Requery, or Recordset.NextRecordset methods.