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

Part 7: Programming and Converting Acces... > Working with Recordsets and Native C...

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 in Mso97.dll and the Graph object contributed by Graph8.exe, an Automation server.

Note

ActiveX controls, the subject of Chapter 31, "Exchanging Data with Automation and ActiveX Controls," aren't native Access controls. You must create a reference to the ControlName.ocx file in your Access front-end database and install the ActiveX control on any PC that uses the database.

To program the Graph object with VBA, you must manually add a reference to the Microsoft Graph 8.0 Object Library (MSgraph8.olb). Access 97 automatically adds a reference to the Microsoft Office 97 Object library incorporated in Mso97.dll, but not that for the Graph object. You don't need a reference to MSgraph8.olb to use the Graph object in an Access form or report.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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