Access 2007 Programming by Example with VBA, XML, and ASP

Chapter 13Finding and Reading Records

In order to work with data, you need to learn how to use the Recordset object. The Recordset object represents a set of records in a table, or a set of records returned by executing a stored query or an SQL statement. Each column of a Recordset represents a field, and each row represents a record. The Recordset is a temporary object and is not saved in the database. All Recordset objects cease to exist after the procedure ends. All open Recordset objects are contained in the Recordsets collection. Creating and using the Recordset objects depends on the type of the object library (DAO/ADO) that you’ve selected for your programming task. In this chapter, you will learn various methods of opening the Recordset ...