affectrecords | (Long) The AffectEnum value that specifies which records this method will affect.
1 - adAffectCurrent - Affects only the current record.
2 - adAffectGroup - Affects only records that satisfy the filter setting
The Filter property must be set to a FilterGroupEnum value or an array of Bookmarks. The adAffectGroup value will generate an error if there are no visible records in the AdoRecordset object. 3 - adAffectAll - Affects all records if there is no Filter. Affects only visible records in the current chapter if Filter is set to a string criteria. Affect all rows of the AdoRecordset object if filter is set to a FilterGroupEnum value or an array of Bookmarks.
4 - adAffectAllChapters - Affects all records in all child AdoRecordset objects, including those hidden by a currently applied filter. |
---|
oRs.UpdateBatch(Val, 1);