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