---

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