List of Figures

Chapter 1: Introduction to VBA for Applications

Figure 1-1: The Database window

Figure 1-2: The Table Wizard

Figure 1-3: Table in Design View

Figure 1-4: The Macro design window

Figure 1-5: The Action list for macros

Figure 1-6: The Visual Basic Editor

Chapter 2: Designing an Access Application

Figure 2-1: The Customer table in Design View

Figure 2-2: The Inventory table in Design View

Figure 2-3: The Purchases table in Design View

Figure 2-4: The Relationships window

Chapter 3: Access Development Without VBA

Figure 3-1: Block diagram of a three-tier system

Figure 3-2: Structure of the Customer table

Figure 3-3: Structure of the Inventory table

Figure 3-4: Structure of the Purchases table

Figure 3-5: Customer entry form

Figure 3-6: Events for the First button

Figure 3-7: The Choose Builder dialog box

Figure 3-8: The Macro Builder dialog box

Figure 3-9: The name field in the properties box

Figure 3-10: VBA Editor with the converted macros

Figure 3-11: The Microsoft template web page

Figure 3-12: Switchboard Manager dialog box

Figure 3-13: Edit Switchboard Page

Figure 3-14: Your Switchboard form in the Database window

Figure 3-15: The new Switchboard form

Figure 3-16: Switchboard form table

Figure 3-17: The Startup dialog box

Chapter 4: Customizing the Access Environment

Figure 4-1: A typical Access menu

Figure 4-2: You can customize your toolbars.

Figure 4-3: Adding a button to a toolbar

Figure 4-4: Customizing your options

Figure 4-5: Add or Remove Buttons

Figure 4-6: The Assign Hyperlink: Open dialog box

Figure 4-7: Command options for the Query shortcut

Figure 4-8: Creating menus and submenus

Figure 4-9: The All Macros category

Figure 4-10: Menu Control Properties dialog box

Chapter 5: Introducing the VBA Programming Environment

Figure 5-1: References dialog box

Figure 5-2: The VBA Editor

Figure 5-3: The Properties window

Figure 5-4: The Objects list box

Figure 5-5: The Procedures list box

Chapter 6: Programming Fundamentals Using VBA

Figure 6-1: The Modules category selected in the Database window

Figure 6-2: The VBA Editor with a module open

Figure 6-3: The Name property

Figure 6-4: Project window after renaming the module

Figure 6-5: Database window after renaming the module

Figure 6-6: The Require Variable Declaration option

Chapter 7: Understanding the Visual Basic Editor

Figure 7-1: The VBA Editor

Figure 7-2: The menu shortcut

Figure 7-3: Project Explorer window

Figure 7-4: Insert a module

Figure 7-5: Properties window in alphabetical order

Figure 7-6: Properties window in categorized order

Figure 7-7: The Object Browser

Figure 7-8: A property in the Object Browser

Figure 7-9: A library search

Figure 7-10: References dialog box

Figure 7-11: VBA Editor Options with the Editor tab selected

Figure 7-12: Results from Auto List Members

Figure 7-13: Auto Quick Info for the MsgBox function

Figure 7-14: Using Auto Data Tip

Figure 7-15: Editor Format tab

Figure 7-16: General tab

Figure 7-17: Docking tab

Figure 7-18: Table of Contents for Visual Basic Help

Figure 7-19: Help for the Object Browser

Figure 7-20: Help window for topic

Chapter 8: VBA Language Components

Figure 8-1: VBA constants

Figure 8-2: Access constants

Figure 8-3: frmCustomer in Design View

Figure 8-4: Event tab and Code Builder button

Figure 8-5: The VBA Editor with the form module open

Figure 8-6: Properties for ctlCustLastName

Figure 8-7: custForm with the focus set on the last name

Figure 8-8: References for Access Programming

Figure 8-9: The Query grid

Figure 8-10: The query in SQL View

Figure 8-11: Graphic query builder after typing the statement in SQL View

Chapter 9: Sub Procedures

Figure 9-1: The new table in the Database window

Figure 9-2: Structure of the new table

Chapter 10: Debugging VBA Code

Figure 10-1: The assigned value to intNumber1

Figure 10-2: The Assert method flagging the false value

Figure 10-3: The Locals window

Figure 10-4: Adding a Watch

Figure 10-5: The code flagged and the Watch window showing true

Chapter 11: Function Procedures

Figure 11-1: A compendium of date functions

Figure 11-2: The DatePart function

Figure 11-3: The DateDiff function output

Figure 11-4: Possible date formats

Chapter 12: Forms

Figure 12-1: A simple form built with AutoForm

