Automating Microsoft Access with VBA

Enhanced descriptions from Syndetics:

If you use Microsoft Access in your every day business life but haven't learned to fully exploit the program, now's your chance. Automating Microsoft Access with VBA is a thorough introduction to programming Microsoft Accessing using Visual Basic for Applications (VBA). With this book, you will gain a working knowledge of VBA and be able to customize your Microsoft Access databases. You will cover topics that include:

Table of contents provided by Syndetics

• Introduction (p. 1)
• Who This Book Is For (p. 1)
• What's in This Book (p. 2)
• Conventions Used in This Book (p. 4)
• The Sample Code for This Book (p. 5)
• Contacting the Authors (p. 5)
• I Laying the Foundation
• 1 Why Access? Why VBA? (p. 9)
• Understanding the Place of Access in Office (p. 9)
• Understanding Access Programming Choices (p. 11)
• Case Study (p. 13)
• 2 Getting Around in the Visual Basic Editor (p. 17)
• Your First Glance at the Visual Basic Editor (p. 17)
• Introducing the VBA Modules (p. 21)
• Entering and Running VBA Code (p. 22)
• Getting Help on Code (p. 25)
• Establishing Good Habits in Coding (p. 28)
• 3 Using Variables, Constants, and Data Types (p. 33)
• Declaring Variables and Constants (p. 33)
• VBA Data Types (p. 39)
• Referencing Syntax (p. 42)
• 4 Using Procedures (p. 45)
• Understanding Procedure Types (p. 45)
• Declaring Procedures as Public or Private (p. 48)
• Passing Arguments (p. 49)
• Giving a Function a Data Type (p. 51)
• Implementing Error Handling (p. 52)
• Debugging Code (p. 54)
• 5 Choosing the Right VBA Function (p. 57)
• Introducing VBA's Built-in Functions (p. 57)
• Converting Data Types with VBA Functions (p. 58)
• Working with Date Functions (p. 65)
• Using Mathematical and Financial Functions (p. 70)
• Using String Functions (p. 75)
• Using the Format Function (p. 81)
• Using the Is Functions for Flawless Processing (p. 85)
• Interacting Functions (p. 85)
• Case Study (p. 88)
• 6 Using Flow-of-Control Statements (p. 91)
• Branching and Looping (p. 91)
• Using If...Then...Else (p. 91)
• Using Select Case (p. 94)
• Using For...Next (p. 95)
• Using Do Loops (p. 99)
• Using Go To (p. 101)
• Case Study (p. 102)
• 7 Working with Arrays (p. 105)
• Introducing Array Variables (p. 105)
• Declaring an Array Variable (p. 105)
• Understanding the Array's Index (p. 106)
• Working with Array Elements (p. 107)
• Arrays with Multiple Dimensions (p. 110)
• Expanding to Dynamic Arrays (p. 110)
• 8 Understanding Objects (p. 113)
• Introducing Objects (p. 113)
• Reading and Setting Properties (p. 116)
• Invoking Methods (p. 117)
• Working with Collections (p. 119)
• Working with an Object Model (p. 121)
• Creating Your Own Objects (p. 124)
• Working with Events (p. 126)
• Case Study (p. 128)
• 9 Understanding Scope and Lifetime (p. 131)
• What's Scope? (p. 131)
• Measuring the Lifetime of a Variable or Constant (p. 136)
• Using Static Variables (p. 139)
• II Working with the Access User Interface
• 10 Working with Forms (p. 145)
• Opening and Closing Forms (p. 145)
• The Form Module and Event Handling (p. 147)
• Performing Common Tasks (p. 148)
• Handling Errors at the Form Level (p. 154)
• Working with Multiple Form Instances (p. 157)
• Case Study (p. 158)
• 11 Analyzing the Access Event Model (p. 161)
• Responding to Events (p. 161)
• The Event Sequence for Controls (p. 162)
• The Event Sequence for Forms (p. 167)
• The Event Sequence for Reports (p. 170)
• Canceling Events (p. 171)
• Case Study (p. 172)
• 12 Working with List and Combo Boxes (p. 175)
• Populating a List Control (p. 175)
• Adding to the List-or Not (p. 181)
• Working with Multiselect Controls (p. 187)
• Considering Callback Functions (p. 189)
• Case Study (p. 191)
• 13 Working with Other Controls (p. 195)
• Working with Text Boxes (p. 195)
• Using Controls in Option Groups (p. 200)
• Working with Subforms (p. 202)
• Working with the Tag Property (p. 202)
• Case Study (p. 203)
• 14 Working with Reports (p. 209)
• Introducing the Report Module and Events (p. 209)
• Opening and Closing Reports (p. 210)
• Passing Arguments Using OpenArgs (p. 212)
• Populating the Report (p. 213)
• Handling Report-Level Errors (p. 215)
• Using VBA to Determine Group Properties (p. 218)
• Case Study (p. 220)
• 15 Working with the Application Collections (p. 223)
• Investigating the Application Collections (p. 223)
• Retrieving Lists of Objects (p. 225)
• Working with Object Properties (p. 226)
• Programmatically Determining Dependencies (p. 229)
• Case Study (p. 232)
• III Working with Access Data
• 16 Retrieving Data with ADO (p. 237)
• What's ADO and Why Do You Need It? (p. 237)
• Using the ADO Connection Object (p. 238)
• Working with Command Objects (p. 242)
• Understanding the Different Types of Recordsets (p. 244)
• Creating and Opening a Recordset (p. 245)
• Filtering Recordsets (p. 247)
• Using the Recordset Property (p. 248)
• Case Study (p. 250)
• 17 Manipulating Data with ADO (p. 253)
• Moving Through a Recordset (p. 253)
• Finding Data in a Recordset (p. 256)
• Adding Data Using a Recordset (p. 260)
• Deleting Data in a Recordset (p. 262)
• Updating Data in a Recordset (p. 263)
• Using Transactions to Commit Groups of Records-or Not (p. 266)
• Case Study (p. 268)
• 18 Creating Objects with ADOX (p. 273)
• What Is ADOX? (p. 273)
• Creating Tables (p. 274)
• Securing Objects (p. 279)
• Case Study (p. 284)
• 19 Performing Advanced Data Operations (p. 287)
• Coding for Concurrency (p. 287)
• Retrieving a User Recordset (p. 293)
• Using Other Schema Recordsets (p. 294)
• Case Study (p. 296)
• IV Using Advanced VBA Techniques in Access
• 20 Working with Data Files (p. 301)
• Understanding File I/O (p. 301)
• Opening Files (p. 302)
• Reading from Files (p. 304)
• Writing to Files (p. 307)
• Printing to Files (p. 309)
• Case Study (p. 310)
• 21 Automating Other Applications (p. 313)
• Understanding Automation (p. 313)
• Setting Object References (p. 314)
• Creating Objects in an Automation Server (p. 315)
• Talking to Excel from Access (p. 318)
• Talking to Word from Access (p. 320)
• Case Study (p. 322)
• 22 Working with XML Files (p. 325)
• An Introduction to XML (p. 325)
• Using ExportXML (p. 326)
• Using ImportXML (p. 330)
• Case Study (p. 334)
• 23 Using the Windows API (p. 337)
• Declaring API Calls (p. 337)
• Using API Calls (p. 338)
• API Calls That You Can Use From Access (p. 340)
• Knowing When to Use the Windows API (p. 343)
• V Appendix
• A Review of Access SQL (p. 347)
• An Introduction to SQL (p. 347)
• SQL Structure and Syntax (p. 348)
• Retrieving with SQL SELECT (p. 350)
• Modifying with SQL UPDATE (p. 354)
• Deleting with SQL DELETE (p. 355)
• Appending With SQL's INSERT INTO (p. 355)
• Making Tables With SQL SELECT INTO (p. 356)
• Creating a Crosstab Query with SQL TRANSFORM (p. 357)
• Index (p. 359)

Author notes provided by Syndetics