Microsoft Access 2010 Bible

Chapter 13: Accessing Data with VBA Code 493 Public Sub ExecuteCommand1 Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset ...

Part II: Programming Microsoft Access 494 Command objects are most valuable when working with parameterized queries. Each Comman ...

Chapter 13: Accessing Data with VBA Code 495 Many developers prefer the approach in OpenRecordset2 because it’s easier to see ex ...

Part II: Programming Microsoft Access 496 Debug.Print rs!CustomerID, rs!Company rs.MoveFirst Debug.Print rs!CustomerID, rs!Compa ...

Chapter 13: Accessing Data with VBA Code 497 Table 13.2 shows the permissible values for CursorType. TABLE 13.2 CursorType Value ...

Part II: Programming Microsoft Access 498 The Use_EOF_BOF procedure illustrates using EOF and BOF in an ADO Recordset: Public Su ...

Chapter 13: Accessing Data with VBA Code 499 RecordCount is a convenient way to determine whether a recordset contains any recor ...

Part II: Programming Microsoft Access 500 FIGURE 13.13 The DAO object model DBEngine Workspace Database TableDef QueryDef Record ...

Chapter 13: Accessing Data with VBA Code 501 Note Microsoft Access 2007 introduced ACE (Microsoft Access Engine), a new database ...

Part II: Programming Microsoft Access 502 The DAO Database object A Database object represents a data source and is analogous to ...

Chapter 13: Accessing Data with VBA Code 503 On Error GoTo 0 Set db = CurrentDb Set tdfNew = db.CreateTableDef(“MyTempTable”) Wi ...

Part II: Programming Microsoft Access 504 Creating a QueryDef in code is similar to creating a TableDef except that the new Quer ...

Chapter 13: Accessing Data with VBA Code 505 Debug.Print “Number of records: “ & rs.RecordCount Set GetRecordset = rs rs.Clo ...

Part II: Programming Microsoft Access 506 Public Sub OpenDAORecordset1() Dim db As Database Dim rs As Recordset Dim i As Long Se ...

Chapter 13: Accessing Data with VBA Code 507 Not every property associated with a Field object is valid at a particular time. So ...

Part II: Programming Microsoft Access 508 Writing VBA Code to Update a Table Updating data in a table by using a form is easy. Y ...

Chapter 13: Accessing Data with VBA Code 509 Updating fields in a record using ADO Use the AfterUpdate event procedure to update ...

Part II: Programming Microsoft Access 510 As a data access interface, ADO allows you to write programs to manipulate data in loc ...

Chapter 13: Accessing Data with VBA Code 511 In this example, the recordset properties are set as part of the Open statement. Ei ...

Part II: Programming Microsoft Access 512 When working with datasheets and recordsets only one record is active. In a datasheet ...