AbsolutePage The AbsolutePage property sets or returns a long value that specifies the page number in the Recordset object. It sets or retur...
AbsolutePage
The AbsolutePage property sets or returns a long value that specifies the page number in the Recordset object. It sets or returns a value from 1 to the number of pages in the Recordset, or it returns a PositionEnum value. The value is 1 when the current record is the first record in the Recordset.Tip: To get the total number of pages in the Recordset, use the PageCount property.
Tip: To divide the Recordset into a series of pages, use the PageSize property.
Note: This property can only be used if the AbsolutePage, PageCount, and PageSize properties are supported by the provider.
AbsolutePosition
The AbsolutePosition property sets or returns a long value that specifies the ordinal (numeric) position of the current record in the Recordset object. It sets or returns a value from 1 to the number of records in the Recordset, or it returns a PositionEnum value. The value is 1 when the current record is the first record in the Recordset.When you set this property to a number, you will be moved to the record at the numeric position.
Tip: To get the total number of records in the Recordset, use the RecordCount property.
Note: Do not use this property to uniquely identify a record!
Syntax
objRecordset.AbsolutePage objRecordset.AbsolutePosition |
PositionEnum Values
Constant | Value | Description |
---|---|---|
adPosUnknown | -1 | Indicates that the Recordset is empty, the current position is unknown, or the provider does not support the AbsolutePage or AbsolutePosition property |
adPosBOF | -2 | Indicates that the current record pointer is before the first record (BOF) |
adPosEOF | -3 | Indicates that the current record pointer is after the last record (EOF) |