Visual Basic For Microsoft Access

Table of contents

1. Introducing VBA For Access
   1. Can I Really Become A Programmer
   2. About The Author
   3. Using The Working Files
   4. Initial Setup Of The Sample Databases Provided
2. Moving From A Database To An Application
   1. What Is VBA
   2. Where Is The VBA
   3. The VBA Editor Quick Tour
   4. The Editor - Explorer And Properties Windows
   5. The Editor - The Debug Window
   6. Macros Or VBA - Convert Your Macro To Code
3. Programming In VBA
   1. Getting Started With A Standard Module
   2. Creating A Procedure
   3. Adding Comments To Your Code
   4. VBA Data Types
   5. Declaring Parameters For Use In Procedures
   6. How To Declare Variables And Constants
   7. Creating And Assigning Array Values
   8. The Scope And Lifetime Of Variables
   9. Standard Naming Conventions For Variables
   10. Handling Multiple Line Commands
   11. The Very Useful Keyword - ME
4. Repeating VBA Code
   1. Do Loop
   2. While Wend
   3. For Next
   4. If Else End If
   5. The Very Flexible Select Case Statement
5. Working With Access Objects
   1. The Access Object Model
   2. Changing The Value Of Object Properties
   3. Access Special Object DoCmd
   4. Class Modules And Class Procedures
   5. Enable And Disable Controls
   6. Hide Or Show Form Controls
   7. Lock Unlock Controls
   8. Form Events To Trigger Procedures
   9. Setting Color Properties
   10. Defining Your Own Custom Colours
   11. Defining Font Properties Through Your Code
   12. With End With To Shorten Code Writing
   13. Assigning Values To Data Fields On A Form
   14. Opening A Form
   15. Open Form And Display Filtered Dataset
   16. Closing Any Open Form
6. Data Manipulation
   1. A Very Quick SQL Tour
   2. Running An Action Query As Code
   3. Stop Warnings On Action Queries When Run In VBA
   4. Building And Storing SQL In Variables
   5. Changing The Sql That Populates A List Or Combo Box
   6. Create A New Table
   7. Deleting (And Closing) A Table
   8. Adding Data To Tables Through Code
   9. The Recordset Explained
   10. How To Reference Fields In A Recordset
   11. Navigating Through The Rows Of A Recordset
   12. Closing Off A Recordset And ADODB Connection
   13. The Recordset In Action
   14. DCOUNT (Great Function)
7. Interacting With The User
   1. Getting Started With The MSGBOX
   2. Customizing The MSGBOX
   3. Reacting To The User Response In A MSGBOX
   4. Creating A Dialog Box
   5. Using A Dialog To Give Choices To Users
   6. Combo Box Dynamic List Building
   7. Excluding Values From The Combo Box List
   8. Using The Combo Box Selected Value
   9. Detecting The Right Mouse Click
8. Combo And ListBox Specials
   1. Combo Box And ListBox Properties
   2. Accessing And Setting Combo And Field List Properties
   3. Accessing Combo Box Fields From A Different Form
   4. List Box Search Application
9. Functions
   1. What Is A Function
   2. Creating A Custom Function
   3. A Proper ProperCase Function
10. Testing, Error Handling And Debugging
    1. The Three Types Of Errors
    2. Handling Logical Errors With Debug Print
    3. Handling Logical Errors With Breakpoints
    4. Creating Your Own Runtime Error Handler
    5. Specific Error Messages For Specific Errors
11. And Finally
    1. Locking The VBA From Prying Eyes
    2. So What's Next