O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required