---

Automating Microsoft Access with VBA

ISBN: 0789732440
EAN: 2147483647

Year: 2003
Pages: 186

Authors: Mike Sales Gunderloy, Susan Sales Harkins

BUY ON AMAZON

• 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
• The Event Sequence for Forms
• The Event Sequence for Reports
• Canceling Events
• Chapter 12. Working with List and Combo Boxes
• Populating a List Control
• Adding to the List-or Not
• Working with Multiselect Controls
• Considering Callback Functions
• Chapter 13. Working with Other Controls
• Working with Text Boxes
• Using Controls in Option Groups
• Working with Subforms
• Working with the Tag Property
• Chapter 14. Working with Reports
• Introducing the Report Module and Events
• Opening and Closing Reports
• Passing Arguments Using OpenArgs
• Populating the Report
• Handling Report-Level Errors
• Using VBA to Determine Group Properties
• Chapter 15. Working with the Application Collections
• Investigating the Application Collections
• Retrieving Lists of Objects
• Working with Object Properties
• Programmatically Determining Dependencies
• Part III: Working with Access Data
• Chapter 16. Retrieving Data with ADO
• What s ADO and Why Do You Need It?
• Using the ADO Connection Object
• Working with Command Objects
• Understanding the Different Types of Recordsets
• Creating and Opening a Recordset
• Filtering Recordsets
• Using the Recordset Property
• Chapter 17. Manipulating Data with ADO
• Moving Through a Recordset
• Finding Data in a Recordset
• Adding Data Using a Recordset
• Deleting Data in a Recordset
• Updating Data in a Recordset
• Using Transactions to Commit Groups of Records-or Not
• Chapter 18. Creating Objects with ADOX
• What Is ADOX?
• Creating Tables
• Securing Objects
• Chapter 19. Performing Advanced Data Operations
• Coding for Concurrency
• Retrieving a User Recordset
• Using Other Schema Recordsets
• Part IV: Using Advanced VBA Techniques in Access
• Chapter 20. Working with Data Files
• Understanding File IO
• Opening Files
• Reading from Files
• Writing to Files
• Printing to Files
• Chapter 21. Automating Other Applications
• Understanding Automation
• Setting Object References
• Creating Objects in an Automation Server
• Talking to Excel from Access
• Talking to Word from Access
• Chapter 22. Working with XML Files
• An Introduction to XML
• Using ExportXML
• Using ImportXML
• Chapter 23. Using the Windows API
• Declaring API Calls
• Using API Calls
• API Calls That You Can Use From Access
• Knowing When to Use the Windows API
• Part V: Appendix
• Appendix A. Review of Access SQL
• An Introduction to SQL
• SQL Structure and Syntax
• Retrieving with SQL SELECT
• Modifying with SQL UPDATE
• Deleting with SQL DELETE
• Appending With SQL INSERT INTO
• Making Tables With SQL SELECT INTO
• Creating a Crosstab Query with SQL TRANSFORM
• Index
• index_SYMBOL
• index_A
• index_B
• index_C
• index_D
• index_E
• index_F
• index_G
• index_H
• index_I
• index_K
• index_L
• index_M
• index_N
• index_O
• index_P
• index_Q
• index_R
• index_S
• index_T
• index_U
• index_V
• index_W