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 ...
Get Access 2007 Programming by Example with VBA, XML, and ASP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.