Access^TM 2007 VBA Programming For Dummies^®

by Joseph C. Stockman; Alan Simpson

• ISBN13: 9780470148044
• ISBN10: 0470148047
• Format: eBook
• Copyright: 2007-05-01
• Publisher: For Dummies

Summary

If you've been using Access for a while, you're probably aware of its power and potential and itching to take advantage of both. Access 2007 VBA Programming For Dummies takes you beyond forms and reports and shows you how to use VBA to create killer Access databases and applications. This gentle introduction to VBA programming covers everything you need to get started, including: Basic programming skills and concepts Explanations of modules, procedures, objects, and arguments Access-unique programming activities, including SQL and recordsets How to use the Visual Basic editor Creating dialog boxes, lists, drop-down menus, and functions Integrating with other Office applications Ready-to-use VBA code examples to type in or copy and paste from the Web Completely revised to reflect all changes found in Microsoft Access 2007, Access 2007 VBA Programming For Dummies gives you access to Access like you've never had it before.

Table of Contents

Introduction

Introducing VBA Programming

Where VBA Fits In

Your VBA Toolkit

Jumpstart : Creating a Simple VBA Program

VBA Tools and Techniques

Understanding Your VBA Building Blocks

Controlling Access through VBA

Programming Access Forms

VBA , Recordsets, and SQL

The Scoop on SQL and Recordsets

Putting Recordsets to Work

Applying VBA in the Real World

Creating Your Own Dialog Boxes

Customizing Combo Boxes and List Boxes

Creating Your Own Functions

Testing and Debugging Your Code

Reaching Out with VBA

Using VBA with Multiple Databases

Integrating with Other Office Applications

The Part of Tens

Ten Commandments of Writing VBA

Top Ten Nerdy VBA Tricks

Index

Table of Contents provided by Publisher. All Rights Reserved.