Access^TM 2007 VBA Programmer's Reference

by Teresa Hennig; Rob Cooper ( ; ); Geoffrey L. Griffith; Armen Stein

• ISBN13: 9780470147993
• ISBN10: 0470147997
• Format: eBook
• Copyright: 2007-07-01
• Publisher: Wrox

Summary

This resource provides the tools you need to leverage Access 2007's built-in functionality and VBA in order to build more dynamic applications. The author team explores all aspects of VBA programming for Access, describes the latest innovations, and explains how to take advantage of key new objects, enhanced macros, and the Office Ribbon. Plus, you'll find several commonly used techniques and sample code to help you get started, as well as expert tips to make your code easier to maintain.

Table of Contents

Introduction

Introduction to Microsoft Access

Access, VBA, and Macros

New Features in Access 2007

Using the VBA Editor

VBA Basics

Using DAO to Access Data

Using ADO to Access Data

Executing VBA

VBA Error Handling

Using VBA to Enhance Forms

Enhancing Reports with VBA

Customizing the Ribbon

Creating Classes in VBA

Extending VBA with APIs

SQL and VBA

Working with Office Applications

Working with SharePoint

Database Security

Understanding Client/Server Development with VBA

Working with the Win32 Registry

Using the ADE Tools

Protecting Yourself with Access 2007 Security

Upgrading to Access 2007

References for Projects

Calling Managed Code

DAO Object Method and Property Descriptions

ADO Object Model Reference

ADO Object Argument Information

The Access Object Model

Windows API Reference Information

Windows Registry Information

Access Wizards, Builders, and Managers

Reserved Words and Special Characters

Naming Conventions

Tips and Tricks

Index

Bibliography

Table of Contents provided by Publisher. All Rights Reserved.