ADO: ActiveX Data Objects

Name

Recordset.AbsolutePage Property — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     absolutepage = recordset.AbsolutePage

The AbsolutePage property returns or sets a value that indicates the current page in the recordset.

Datatype

Long

Description

By setting the AbsolutePage property, you are instructing ADO to move the record pointer to the first record within the page that you specified. The AbsolutePage property can be set from 1 to the number returned by the PageCount property, which is the total number of logical pages. The size of each page is determined by the PageSize property.

By reading the AbsolutePage property, you can determine in which logical page the record pointer is located. The AbsolutePage property can return a Long value indicating the current page or a PositionEnum value.

If when reading the AbsolutePage property, the record pointer is pointing to the BOF marker, then the value adPosBOF (-2) is returned. If the record pointer is at the EOF marker, then the adPosEOF (-3) value is returned. If the recordset is empty, if the record pointer’s position is unknown or if the data provider does not support the AbsolutePage property, then the value adPosUnknown (-1) is returned.

The AbsolutePage property is 1-based, meaning that a value of 1 indicates the first page in the recordset.

Note

Not all providers support the AbsolutePage property.

See Also

CursorOptionEnum Enumeration, PositionEnum Enumeration, Recordset.Count Property, Recordset.Filter Property, Recordset.PageSize Property, ...