Beginning Access 2003 VBA / Denise Gosnell.

Format:

Book

Author/Creator:

Gosnell, Denise.

Series:

Programmer to programmer.

Language:

English

Subjects (All):

Microsoft Access.

Microsoft Visual Basic for applications.

Database management.

Physical Description:

1 online resource (544 p.)

Other Title:

Access 2003 VBA

Place of Publication:

Indianapolis, Ind. : Wiley Technology Pub., 2004.

Language Note:

English

Summary:

What is this book about? Written by an Access programmer with more than 10 years of VBA experience, this is the perfect guide for Access users who are ready to take their databases to the next level, or for programmers who are new to Access or VBA. Veteran Access developer Denise Gosnell shows readers the ins and outs of Access VBA and provides plenty of source code, and fully developed sample applications to guide you along the way. Not only do readers learn to build "stand-alone" desktop applications, but readers also learn how to integrate Access applications with Web Services,

Contents:

Introduction; Chapter 1: Introduction to Access 2003 VBA; What Is Access 2003 VBA?; What's New in Access 2003 VBA?; Access 2003 VBA Programming 101; Requirements Gathering Phase; Design Phase; Development Phase; Testing Phase; Implementation Phase; Summary; Exercises; Chapter 2: The Basics of Writing and Testing VBA Code; Creating Modules; Standard Modules versus Class Modules; Creating and Calling Procedures; Sub versus Function Procedure; Upgrading Macros to Procedures; Using Variables and Constants to Store Values; Types of Variables; Declaring and Using Variables; Constants

Scope and Lifetime of Variables and ConstantsNaming Conventions; Controlling Program Flow; Decision Making; Loops; Documenting Your Code; Error Debugging; Types of Errors; Debugging Your Code; Error Handling; Default Error Messages; Handling Errors with an On Error Statement; The Err Object; Using the Errors Collection; Creating a Generic Error Handler; Summary; Exercises; Chapter 3: Programming Applications Using Objects; Elements of an Object; What Is a Property?; What Is a Method?; What Is an Event?; Viewing Objects Using the Object Browser; Ways to Refer to Objects

Using Access Collections and ObjectsThe Forms Collection and Form Object; The Reports Collection and Report Object; The CurrentProject Object; The DoCmd Object; The Screen Object; The Printers Collection and Printer Object; Other Objects; Summary; Exercises; Chapter 4: Creating Your Own Objects; Using Class Modules to Create Your Own Objects; Class Diagrams; Creating Properties; Creating Methods; Creating Events; Using the Class; Advanced Techniques; Create Custom Properties for Existing Objects; Using Existing Tag Property; Using Public Variables

Using Property Let, Property Get, and Property Set RoutinesCreate Custom Methods for Existing Objects; Using Public Sub Procedures and Functions; Summary; Exercises; Chapter 5: Interacting with Data Using ADO and SQL; Introduction to Data Access; Using ADODB to Work with Data; The ADO Object Model; The Connection Object; The Command Object; The Recordset Object; Introduction to SQL; Retrieving Data Using SQL Select Statements; Inserting Data Using SQL Insert Statements; Updating Data Using SQL Statements; Deleting Data Using SQL Statements; Using ADOX to Manipulate Data Objects

Creating a Table with ADOXManaging Security with ADOX; Summary; Exercises; Chapter 6: Building Interactive Forms; Form Navigation and Flow; Working with Controls; Combo Boxes versus List Boxes; Tab Controls and Subforms; Building User Interaction; The MsgBox Function; Validating User Input; Adding Polish to Your Forms; Summary; Exercises; Chapter 7: Importing, Linking, and Exporting Using External Data Sources; Linking, Importing, and Exporting Overview; Access and Other Databases; Transferring Complete SQL Server Database; Spreadsheets; Text Files; XML Files; E-mails and Outlook

Other Ways to Export Data

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

ISBN:

1-280-27345-3

9786610273454

0-7645-7902-9

OCLC:

271801423