Objects

The ADOCE control has two objects: Recordset and Field. Use CreateObject to create a new Recordset object. Field objects should not be directly created because they exist only in the context of an existing recordset. Use Set to refer to a specific Field object.

Example

Dim rstCustomers, fldName
Set rstCustomers = CreateObject("adoce.recordset")
rstCustomers.Open "customers"
Set fldName = rstCustomers.Fields("Name")
MsgBox fldName.Value
rstCustomers.Close
Set fldName = Nothing
Set rstCustomers = Nothing