Access 2000 - Visual Basic® for Applications Fundamentals

Length: 2 days

Table of Contents

Acknowledgments

Introduction

Part 1 Automating Database Tasks

Chapter 1 Get Started Quickly with Wizards

• Using Wizards for Application Development
• Creating a Database Using the Database Wizard
• What Else Did the Wizard Create?
• Entering Information into the Database
• Using Existing Data with a New Database

Adding an Object to Your Application

• Adding a Command Button to a Form
• Creating Other Command Buttons

Chapter Summary

• Preview of the Next Chapter

Chapter 2 Customize an Application with Visual Basic

• Customizing a Command Button
• Viewing the Visual Basic Code Behind Your Application
• Modifying a Command Button Created Using the Wizard
• Making a Form Read-Only by Default
• Creating a Command Button Without a Wizard
• Creating Event Procedures for Form Events
• Displaying a Message to the User
• Chapter Summary
• Preview of the Next Chapter

Chapter 3 Find and Filter Records in a Form

• Creating a Combo Box to Find Records
• Filtering Data
• Responding to Filtering Events
• Using the If...Then Statement to Check a Condition
• Understanding Filtering Properties
• Using the Immediate Window to View and Set Properties
• Creating an Option Group to Filter Data

Chapter Summary

• Preview of the Next Chapter

Chapter 4 Respond to Data Entry Events

• Understanding Form and Control Events
• Performing Actions as the User Moves in a Form
• Performing Actions as the User Changes Data
• Setting the Value of a Control "Auto-magically"
• Responding to Keyboard Events
• Validating Data
• Validating Data Using an Event Procedure
• Asking the User a Question

Chapter Summary

• Preview of the Next Chapter

Part 2 Programming in Visual Basic

Chapter 5 Write Your Own Functions

• Understanding Modules and Procedures
• Why Create General Procedures?
• Standard Modules and Form Modules
• Creating General Procedures in a Standard Module
• Using the Declarations Section
• Declaring Constant Values
• Creating a Sub Procedure
• Adding Arguments to a Procedure
• Creating a Function

Using General Procedures on a Form

• Creating General Functions in a Form Module
• So Many Options, So Few Rules
• Chapter Summary
• Preview of the Next Chapter

Chapter 6 Monitor and Debug Your Code

• Stepping Through Code Line by Line
• Setting a Breakpoint to Stop Running Code
• Stepping from One Procedure to Another
• Monitoring Variables and Other Values
• Finding and Fixing Bugs in Your Code
• Telling Visual Basic to Check Your Code

Chapter Summary 136

• Preview of the Next Chapter

Chapter 7 Respond to Errors and Unexpected Conditions

• Replacing Standard Error Messages
• Responding to the Error Event
• Displaying Your Own Message for a Specific Error
• Responding to a Combo Box Error
• Creating Error-Handling Routines
• Handling Errors That Occur When Your Application Is Read-Only
• Anticipating Other Problems That Cause Errors
• Chapter Summary
• Preview of the Next Chapter

Part 3 Creating a Custom Application

Chapter 8 Gather Information in a Dialog Box

• Creating an Application from Scratch
• Using Dialog Boxes in Your Applications
• Creating a Dialog Box to Go to a Specific Record
• Filtering Data in a Report
• Chapter Summary
• Preview of the Next Chapter

Chapter 9 Navigate Through Your Application

• Making Forms Work Together
• Displaying Related Records in a Pop—Up Form
• Opening a Form to Add Related Records
• Chapter Summary
• Preview of the Next Chapter

Chapter 10 Display Custom Menus and Toolbars

• Using Menus and Toolbars in Your User Interface
• Creating a Custom Menu Bar
• Customizing Toolbars
• Creating a Custom Toolbar for the Subscribers Form
• Creating Toolbar Buttons to Run Visual Basic Code
• Chapter Summary
• Preview of the Next Chapter

Chapter 11 Put Final Touches on an Application

• Controlling How Your Application Starts
• Providing a Startup Form for Your Application
• Completing the Switchboard Form for the Subscription Database
• Customizing Your Application's Appearance
• Replacing the Access Splash Screen
• Preparing to Distribute Your Application to Users
• Chapter Summary
• Preview of the Next Chapter

Part 4 Working with Data and Objects

Chapter 12 Explore Objects and Collections

• Introducing the Issues Application
• Understanding Objects and Collections
• Referring to Objects and Collections
• Using the For Each Statement with a Collection
• Using a Multiple-Selection List Box
• Working Directly with Database Objects
• Finding and Changing Data in a Recordset
• Creating and Running an Action Query
• Chapter Summary
• Preview of the Next Chapter

Chapter 13 Customize Reports with Visual Basic

• Using Standard Reporting Features
• Responding to Report Events
• Customizing Reports by Setting Properties at Run Time
• Changing Report Layout Programmatically
• Calculating Totals While a Report Is Printing
• Chapter Summary
• Preview of the Next Chapter

Chapter 14 Share Data with Other Applications

• Using Automation Objects
• Sending Commands to Microsoft Word
• Getting Information from Another Application
• Working with Folders in Microsoft Outlook
• Chapter Summary
• Preview of the Next Chapter

Chapter 15 Connect to the Web

• Using Hyperlinks
• Creating Hyperlink Controls on a Form
• Storing Hyperlinks in a Table
• Following Hyperlinks from Visual Basic
• Modifying Hyperlinks Using Visual Basic
• Creating Web Pages for Your Application
• Creating a Data Access Page to Review Data
• Adding Scripts to Data Access Pages
• Chapter Summary
• Where Do I Go Next?

Index