Automating Microsoft Access with VBA
Automating Microsoft Access with VBA
ISBN: 0789732440
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 186
Pages: 186
Authors: Mike Sales Gunderloy, Susan Sales Harkins
- 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
Automating Microsoft Access with VBA
ISBN: 0789732440
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 186
Pages: 186
Authors: Mike Sales Gunderloy, Susan Sales Harkins