• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Working with ADO Recordsets,... > Navigating Recordsets with VBA

Navigating Recordsets with VBA

Recordsets are the foundation for all Access data-related operations. The VCR-style navigation buttons of datasheets and bound forms manipulate the record pointer of the underlying Recordset. The following sections show how you emulate Access's navigation buttons with Visual Basic for Applications (VBA) code and use loops to automate processing of an entire Recordset.

This chapter's examples and sample code use ActiveX Data Objects (ADO) 2.1 ADODB.Recordsets exclusively. As noted in Chapter 27, "Understanding Universal Data Access, OLE DB, and ADO," the foundation for Access's future is ADO. ADO is Microsoft's chosen data model for Internet and intranet applications, the Microsoft Data Engine (MSDE), and SQL Server 7.0. New databases you create with Access 2000 use ADO 2.1 by default. Access Data Projects (ADP) and Data Access Pages (DAP) require you to use ADO 2.1+. Unlike Data Access Objects (DAO), a technology that is intimately tied to the Jet database engine, OLE DB makes ADO independent of the Recordset's underlying data source. Thus Microsoft can—and undoubtedly will—upgrade ADO independently of future upgrades to Access. It's highly unlikely that Microsoft will upgrade DAO beyond the version 3.6 that's included with Access 2000.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint