AbsolutePage

Syntax

PositionEnum = recordsetobject.AbsolutePage

recordsetobject.AbsolutePage = PositionEnum

long = recordsetobject.AbsolutePage

recordsetobject.AbsolutePage = long

Description

Sets or returns a long value that is the current page number in the Recordset object,or the PositionEnum value (either BOF, EOF, or empty).

The AbsolutePage property sets or returns a long value that is the page number in the Recordset object. When you set this property to a page number, you will be moved to the first (top) record on the page you have specified. The AbsolutePage property may also return one of the PositionEnum constants. Note that you cannot set this property to any of the PositionEnum constants.

The first page is always numbered one. You use the PageSize property to set how many records are on a page. You use the PageCount property to determine how many pages are in the Recordset.

You can only use this property if AbsolutePage, PageCount, and PageSize are all supported by the provider (i.e., bookmarks are supported). You must also be pointing to a valid record when attempting to use this property. If you are not pointing to a valid record, this property will return one of the PositionEnum constants which specify the current position of the record pointer in the Recordset.

PositionEnum Constants

Constant	Value	Description
adPosUnknown	-1	The Recordset is empty, the current position is unknown, or not supported by the provider
adPosBOF	-2	The current record pointer is before the first record at the beginning of the file
adPosEOF	-3	The current record pointer is after the last record at the end of the file

See Also

Recordset.

Example

objRecordset.PageSize = intPageSize

objRecordset.AbsolutePage = 1