Chapter 30. Working with Recordsets and Native Controls

Chapter 27, "Understanding the Data Access Object Class," introduced you to Jet Recordset objects created from tables and queries. The ability to manipulate Recordset objects with VBA is one of Access's most powerful programming features. This chapter shows you how to combine VBA, Recordset objects, and Access's native combo and list box controls to optimize the performance of decision support and online transaction processing (OLTP) applications, especially in a multiuser environment.

Native controls consist of the set of control objects that are incorporated within Access 97 or supplied as common components of Microsoft Office 97. Microsoft Office contributes the CommandBar objects contained ...

Get Special Edition Using Access 97, Second Edition 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.