ADO Command
Printer Friendly Page
Create a command object to update, add and delete records
Dim rcmd As ADODB.Command
Set rcmd = New Command
rcmd.ActiveConnection = gConn
rcmd.CommandType = adCmdText
Execute a command
rcmd.CommandText = strsql
rcmd.Execute
The value of
STRSQL can be any query that updates, adds and deletes records.