Microsoft Access 2021 Programming Pocket Primer

https://aalamsalon.com/1eov5pictnx Cover Title Copyright Contents Acknowledgments Introduction Chapter 1 Getting Started with Access VBA Understanding VBA Modules and Procedure Types Writing Procedures in a Standard Module Executing Your Procedure Understanding Class Modules Events, Event Properties, and Event Procedures Why Use Events? Walking Through an Event Procedure Compiling Your Procedures Placing a Database in a Trusted Location Summary Chapter 2 Getting to Know Visual Basic Editor (VBE) Understanding the Project Explorer Window Understanding the Properties Window Understanding the Code Window Other Windows in the VBE Assigning a Name to the VBA Project Renaming the Module Syntax and Programming Assistance List Properties/Methods Parameter Info List Constants Quick Info Complete Word Indent/Outdent Comment Block/Uncomment Block Using the Object Browser Using the VBA Object Library Using the Immediate Window Summary Chapter 3 Access VBA Fundamentals Introduction to Data Types Understanding and Using Variables Declaring Variables Specifying the Data Type of a Variable Using Type Declaration Characters Assigning Values to Variables Forcing Declaration of Variables Understanding the Scope of Variables Procedure-Level (Local) Variables Module-Level Variables Project-Level Variables Understanding the Lifetime of Variables Using Temporary Variables Creating a Temporary Variable with a TempVars Collection Object Retrieving Names and Values of TempVar Objects Using Temporary Global Variables in Expressions Removing a Temporary Variable from a TempVars Collection Object Using Static Variables Using Object Variables Disposing of Object Variable Finding a Variable Definition Determining the Data Type of a Variable Using Constants in VBA Procedures Intrinsic Constants Summary Chapter 4 Access VBA Built-In and Custom Functions Writing Function Procedures Running Function Procedures Data Types and Functions Passing Arguments to By Reference and By Value Using Optional Arguments Using the IsMissing Function Using VBA Built-In Functions for User Interaction Using the MsgBox Function Returning Values from the MsgBox Function Using the InputBox Function Converting Data Types Summary Chapter 5 Adding Decisions to Your Access VBA Programs Relational and Logical Operators If…Then Statement Multiline If…Then Statement Decisions Based on More Than One Condition If…Then…Else Statement If…Then…ElseIf Statement Nested If…Then Statements Select Case Statement Using Is with the Case Clause Specifying a Range of Values in a Case Clause pecifying Multiple Expressions in a Case Clause Summary Chapter 6 Adding Repeating Actions to Your Access VBA Programs Using the Do…While Statement Another Approach to the Do…While Statement Using the Do…Until Statement Another Approach to the Do…Until Statement Using the For…Next Statement Using the For Each…Next Statement Exiting Loops Early Nested Loops Summary Chapter 7 Keeping Track of Multiple Values Using Arrays Understanding Arrays Declaring Arrays Array Upper and Lower Bounds Initializing and Filling an Array Filling an Array Using Individual Assignment Statements Filling an Array Using the Array Function Filling an Array Using the For…Next Loop Using a One-Dimensional Array Arrays and Looping Statements Using a Two-Dimensional Array Static and Dynamic Arrays Array Functions The Array Function The IsArray Function The Erase Function The LBound and UBound Functions Errors in Arrays Parameter Arrays Passing Arrays to Function Procedures Sorting an Array Summary Chapter 8 Keeping Track of Multiple Values Using Object Collections Creating Your Own Collection Adding Items to Your Collection Determine the Number of Items in Your Collection Accessing Items in a Collection Removing Items from a Collection Updating Items in a Collection Returning a Collection from a Function Collection vs. Arrays Watching the Execution of Your VBA Procedures Summary Chapter 9 Getting to Know Built-In Tools for Testing and Debugging Syntax, Runtime, and Logic Erros Stopping a Procedure Using Breakpoints Removing Breakpoints Using the Immediate Window in Break Mode Using the Stop Statement Using the Assert Statement Using the Add Watch Window Removing Watch Expressions Using Quick Watch Using the Locals Window Using the Call Stack Dialog Box Stepping Through VBA Procedures Stepping Over a Procedure Stepping Out of a Procedure Running a Procedure to Cursor Setting the Next Statement Showing the Next Statement Navigating with Bookmarks Stopping and Resetting VBA Procedures Trapping Errors Using the Err Object Procedure Testing Setting Error-Trapping Options Summary Index