Sign in  |  Register
Advanced search
Publication Cover

CITATION

Shepherd, Richard. Microsoft Access 2010 VBA Macro Programming. US: McGraw-Hill Osborne Media, 2010.

Microsoft Access 2010 VBA Macro Programming

Authors: Richard Shepherd

Published:  October 2010

eISBN: 9780071738583 0071738584 | ISBN: 9780071738576
Open eBook
  • Contents
  • Acknowledgments
  • Introduction
  • Part I: Programming in Access VBA
  • Chapter 1 The Basics
  • Macros and VBA Modules in Access
  • Exploring the Visual Basic Editor in Access
  • Saving Your Code
  • Chapter 2 Variables, Arrays, Constants, and Data Types
  • Variables
  • Data Types
  • VBA Data Types
  • Arrays
  • User-Defined Types
  • Constants
  • Reserved Words
  • Chapter 3 Modules, Functions, and Subroutines
  • Modules
  • The Difference Between Subroutines and Functions
  • Writing a Simple Subroutine
  • Writing a Simple Function
  • Public and Private Functions and Subroutines
  • Argument Data Types
  • Optional Arguments
  • Passing Arguments by Value
  • Chapter 4 Programming Basics: Decisions and Looping
  • Decisions
  • Looping
  • Chapter 5 Strings, Functions, and Message Boxes
  • Strings
  • Functions
  • Conversion Functions
  • Format Function
  • Date and Time Functions
  • The SendKeys Command
  • Message Boxes
  • Chapter 6 Operators
  • Arithmetic Operators
  • Comparison Operators
  • Concatenation Operator
  • Logical Operators
  • Other Operators
  • Chapter 7 Debugging
  • Types of Errors
  • Design Time, Runtime, and Break Mode
  • Breakpoints
  • Using Stop Statements
  • Running Selected Parts of Your Code
  • The Debug Window
  • Events That Can Cause Problems When Debugging
  • Using Message Boxes in Debugging
  • Avoiding Bugs
  • Chapter 8 Errors and the Error Function
  • The Resume Statement
  • Implications of Error Trapping
  • Generating Your Own Errors
  • Chapter 9 Forms and Reports
  • Forms
  • Reports
  • Chapter 10 Common Dialog Control
  • The Open File Dialog
  • The Print Dialog
  • Chapter 11 Working with the Ribbon
  • Creating a Ribbon Customization
  • Using the Custom UI Editor
  • Creating Code for Your Custom Buttons
  • Images
  • How Can You Use VBA Code with the Ribbon
  • More on the Ribbon
  • Chapter 12 SQL Queries
  • Using the Query Design Window
  • Select Query
  • Union Query
  • The Delete Query
  • Make Table Query
  • Append Query
  • Update Query
  • Pass-Through Query
  • Using Custom Functions within Queries
  • Chapter 13 Table Macros
  • Creating a Table Macro
  • Part II: Object Models
  • Chapter 14 The Access Object Models
  • Properties and Methods Explained
  • Using the Object Browser
  • Hierarchy
  • Chapter 15 The Main Objects
  • Application Object
  • Me Object
  • CurrentDb Object
  • Recordset Object
  • Chapter 16 The DoCmd Object
  • DoCmd Methods
  • Chapter 17 Using Access to Interact with Other Office Programs
  • Driving Microsoft Outlook
  • Driving Access from Other Office Programs
  • Part III: Advanced Techniques in Access VBA
  • Chapter 18 Charts and Graphs
  • Working with the Series Collection Object
  • Exporting a Chart as a Picture File
  • Chapter 19 Working with External Databases
  • Linking to Other Access Databases
  • ODBC Links and DSNs
  • Using a DSN
  • Problems Using Linked Tables
  • Using Pass-Through Queries
  • Using ADO
  • Chapter 20 API Calls
  • What Is an API Call?
  • Using an API Call
  • Chapter 21 Class Modules
  • Creating a Data Services Layer
  • Inserting a Class Module
  • Creating an Object
  • Creating a Collection
  • Using the PNames Collection
  • Using the PNames Collection as a Multi-tier Application
  • Chapter 22 Animation
  • Part IV: Access VBA in Action
  • Chapter 23 Getting the Login ID
  • A Simple Use of the User Name
  • Chapter 24 Securing Your Database
  • Using an ACCDE File to Protect Your Application
  • Using VBA to Lock Your Application Down
  • Chapter 25 Creating Audit Trails on Tables
  • Who Is the User?
  • The Audit Trail on the Table Structure
  • Chapter 26 Creating and Editing Queries in VBA
  • Creating a New Query
  • Deleting an Existing Query
  • Updating a SQL Query
  • Chapter 27 Search and Replace in Queries
  • Searching for a Specific String Within All Queries
  • Search and Replace in a Query
  • Chapter 28 Using the DateAdd Function
  • Using DateAdd to Pause Your Code
  • Chapter 29 Monitoring Table Statistics
  • Chapter 30 Handling Large Text Files
  • Chapter 31 Create and Change Table Structures
  • Creating a Table
  • Deleting a Table or a Field
  • Editing Field Properties
  • Creating Indexes
  • Chapter 32 Create an Objects Inventory
  • Chapter 33 Manipulate Chart Colors
  • Chapter 34 Drill Down on Charts
  • Chapter 35 Use Excel For Output
  • Using a Recordset to Create a Spreadsheet
  • Using an Existing Spreadsheet as a Template
  • Transferring Individual Numbers to Excel
  • Allowing Users to Design Their Excel Reports
  • Chapter 36 Use FTP in VBA
  • Using VBA Code to Transfer Files
  • Use of Semaphore Files
  • Chapter 37 What Happens When the 2-GB Limit Is Reached
  • Chapter 38 Creating Menu Structures with the Ribbon
  • Chapter 39 Make Controls on Forms Interactive
  • Creating a Simple Table
  • Creating a Form for the Table
  • Chapter 40 Set Up Levels of User Security
  • Appendix: ASCII Character Codes
  • Index