first_page the funky knowledge base
personal notes from way, _way_ back and maybe today

Iterating Through a 0-Based Or 1-Based "Logical Group" Via the Number of Items in the Group

You will always have to subtract one from a zero-based group when iterating via the number of items in the group. For example, to iterate through the Fields collection of a TableDef object based on the Count property, you need to subtract 1 from the Count property as this collection is 0-based.

However a user-defined collection is 1-based and does not require subtracting by one.

Recall that the For - Each Next structure eliminates the need of using the Count property when iterating through the items in a collection.

mod date: 1998-03-28T07:36:00.000Z