Access 2007 VBA programming for dummies /
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | Book |
| Language: | English |
| Published: |
Hoboken, NJ :
Wiley,
©2007.
|
| Series: | --For dummies
|
| Subjects: | |
| Online Access: | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=185562 |
Table of Contents:
- Cover
- TOC36;Table of Contents
- Introduction
- Part I Introducing VBA Programming
- CH36;Chapter 1 Where VBA Fits In
- Taking a Look at Access
- Understanding VBA
- Seeing Where VBA Lurks
- Finding Out How VBA Works
- CH36;Chapter 2 Your VBA Toolkit
- Using the Visual Basic Editor
- Referring to Objects from VBA
- Setting References to Object Libraries
- Using the Object Browser
- Searching the Object Library
- CH36;Chapter 3 Jumpstart58; Creating a Simple VBA Program
- Creating a Standard Module
- Creating a Procedure
- Understanding Syntax
- Using Existing Code
- Part II VBA Tools and Techniques
- CH36;Chapter 4 Understanding Your VBA Building Blocks
- Commenting Your Code
- Understanding VBA Data Types
- Passing Data to Procedures
- Repeating Chunks of Code with Loops
- Making Decisions in VBA Code
- CH36;Chapter 5 Controlling Access through VBA
- Understanding Object Models
- Manipulating Properties and Methods
- CH36;Chapter 6 Programming Access Forms
- Working with Class Procedures
- Enabling or Disabling Form Controls
- Responding to Form Events
- Changing the Appearance of Objects
- Opening and Closing Forms
- Part III VBA44; Recordsets44; and SQL
- CH36;Chapter 7 The Scoop on SQL and Recordsets
- What the Heck Is SQL63;
- Creating Tables from VBA
- Adding Records to a Table
- Changing and Deleting Table Records
- Performing an Action Query on One Record
- Working with Select Queries and Recordsets
- CH36;Chapter 8 Putting Recordsets to Work
- Looping through Collections
- Tips on Reading and Modifying Code
- Skipping Over Used Mailing Labels
- Looking at How Skip Labels Works
- Calling a Procedure from an Event
- Part IV Applying VBA in the Real World
- CH36;Chapter 9 Creating Your Own Dialog Boxes
- Displaying and Responding to Messages
- Converting Forms to Dialog Boxes
- Creating Custom Combo Boxes
- Creating a Spin Box Control
- Detecting a Right45;Click
- CH36;Chapter 10 Customizing Combo Boxes and List Boxes
- Programming Combo and List Boxes
- Linking Lists
- Linking Lists across Forms
- More Combo Box Tricks
- CH36;Chapter 11 Creating Your Own Functions
- The Role of Functions in VBA
- Creating Your Own Functions
- A Proper Case Function
- A Function to Print Check Amounts
- CH36;Chapter 12 Testing and Debugging Your Code
- Understanding Compilation and Runtime
- Considering Types of Program Errors
- Conquering Compile Errors
- Dealing with Logical Errors
- Wrestling Runtime Errors
- Part V Reaching Out with VBA
- CH36;Chapter 13 Using VBA with Multiple Databases
- Client45;Server Microsoft Access
- Importing from External Databases
- Linking to External Data through Code
- Avoiding Multiple Tables and Links
- Creating Recordsets from External Tables
- Importing44; Exporting44; or Linking to Anything
- CH36;Chapter 14 Integrating with Other Office Applications
- Accessing the Object Library
- Sending E45;Mail via Outlook
- Sending Data to Microsoft Word
- Interacting with Microsoft Excel
- Part VI The Part of Tens
- CH36;Chapter 15 Ten Commandments of Writing VBA
- I46; Thou Shalt Not Harbor Strange Beliefs about Microsoft Access
- II46; Thou Shalt Not Use VBA Statements in Vain
- III46; Remember to Keep Holy the VBA Syntax
- IV.