ADO AbsolutePage and AbsolutePosition Property


❮ Complete Recordset Object Reference

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)

❮ Complete Recordset Object Reference
Copyright 1999-2023 by Refsnes Data. All Rights Reserved.