Microsoft Access VBA Macro Programming

This page intentionally left blank ...

Acknowledgments W ith grateful thanks to all the people at McGraw-Hill who have made this book happen. Special thanks to Joya An ...

This page intentionally left blank ...

Introduction D atabase macro programming has changed enormously over the last 15 years, having gone from Access Basic macros to ...

Since VBA is shared by all Office applications, a great deal of the information contained in this book will help with other Offi ...

The book is full of completed examples, all tried and tested, in which you are walked through each step of what the code is doin ...

This page intentionally left blank ...

PA RT I Programming in Access VBA In this part, you will learn all about how Visual Basic for Applications (VBA) works for Acces ...

Access is frequently used in organizations to produce RAD (Rapid Application Development) applications. It has a huge advantage ...

CHAPTER 1 The Basics T his chapter is intended to take you through the basic steps of using the Visual Basic Editor window and w ...

Exploring the Visual Basic Editor in Access If you use Access a lot, you are familiar with its database layout. When you open Ac ...

Many users are unaware that, in addition to the database application of Access, there is an extremely powerful programming langu ...

At first glance, this window with its new menu bar, containing menus for File, Edit, View, Insert, Format, Debug, Run, Tools, Ad ...

If you imagine that in Access the forms and reports take the place of dialogs and worksheets in Excel, then you can also have mo ...

This gives you a code area to write your VBA code against. Notice that in the drop-down list in the top right-hand corner of the ...

Your First Access VBA Macro Programming books traditionally help direct your first steps in a program by writing a simple piece ...

Make sure you click the cursor on the body of the subroutine before you run it so VBA knows which procedure to run. Your screen ...

To remove this procedure, simply delete all the lines for it or delete the line MsgBox "Hello World" by pressing theDELETEkey. A ...

Saving Your Code. Knowing how to save your code along with the workbook file you are using is important. The process is quite si ...

Chapter 2 Variables, Arrays, Constants, and Data Types Chapter 2 Variables, Arrays, Constants, and Data Types A lthough the conc ...