Access 2000 VBA HandbookWant to get the most out of Access? Then you need to know VBA. Access 2000 is here, and never has the power of Access depended so much on VBA programming. This makes the Access 2000 VBA Handbook essential reading if you want to use Microsoft's popular database product to its full advantage. If you're an Access user, you'll benefit from step-by-step coverage of VBA basics that will simplify your work. If you're a developer, you'll master the high-end techniques introduced in the latest release-so you can stay on top of your job. You'll learn how to: * Create databases and projects * View and print reports * Run queries to find specific records * Automate complex and time-consuming procedures * Synchronize forms and tables * Understand the ADO and DAO models * Customize the user interface * Access data using OLE DB and ODBC * Create VBA procedures for navigating a database or project * Use object properties and methods to write VBA procedures * Create relationships between forms * Execute commands using SQL statements in VBA code * Use ActiveX controls in your VBA procedures |
Contents
Automating a Database without Programming | 1 |
Automating a Database without Programming | 2 |
1 | 28 |
Copyright | |
28 other sections not shown
Common terms and phrases
ActiveX control argument assignment Automation Bookmark built-in called Cancel Chapter class module Click collection combo box command button create CustomerID Customers form data access objects data type database engine Database window declaration default delete Design view dialog display Edit EmployeeID End Sub event procedure example Expense Reports field Figure Filter focus form or report Form view form's function procedure hyperlink Immediate window Insert Integer keyword list box loop macro action Main Switchboard menu bar method Microsoft Access MSDE MsgBox Northwind Object Property object variable ODBC open form option press Enter primary key Private Sub property sheet Public Sub QueryDef Read-only record source Recordset object refer Reports by Employee Requery returns shortcut menu specify SQL statement Startup stored subform Switchboard syntax table or query TableDef text box toolbar Update VBA procedure VBA programming Visual Basic