Automating Microsoft Access with VBA - page 1
- Automating Microsoft Access with VBA
- Automating Microsoft Access with VBA
- Automating Microsoft Access with VBA
- Copyright
- About the Authors
- Acknowledgments
- We Want to Hear from You
- Introduction
- Who This Book Is For
- What s in This Book
- Conventions Used in This Book
- The Sample Code for This Book
- Contacting the Authors
- Part I: Laying the Foundation
- Chapter 1. Why Access? Why VBA?
- Understanding the Place of Access in Office
- Understanding Access Programming Choices
- Chapter 2. Getting Around in the Visual Basic Editor
- Your First Glance at the Visual Basic Editor
- Introducing the VBA Modules
- Entering and Running VBA Code
- Getting Help on Code
- Establishing Good Habits in Coding
- Chapter 3. Using Variables, Constants, and Data Types
- Declaring Variables and Constants
- VBA Data Types
- Referencing Syntax
- Chapter 4. Using Procedures
- Understanding Procedure Types
- Declaring Procedures as Public or Private
- Passing Arguments
- Giving a Function a Data Type
- Implementing Error Handling
- Debugging Code
- Chapter 5. Choosing the Right VBA Function
- Introducing VBA s Built-in Functions
- Converting Data Types with VBA Functions
- Working with Date Functions
- Using Mathematical and Financial Functions
- Using String Functions
- Using the Format Function
- Using the Is Functions for Flawless Processing
- Interacting Functions
- Chapter 6. Using Flow-of-Control Statements
- Branching and Looping
- Using If...Then...Else
- Using Select Case
- Using For...Next
- Using Do Loops
- Using GoTo
- Chapter 7. Working with Arrays
- Introducing Array Variables
- Declaring an Array Variable
- Understanding the Array s Index
- Working with Array Elements
- Arrays with Multiple Dimensions
- Expanding to Dynamic Arrays
- Chapter 8. Understanding Objects
- Introducing Objects
- Reading and Setting Properties
- Invoking Methods
- Working with Collections
- Working with an Object Model
- Creating Your Own Objects
- Working with Events
- Chapter 9. Understanding Scope and Lifetime
- What s Scope?
- Measuring the Lifetime of a Variable or Constant
- Using Static Variables
- Part II: Working with the Access User Interface
- Chapter 10. Working with Forms
- Opening and Closing Forms
- The Form Module and Event Handling
- Performing Common Tasks
- Handling Errors at the Form Level
- Working with Multiple Form Instances
- Chapter 11. Analyzing the Access Event Model
- Responding to Events
- The Event Sequence for Controls
- Data Events
