Affects only records that satisfy the Filter setting (Filter must be
set to a FilterGroupEnum
value or an array of Bookmarks)

adAffectAll

3

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 Recordset if Filter is set to a FilterGroupEnum
value or an array of Bookmarks

adAffectAllChapters

4

Affects all records in all child Recordset, including those hidden
by a currently applied filter

Web Certificates

W3Schools is optimized for learning, testing, and training. Examples might be simplified to improve reading and basic understanding.
Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content.
While using this site, you agree to have read and accepted our terms of use,
cookie and privacy policy.
Copyright 1999-2016 by Refsnes Data. All Rights Reserved.Powered by W3.CSS.