Beginning Access 2007 VBA

Introduction

Try It Out

Chapter 2: The Basics of Writing and Testing VBA Code

Try it Out-Create a Database to Use with Examples in the Chapter

Try It Out-Creating the VerifyCreditAvail Procedure

Try It Out-Calling VerifyCreditAvail from Another Procedure

Try It Out-Create New Procedure for frmTest Using Code Builder

Try It Out-Creating the CalculateSalesTax Function

Try It Out-Declaring a Public Variable

Try It Out-Creating TestIfStatement Procedure

Try It Out-Create the TestCaseStatement Procedure

Try It Out-Creating a For … Next Loop

Try It Out-Setting and Using Breakpoints

Try It Out-Using the Locals Window

Try It Out-Adding a Watch

Try It Out-Creating an Error Handler

Try It Out-Creating a Generic Error Handler

Chapter 3: Programming Applications Using Objects

Try It Out-Using Properties, Methods, and Events

Try It Out-Using the Forms Collection and Form Object

Try It Out-Using the Screen Object

Try It Out-Using the Printers Collection and Printer Object

Chapter 4: Creating Your Own Objects

Try It Out-Creating the Properties for the Car Class

Try It Out-Creating the Methods for the Car Class

Try It Out-Creating an Event for the Car Class

Try It Out-Using the Properties, Methods, and Events of the Car Class

Try It Out-Adding New Property for frmCarDetails Form

Try It Out-Adding New Method for the frmCarDetails Form

Chapter 5: Interacting with Data Using ADO and SQL

Try It Out-Building a Contacts Form Bound to a Recordset

Try It Out-Building an Unbound Contacts Form Using a Disconnected Recordset

Try It Out-Sorting Records for the Unbound Contacts Form

Try It Out-Modify the Unbound Contacts Form to Use SQL

Chapter 6: Building Interactive Forms

Try It Out-Building a Switchboard Form

Try It Out-Populating Combo and List Boxes

Try It Out-Adding Data Validation to the frmPayments Form

Chapter 7: Importing, Linking, and Exporting Using External Data Sources

Try It Out-Importing Data from the Sample Northwind Database

Try It Out-Importing Data from a Text File

Chapter 8: Using Access with Web Services and SharePoint Lists

Try It Out-Adding a Reference to a Web Service

Try It Out-Consuming the GetPlaceFacts Method

Try It Out-Importing Lists Using the Wizard

Try It Out-Programmatically Linking a List Using DoCmd Object

Try It Out-Programmatically Linking a List Using a TableDef Object

Chapter 9: Creating Reports and Web-Enabled Output

Try It Out-Creating a Report Programmatically

Try It Out-Exporting the tblComplaints Table to HTML

Chapter 10: Building SQL Server Applications with Access Projects

Try It Out-Creating an Access Project Using a New SQL Server Database

Try It Out-Creating a New SQL Server Table

Try It Out-Creating a New SQL Server Stored Procedure

Try It Out-Creating a New View

Chapter 11: Advanced Access Programming

Try It Out-Using the Microsoft Office Object Library to Create a Custom Command Bar

Try It Out-Using an External DLL to Get System Information

Try It Out-Controlling an Excel Spreadsheet from Access

Try It Out-Creating Word Letters from Access

Try It Out-Sending an Outlook E-mail from Access

Try It Out-Creating and Using a Code Library

Chapter 12: Finishing the Application

Try It Out-Using the Database Splitter Wizard to Separate Database Tables from the User Interface

Try It Out-Using the Performance Analyzer

Chapter 13: Case Study 1-Project Tracker Application

Try It Out-Building the ProjectTrackerDb Database

Try It Out-Building the frmProjects and frmContacts Forms

Try It Out-Building the clsProjects Class

Try It Out-Building the clsContacts Class

Try It Out-Building the modBusinessLogic and modDatabaseLogic Modules

Try It Out-Writing Code for the frmProjects Form

Try It Out-Writing Code for the frmContacts Form

Chapter 14: Case Study 2-Customer Service Application

Try It Out-Building the CustomerServiceSQL Database

Try It Out-Building the frmSearch and frmCustomers Forms

Try It Out-Building the clsCustomer Class

Try It Out-Building the modBusinessLogic and modDatabaseLogic Modules

Try It Out-Writing Code for the frmSearch

Try It Out-Writing Code for the frmCustomers