Module 0167: Loops in VBA

Tak Auyeung, Ph.D.

April 27, 2009
1 About this module
2 Loops in VBA
3 RecordSet
 3.1 How do I make one?
 3.2 How do I connect a RecordSet to a table?
 3.3 Starting from the beginning
 3.4 Accessing fields (columns) of a record (row)
 3.5 Moving to the next record (row)
 3.6 Are we at the end of a RecordSet?
4 Using a Loop
 4.1 Start with a Contact database
 4.2 Modify the “Contacts” table
 4.3 Create an empty form
 4.4 Writing the VBA code
5 Conclusion