O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

E.9. Record Object

The Record object represents a row from a Recordset or any object returned by a data provider. A Record object contains data from the row and allows the user to easily access that data.

E.9.1. Properties of the Record Object

The following table describes the properties associated with a Record object.

PropertyDataTypeDescription
ActiveConnectionVariantThe Connection object used to retrieve the data for the Record object.
ModeConnectModeEnumSpecifies the permissions for modifying the Record object.
ParentURLStringThe Parent URL for the Record object.
RecordTypeRecordTypeEnumSpecifies the type of the Record object.
SourceVariantSpecifies the source of the data contained in the Record object.
StateObjectStateEnumIndicates the state of the Record object.

E.9.2. Methods of the Record Object

The Record object has seven methods, defined in the following table.

MethodDescription
CancelCancels an asynchronous action on the Record object.
CloseCloses an open Record object.
CopyRecordCopies the Record object to another location.
DeleteRecordDeletes the current record.
GetChildrenRetrieves the child data associated with the Record object.
MoveRecordMoves the Record to another location.
OpenOpens an existing Record or creates a new Record.

E.9.3. Collections of the Record Object

The Record object has two collections, just like the Recordset object. These collections are described in the following table.

CollectionDescription
FieldsContains all the Field objects for the data contained ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required