1. Introducing Access VBA
Converting Macros to VBA
The VBA programming environment
The Visual Basic Editor
Event driven programming
Regular and Class modules
Building Procedures
Building Custom Functions2. VBA Programming Basics
Good practice in VBA coding
Using Variables
Array Variables
Writing conditional code
Code loops
Compiling and debugging code
Dealing with errors
3. Error Handling in VBA
Ignoring Errors
Trapping Errors
Writing Error Handlers
Logging Errors |
|
4. Working with Forms
Form properties and events
Control properties and events
Working with Event Procedures
Using VBA to validate data
Automating form navigation
Building tools for finding records
Working with command buttons
Working with combo boxes
Working with list boxes
Working with option groups
Creating dialog boxes
Creating switchboards
Building a splash screen
Manipulating a form's Recordset5. Working with Reports
Opening reports programmatically
Manipulating reports with VBA
Creating dynamic reports |
|
6. Manipulating Data with ADO and SQL
ActiveX Data Objects (ADO)
Connecting to data sources
Database and Recordset Objects
Manipulating Data with VBA
Finding Records in a Recordset
Editing Data in a Recordset
Transaction Processing
Using Recordsets to import data
Manupulating Queries from VBA
Changing Database Definitions through VBA
Using SQL to Manipulate Databases
SQL Data Modification Statements
Methods of Running SQL from VBA Code
Data Access Objects (DAO)7. Working with Other Programs
About VBA Automation
Exporting data programmatically
Writing data to other programs
Retrieving data from other programs |
