Beginning Access 2002 VBA (Programmer to Programmer)

ISBN: 0764544020
EAN: 2147483647

Year: 2003
Pages: 256

Authors: Robert Smith, Dave Sussman, Ian Blackburn, John Colby, Mark Horner, Martin Reid, Paul Turley, Helmut Watson

BUY ON AMAZON

Table of Contents
Back Cover
Beginning Access 2002 VBA
Introduction
The Structure of this Book
How is Access Changing?
Who is this Book For?
What Does this Book Cover?
What You Need for this Book
The Book s CD
Exercise Solutions
Conventions
Customer Support
Chapter 1: Designing Applications
What Is an Access Application?
The Development Process
The Ice Cream Shop Application
Macros Or VBA?
Summary
Exercise
Chapter 2: Introduction to Event-Driven Programming
The VBA IDE
Adding Intelligent Navigation Buttons to the Company Contacts Form
Adding to the User Interface
Summary
Exercises
Chapter 3: Creating Code
Procedures
Modules
Subroutines and Functions
Naming Conventions
Procedure Declaration
Built-In Functions
Variables
Constants
Intrinsic Constants
Variable Scope and Lifetime
Summary
Chapter 4: Controlling the Program
Programming Structures
Repetition
Arrays
Summary
Chapter 5: Using Access Objects
Object Oriented Programming
Object Models
Access 2002 Objects
The AccessObject Object
Forms and Reports
Referring to Objects
Special Objects
The Object Browser
Summary
Exercises
Chapter 6: Using DAO
The DAO Hierarchy
Working with Recordsets
Summary
Exercises
Chapter 7: Data Management Techniques
The Challenge - Flexibility vs. Manageability
The Requirement - Ad Hoc Query Functionality
Creating and Modifying DAO QueryDefs
Two Approaches to Displaying Results
Summary
Exercises
Chapter 8: Working with Tables
Working with Tables
Sub Datasheets
Summary
Exercises
Chapter 9: External Data
Other Applications
Text Files
XML
Electronic Mail
Using External Data
Summary
Exercises
Chapter 10: Reports
Starting Off
Page Numbers
IIf
Dates
Summarizing
Expressions
Events
Filters
Summary
Exercises
Chapter 11: Advanced Programming Techniques
Arrays
Arguments
Dynamic Link Libraries (DLLs)
Custom DAO Properties
Summary
Exercises
Chapter 12: Finding and Dealing with Errors
Planning for Errors
Compiling
Testing
Types of Errors
Debugging
Error Handling
Debugging your Debugging Code
Summary
Exercises
Chapter 13: Using Classes
Class Modules and Custom Objects
Forms as Class Modules
Collections - Creating a Hierarchy
Getting the Most from Class Modules
Summary
Exercises
Chapter 14: WithEvents and RaiseEvent
Event Review, Some Terms and Facts
What is WithEvents?
Why Use WithEvents?
RaiseEvent
Summary
Exercises
Chapter 15: Libraries and Add-Ins
Library Databases
Class Libraries
Add-Ins
Summary
Exercises
Chapter 16: Automation
What Is Automation?
Object References
Creating Automation Objects
Microsoft Outlook
Microsoft Word
Microsoft Excel
Summary
Chapter 17: Multi-User
Multi-Developer Issues
Record Locking in Access 2002
Security
Compiling
Summary
Exercises
Chapter 18: The Internet
The Internet
Data Access Pages and Access XP
XML
Uploading Data
Summary
Exercises
Chapter 19: Optimizing Your Application
Efficiency
Reducing Memory Overhead
Increasing Execution Speed
Increasing Apparent Speed
Network Considerations
Finishing Touches
Summary
Exercises
Chapter 20: Moving to Client-Server
What is Client-Server?
Jet vs. SQL Server: Why Move?
Access Data Projects
Creating an Access Data Project
Installing SQL Server Desktop Engine
Running the Upsizing Wizard
Results of Upsizing the IceCream Database
SQL Server Objects
Fixing the Queries
Forms
When you have No GUI
Summary
Chapter 21: ActiveX Data Objects - ADO
What is ADO?
Summary
Exercises
Appendix A: Access Object Model
Method Calls
Appendix B: Access Events
Appendix C: ADO 2.7 Object Model
Command Object
Connection Object
Error Object
Errors Collection
Field Object
Fields Collection
Parameter Object
Parameters Collection
Properties
Property Object
Recordset Object
Constants
Method Calls Quick Reference
Appendix D: Microsoft DAO 3.6 Object Library Reference
Connection
Connections
Container
Containers
Database
Databases
DBEngine
Document
Documents
Error
Errors
Field
Fields
Group
Groups
Index
Indexes
Parameter
Parameters
Properties
Property
QueryDef
QueryDefs
Recordset
Recordsets
Relation
Relations
TableDef
TableDefs
User
Users
Workspace
Workspaces
Constants
Method Calls
Appendix E: ODBC and IIS
Web Servers
index__Numbers
index__Symbols
index_A
index_B
index_C
index_D
index_E
index_F
index_G
index_H
index_I
index_J-K
index_L
index_M
index_N
index_O
index_P
index_Q
index_R
index_S
index_T
index_U
index_V
index_W
index_X-Z