Recordset properties, methods, and events (ADO)

Applies to: Access 2013, Office 2013

Properties/Collections

• AbsolutePage property
• AbsolutePosition property
• ActiveCommand property
• ActiveConnection property
• BOF, EOF properties
• Bookmark property
• CacheSize property
• CursorLocation property
• CursorType property
• DataMember property
• DataSource property
• EditMode property
• Fields collection
• Filter property
• Index property
• LockType property
• MarshalOptions property
• MaxRecords property
• PageCount property
• PageSize property
• Properties collection
• RecordCount property
• Sort property
• Source property (ADO Recordset)
• State property
• Status property (ADO Recordset)
• StayInSync property

Methods

• AddNew method
• Cancel method
• CancelBatch method
• CancelUpdate method
• Clone method
• Close method
• CompareBookmarks method
• Delete method (ADO Recordset)
• Find method
• GetRows method
• GetString method
• Move method
• MoveFirst, MoveLast, MoveNext, and MovePrevious methods
• NextRecordset method
• Open method (ADO Recordset)
• Requery method
• Resync method
• Save method
• Seek method
• Supports method
• Update method
• UpdateBatch method

Events

• EndOfRecordset event
• FetchComplete event
• FetchProgress event
• WillChangeField and FieldChangeComplete events
• WillChangeRecord and RecordChangeComplete events
• WillChangeRecordset and RecordsetChangeComplete events
• WillMove and MoveComplete events