Access 2002 VBA HandbookHow Far Can You Go with Access 2002? The answer depends on your knowledge of VBA programming. If you really want to get the most out of Access, the Access 2002 VBA Handbook is essential reading. If you are an experienced user of Access, you get the step-by-step instruction you need to be dramatically more productive. And if you are a more experienced developer, you get the advanced VBA programming skills you need to build the Access applications your users require. Coverage includes * Running queries to find specific records * Automating complex and time-consuming procedures * Importing data from existing data sources * Synchronizing forms and tables * Understanding the ADO and DAO models * Understanding the essentials of Visual Basic for Applications (VBA) * Customizing the Access user interface * Creating procedures to change Access's default error-handling processes * Accessing data using OLE DB and ODBC * Creating VBA procedures for navigating a database or project * Writing VBA procedures using object properties and methods * Creating relationships between forms * Executing commands using SQL statements in VBA code * Using ActiveX controls in your VBA procedures |
Contents
Introduction | xxv |
Automating a Database without Programming | 1 |
Using the Task Pane | 3 |
Copyright | |
342 other sections not shown
Common terms and phrases
Access VBA argument assign Automation Bookmark built-in called Cancel Chapter Click collection column combo box command button CompanyName create current record pointer CustomerID Customers form data access objects data type database engine Database window default delete Design view dialog displays dynamic array EmployeeID Employees End Sub event procedure example Figure Filter form or report Form view function procedure hyperlink Immediate window keyword list box Long integer loop menu bar method Microsoft Access Microsoft SQL Server module MsgBox Northwind object variable ODBC open form option Orders press Enter primary key Private Sub procedure shown property sheet Public Sub QueryDef Read-only Read/write Recordset object recordsetclone refer Requery returns shortcut menu specify SQL statement stored string expression strSQL subform Switchboard syntax table or query text box toolbar Update Variant VBA procedure VBA programming Visual Basic Wizard