Edit

Share via

AffectEnum

  • Article

Applies to: Access 2013, Office 2013

Specifies which records are affected by an operation.

Constant

Value

Description

adAffectAll

3

If there is not a Filter applied to the Recordset, affects all records. If the Filter property is set to a string criteria (such as "Author='Smith'"), the operation affects visible records in the current chapter. If the Filter property is set to a member of the FilterGroupEnum or an array of Bookmarks, the operation will affect all rows of the Recordset.

NOTE: adAffectAll is hidden in the Visual Basic Object Browser.

adAffectAllChapters

4

Affects all records in all sibling chapters of the Recordset, including those not visible via any Filter that is currently applied.

adAffectCurrent

1

Affects only the current record.

adAffectGroup

2

Affects only records that satisfy the current Filter property setting. You must set the Filter property to a FilterGroupEnum value or an array of Bookmarks to use this option.

ADO/WFC equivalent

Package: com.ms.wfc.data

Constant

AdoEnums.Affect.ALL

AdoEnums.Affect.ALLCHAPTERS

AdoEnums.Affect.CURRENT

AdoEnums.Affect.GROUP