In this chapter, we have looked at one of the key features that differentiates VBA from macros - the ability to work with sets of records at the record level. With macros, you can only see the big picture - you can deal with sets of records as a whole but there is no mechanism for manipulating individual records. With VBA, however, you can go down to the record level and then work on individual fields within each record. You will find that creating and manipulating Recordset objects is one of the most frequent and useful operations that you will perform if you choose to use DAO in VBA. If you can master the use of the Recordset object you have won most of the battle.
This chapter has covered:
What the Data Access Object hierarchy is and how it has developed.
What ActiveX Data Objects (ADO) is all about.
The chief components of DAO.
When to use the different types of Recordset objects - particularly tables, dynasets, and snapshots.
How to examine data in a Recordset using VBA.
Creating intelligent navigation buttons using the Move methods .
How to use Find and Seek to locate particular records.
The Bookmark property and what it is used for.
How to edit records in a Recordset.
However, that is just the beginning. In the next chapter we will look at some of the more advanced capabilities of the JET 4.0 engine and how we can access them through DAO.