Figure 12-2: Edit Relationships dialog box

Figure 12-3: Form/subform using AutoForm

Figure 12-4: Form properties

Figure 12-5: Query Builder grid

Figure 12-6: The form’s property box with SQL string

Figure 12-7: frmCustomer in Design View

Figure 12-8: The Properties window for a text box

Figure 12-9: The form’s Properties window

Figure 12-10: The Project window

Figure 12-11: Control prompt for Form_frmCustomer

Chapter 13: Reports

Figure 13-1: Report in Design View

Figure 13-2: Report with new header grouping added

Figure 13-3: Step one of the Report Wizard

Figure 13-4: Step two: grouping the data

Figure 13-5: Using the wizard to build a sort within the groupings

Figure 13-6: Finished report created in Report Wizard

Figure 13-7: Adjustments in Design View

Figure 13-8: Adjusted report

Figure 13-9: Chart Wizard

Figure 13-10: Fields selected for chart

Figure 13-11: Chart layout screen

Figure 13-12: Field selection screen

Figure 13-13: Object name screen

Figure 13-14: Report design with chart

Figure 13-15: Finished report

Figure 13-16: First step in Label Wizard

Figure 13-17: Label construction screen

Figure 13-18: Mailing label report

Figure 13-19: Report object Report1

Figure 13-20: Report1 in Design View

Figure 13-21: Report objects with MyReport added

Chapter 14: Menus and Toolbars

Figure 14-1: The command bar listing in the Immediate window

Figure 14-2: The customized toolbar in the collection

Chapter 15: Changing the Access Environment

Figure 15-1: The database startup properties dialog box

Figure 15-2: The Startup dialog box with fields clicked off

Figure 15-3: Options dialog box

Chapter 16: Database Security

Figure 16-1: The Startup dialog box

Figure 16-2: The Project Properties Protection dialog box

Figure 16-3: Workgroup Administrator

Figure 16-4: Workgroup Owner Information

Figure 16-5: Confirm Workgroup dialog box

Figure 16-6: User and Group Accounts

Figure 16-7: User and Group Permissions

Figure 16-8: Macro Security dialog box

Figure 16-9: Opening screen to create a digital certificate

Figure 16-10: Digital Signature attachment box

Figure 16-11: List of available certificates

Figure 16-12: The digital certificate

Figure 16-13: Security Warning box

Chapter 17: Access and the Microsoft Office Environment

Figure 17-1: The Microsoft Office Object Library reference

Figure 17-2: The References dialog box

Chapter 18: Access and the Web

Figure 18-1: The Pages window

Figure 18-2: First step in the Page Wizard

Figure 18-3: Step 2 of the Page Wizard

Figure 18-4: Step 3 of the Page Wizard

Figure 18-5: Final step of the Page Wizard

Figure 18-6: A Data Access Page

Figure 18-7: The Microsoft Script Editor

Figure 18-8: Save As Data Access Page

Figure 18-9: The Pages window with the new object

Figure 18-10: The Data Access Page Design window

Figure 18-11: The Data Access Page Design window with a field added

Figure 18-12: Relationship Wizard window

Figure 18-13: Properties for a Data Access Page

Chapter 19: Upgrading

Figure 19-1: Table Design window in SQL Server

Figure 19-2: The Database window in the ADP file

Figure 19-3: The Queries category

Figure 19-4: The stored procedure designer

Figure 19-5: Saving a stored procedure

Figure 19-6: The View Properties dialog box

Chapter 20: Multiuser Applications

Figure 20-1: Advanced tab of the Options dialog box

Figure 20-2: Save Backup As dialog box

Figure 20-3: First screen of the Database Splitter Wizard

Figure 20-4: The Database Splitter Wizard’s Create Back-end Database dialog box

Figure 20-5: The Tables window of a front-end database

Figure 20-6: Linked Table Manager dialog box

Figure 20-7: The Paste Table As dialog box

Chapter 21: Beyond Microsoft Access

Figure 21-1: The VBA Editor in Excel

Figure 21-2: The References dialog box in Excel

Figure 21-3: The Customer table in Excel

Figure 21-4: Excel’s Customize dialog box

Figure 21-5: The Visual Basic References dialog box

Figure 21-6: A Standard EXE project in Visual Basic

Figure 21-7: Controls tab of the Components dialog box

Figure 21-8: Toolbox with the ADO Data Control added

Figure 21-9: The first step toward building a connection string

Figure 21-10: Selecting a data provider

Figure 21-11: Selecting a database for the connection

Figure 21-12: The finished form in design mode

Figure 21-13: The finished application

Figure 21-14: Output from an Active Server Page built with VBScript