book

Microsoft® Access® 2010 Programmer's Reference

Name: Microsoft® Access® 2010 Programmer's Reference
ISBN: 9780470591666

by Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

August 2010

Intermediate to advanced

1272 pages

32h 43m

English

Wrox

Read now

Unlock full access

Copyright
CREDITS
ABOUT THE AUTHORS
ABOUT THE CONTRIBUTING AUTHORS AND TECHNICAL EDITORS
ABOUT THE TECHNICAL EDITORS
ACKNOWLEDGMENTS
INTRODUCTION
WHY USE VBA?WHAT DOES THIS BOOK COVER?The ChaptersThe AppendixesHOW TO USE THIS BOOKOTHER ACCESS/VBA SOURCESCONVENTIONSSOURCE CODEERRATAP2P.WROX.COM
1. Introduction to Microsoft Access 2010
1.1. A BRIEF HISTORY OF ACCESS1.2. WHEN TO USE ACCESS1.2.1. Microsoft Office Access 20101.2.2. SQL Server 2008 Express Edition1.2.3. SQL Server 20081.2.4. How Do You Choose?1.3. ACCESS DATABASE BASICS1.3.1. Getting Started in Access 20101.3.2. Access 2010 Database Templates1.3.3. The Access Navigation Pane1.3.4. The Access Ribbon1.3.5. The Access Security Bar1.4. ACCESS DATABASE OBJECTS1.4.1. Creating Tables1.4.1.1. Access 2010 Field Types1.4.2. Creating Queries1.4.3. Creating Forms1.4.4. Creating Reports1.4.5. Creating Macros1.4.6. Creating Modules1.5. SUMMARY
2. New Features
2.1. NEW LOOK2.2. DEVELOPMENT ENVIRONMENT2.2.1. 64-Bit2.2.2. Office Backstage2.2.3. Claculated Columns2.2.4. Integration with Office Themes2.2.5. New Macro Designer2.2.6. Expression Builder2.2.7. Web Service Expressions2.2.8. Application Parts2.3. FORMS2.3.1. Web Browser Control2.3.2. New Navigation Control2.3.3. Subreports in Forms2.4. MACROS2.4.1. UI Macros2.4.2. Data Macros2.5. INTEGRATION WITH SHAREPOINT2.5.1. Working with Data on SharePoint2.5.2. Publish the Database to SharePoint2.5.3. Additional SharePoint Features2.6. BROWSER INTERFACE/APPLICATIONS2.6.1. Introducing the Web Form Designer2.6.2. Introducing Web Report Designer2.6.3. Feature Restrictions (Features Disabled in Web Applications)2.7. WHAT'S GONE OR DEPRECATED2.7.1. Calendar Control2.7.2. ISAMs2.7.3. Replication Conflict Resolver2.7.4. Snapshot Format2.8. SUMMARY
3. Upgrading and Converting to Access 2010
3.1. TO CONVERT OR TO ENABLE3.1.1. Common Terminology3.1.2. Key Decision Factors3.1.3. Feature Sets and File Extensions: What's New, What's Replaced, What Happens3.1.3.1. File Extensions3.1.3.2. New Features Available Only with ACCDB File Format3.1.3.3. Access 2010 Is Based on 2007 File Format3.1.3.4. Features Not Available with ACCDB Files3.1.3.5. What Happens When a 2007/2010 MDB Is Opened by Prior Versions3.1.3.6. What Happens When a 2010 ACCDB Is Opened by 20073.1.4. Other Things to Consider3.1.4.1. VBA References3.1.4.2. Shared Data Files3.1.4.3. Splitting a Database3.1.4.4. Working with SQL Server3.1.4.5. Compiling the Code3.2. INSTALLING MULTIPLE VERSIONS OF ACCESS ON ONE PC3.3. CHANGING FILE FORMATS3.3.1. Selecting the Default File Format3.3.2. Overriding the Default File Format3.3.3. ACCDE and MDE Files3.3.4. Steps for Converting or Enabling3.3.5. File Conversion Using Access 2010: A One-Stop Shop3.3.6. Other Considerations When Converting3.3.7. Converting to Access 97 or Earlier Is a Two-Version Process3.4. CONVERTING A SECURED DATABASE3.4.1. Converting a Password-Protected Database3.4.2. Converting a Database with Password-Protected VBA3.5. CONVERTING A REPLICATED DATABASE3.6. ENABLING A DATABASE3.6.1. Enabling the Experience: Opening 95 or 97 Files with Access 20103.7. ACCESS 2010: 64-BIT CONSIDERATIONS3.7.1. Porting an Access Application to a 64-bit Plat-form3.7.1.1. Working in Mixed Bitness3.8. SUMMARY

4. Macros in Access 2010
4.1. VBA VERSUS MACROS IN ACCESS4.1.1. Benefits of Using VBA4.1.2. Benefits of Using Macros4.2. TYPES OF MACROS4.2.1. Macro Objects4.2.2. Embedded Macros4.2.3. Data Macros4.3. CREATING MACROS IN ACCESS 20104.3.1. New Macro Designer4.3.1.1. Adding Actions4.3.1.2. Macro Constructs4.3.1.3. If...Else...Else If4.3.1.4. Submacros4.3.1.5. Groups4.3.1.6. Comments4.3.1.7. Parameters4.3.2. Additional Macro Changes4.3.3. Sharing Macros Using Access 20104.3.4. Running Macros4.3.5. Debugging Macros4.4. MACRO OBJECTS AND EMBEDDED MACROS4.4.1. Error Handling4.4.2. Variables4.4.2.1. TempVars4.4.2.2. LocalVars4.4.2.3. Scope of TempVars and LocalVars4.4.2.4. ReturnVars4.4.3. Macro Actions and Arguments4.4.3.1. BrowseTo4.4.3.2. SetFilter4.4.3.3. SetOrderBy4.4.4. Macro Scenarios4.4.4.1. Testing for Disabled Mode4.4.4.2. Opening Objects4.4.4.3. Opening a Report Based on a Parameter Query4.4.4.4. Working with Controls4.4.4.5. Working with Records4.4.4.6. Return to the Previous Record Following a Requery4.4.4.7. Running Macro Actions in Access or Access Services4.5. DATA MACROS4.5.1. Types of Data Macros4.5.1.1. Before Events4.5.1.2. After Events4.5.1.3. Named Data Macros4.5.2. Running Data Macros4.5.3. Data Macro Blocks4.5.3.1. CreateRecord4.5.3.2. EditRecord4.5.3.3. ForEachRecord4.5.3.4. LookupRecord4.5.3.5. Aliasing4.5.4. Data Macro Properties4.5.4.1. Updated Function4.5.4.2. Old Property4.5.4.3. IsInsert Property4.5.5. Data Macro Actions and Arguments4.5.6. Error Handling4.5.7. Variables4.5.8. Data Macro Scenarios4.5.8.1. Aggregating Data4.5.8.2. Canceling a Before Event4.5.8.3. Single Checkbox Value for Records4.5.8.4. Custom Sort Order for Displaying Records4.5.8.4.1. MoveCategory Named Data Macro4.5.8.4.2. SwapSortOrder Named Data Macro4.5.8.4.3. Embedded Macros4.5.8.4.4. mcrEnableMoveButtons Named Macro4.5.8.4.5. Returning Values from a Data Macro4.5.8.4.6. Sending E-mail4.5.8.5. Tracking Change History4.6. SUMMARY
5. Using the VBA Editor
5.1. ANATOMY OF THE VBA EDITOR5.2. USING THE OBJECT BROWSER5.2.1. Object Browser Components5.2.2. Show Hidden Members5.3. TESTING AND DEBUGGING VBA CODE5.3.1. Immediate Window5.3.2. The Debug.Print Statement5.3.3. The Debug.Assert Statement5.3.4. Breakpoints5.3.5. Stepping through Code5.3.6. Call Stack5.3.7. Run to Cursor5.3.8. Locals Window5.3.9. Watch Window5.3.10. Edit and Continue5.4. USING OPTION STATEMENTS5.5. SUMMARY
6. VBA Basics
6.1. THE MINDSET OF A PROGRAMMER6.2. ANATOMY OF VBA PROCEDURES6.3. VBA KEYWORDS6.4. VBA OPERATORS6.5. VARIABLES AND VBA SYNTAX6.5.1. Variables6.5.1.1.6.5.1.1.1. Variable Data Types6.5.2. Naming Your Variables6.5.3. Variable Scope and Lifetime6.5.4. Overlapping Variables6.6. OTHER VBA COMPONENTS6.6.1. Option Statements6.6.2. Comments6.6.3. Line Continuation6.6.4. Constants6.6.5. Enums6.7. VBA OBJECTS6.7.1. Properties6.7.2. Methods6.7.3. Events6.8. USING CODE BEHIND FORMS AND REPORTS6.9. USING VBA CODE TO CALL MACROS6.10. WRITING CODE IN MODULES6.11. EXAMPLE: USER-DEFINED FUNCTION6.12. SUMMARY
7. Using VBA in Access
7.1. WHEN EVENTS FIRE7.1.1. Common Form Events7.1.2. Common Control Events7.1.3. Common Report Events7.1.4. Asynchronous Execution7.1.4.1. OpenForm7.1.4.2. Dialog Mode to the Rescue7.2. VBA PROCEDURES7.2.1. Function or Sub?7.2.2. Public or Private?7.2.2.1. Public and Private Procedures in Modules7.2.2.2. Public and Private Procedures in Forms and Reports7.2.3. Coupling and Cohesion7.2.3.1. Uncouple Procedures7.2.3.2. Adhere to Cohesion7.2.4. Error Handling7.2.5. Using Variables7.2.5.1. Using Appropriate Data Types and Sizes7.2.5.2. Using Global Variables7.3. EVALUATING EXPRESSIONS IN VBA7.3.1. If ... Then7.3.2. Checking for Nulls7.3.3. Select Case7.4. USING RECORDSETS7.4.1. Opening Recordsets7.4.2. Looping through Recordsets7.4.3. Adding Records7.4.4. Finding Records7.4.5. Updating Records7.5. USING MULTIPLE RECORDSETS7.5.1. Copying Trees of Parent and Child Records7.5.2. Using Bookmark and RecordsetClone7.5.3. Cleaning Up7.6. USING VBA IN FORMS AND REPORTS7.6.1. All about Me7.6.2. Referring to Controls7.6.3. Referring to Subforms and Subreports7.6.4. Closing Forms7.7. DEBUGGING VBA7.8. INVESTIGATING VARIABLES7.8.1. When Hovering Isn't Enough — Using the Immediate Window7.8.2. Setting Breakpoints7.8.3. Setting Watch Values7.8.4. Stopping Runaway Code7.8.5. Stepping through Your Code7.9. COMMON VBA TECHNIQUES7.9.1. Drilling Down with Double-Click7.9.2. Date Handling7.9.2.1. How Access Stores Dates and Times7.9.2.2. Simple Date Math7.9.3. Handling Rounding Issues7.9.3.1. Rounding of Sums7.9.3.2. Rounding Errors Caused by Floating Point Numbers7.9.3.3. Access Rounding Functions7.10. STRING CONCATENATION TECHNIQUES7.10.1. The Difference between & and +7.10.2. String Concatenation Example7.11. VBA ERROR HANDLING7.11.1. Why Use Error Handling?7.11.2. Two Kinds of Errors: Unexpected and Expected7.11.2.1. Handling Unexpected Errors7.11.2.2. Absorbing Expected Errors7.11.3. Basic Error Handling7.11.3.1. Basic Error Handling with an Extra Resume7.11.3.2. Basic Error Handling with a Centralized Message7.11.4. Cleaning Up after an Error7.11.5. More on Absorbing Expected Errors7.11.6. Issues in Error Handling7.11.6.1. Don't Use Error Handling with Logging7.11.6.2. Don't Use Error Handling That Sends E-Mail7.12. SUMMARY
8. Creating Classes in VBA
8.1. WHY USE CLASSES?8.2. A TOUCH OF CLASS8.3. CREATING A CLASS MODULE8.3.1. Adding a Class Module to the Project8.3.2. A Brief Word on Naming the Class8.3.3. Instantiating Class Objects8.3.4. Creating Class Methods8.3.5. Creating Property Procedures8.3.5.1. Using Property Get8.3.5.2. Using Property Let8.3.5.3. Using Property Set8.3.5.4. Declaring Property Read-Write Attributes8.3.5.5. Using Enumerated Types with Properties and Methods8.3.5.6. Creating Flags8.3.5.7. Exiting Property Procedures8.3.5.8. Procedure Attributes8.3.5.9. Friendly Procedures8.4. NAMING AND IDENTIFYING OBJECTS8.4.1. What Does the Object Do?8.4.2. Naming Techniques8.4.2.1. Case8.4.2.2. Plurality8.4.3. Identifying a Class Instance8.5. USING CLASS EVENTS8.5.1. Initialize and Terminate Events8.5.2. Creating Custom Class Events8.5.3. Responding to Events8.5.4. Handling Errors in Classes8.5.4.1. Trapping VBA Errors8.5.4.2. Raising Custom-Defined Errors8.5.4.3. Passing Errors in Class Modules8.6. FORMS AND REPORTS AS OBJECTS8.7. VARIABLE SCOPE AND LIFETIME8.8. THE ME PROPERTY8.8.1. Subclassing the Form8.8.2. Creating the Subclassed Form8.8.3. Creating a Parent Property8.9. CREATING A CLONE METHOD8.10. CREATING AND USING COLLECTION CLASSES8.10.1. The Collection Object8.10.1.1. The Add Method8.10.1.2. The Remove Method8.10.1.3. The Item Method8.10.1.4. The Count Property8.10.2. Collection Class Basics8.10.2.1. clsStudent8.10.2.2. clsStudents8.10.2.3. Setting Unique Object Keys8.10.2.4. Testing the clsStudents Class8.10.2.5. Specifying the Default Procedure8.10.2.6. Enumerating Collection Classes8.11. THE THREE PILLARS8.11.1. Encapsulation8.11.2. Inheritance8.11.3. Polymorphism8.11.4. Inheriting Interfaces8.11.5. Instancing8.12. SUMMARY
9. Extending VBA with APIs
9.1. INTRODUCING THE WINDOWS API9.1.1. Finding API Functions9.1.2. Why You Need the API9.2. INTRODUCING LINKING9.2.1. Static Linking9.2.2. Dynamic Linking9.3. DECLARING APIS9.3.1. The Declare Keyword9.3.2. The PtrSafe Keyword9.3.3. Naming the Procedure9.3.4. Specifying the Lib(rary) and Argument List9.3.4.1. Passing Values9.3.4.2. Returning Values9.4. UNDERSTANDING C PARAMETERS9.4.1. Signed and Unsigned Integers9.4.2. Numeric Parameters9.4.2.1. 8-Bit Numeric Parameters9.4.2.2. 16-Bit Numeric Parameters9.4.2.3. 32-Bit Numeric Parameters9.4.2.4. 64-Bit Numeric Parameters9.4.2.5. Currency Parameters9.4.2.6. Floating-Point Parameters9.4.2.7. Boolean Parameters9.4.2.8. Handle Parameters9.4.3. Object Parameters9.4.4. String Parameters9.4.5. Variant Parameters9.4.6. Pointers to Numeric Values9.4.7. Pointers to C Structures9.4.8. Pointers to Arrays9.4.9. Pointers to Functions9.4.10. Pointers in 64-Bit Windows9.4.10.1. Defining Type Statements9.4.10.2. Portability of Code between Platforms9.4.10.2.1. Conditional Compilation9.4.10.2.2. Built-in Conditional Compilation Constants9.4.10.2.3. Compilation of API Functions9.4.11. The Any Data Type9.5. ERR.LASTDLLERROR9.6. DISTRIBUTING APPLICATIONS THAT REFERENCE TYPE LIBRARIES AND CUSTOM DLLS9.7. USEFUL API FUNCTIONS9.7.1. Returning the Path to the Windows Folder9.7.2. Determining Whether the System Processor Is 32-Bit or 64-Bit9.7.3. Determining Whether Windows Is 32-Bit or 64-Bit9.7.4. Determining Whether Office Is 32-Bit or 64-Bit9.7.5. Displaying the Windows Open Dialog Box9.7.6. Finding the Position of a Form9.7.7. Finding the Temp Directory9.7.8. Generating a Unique Temp Filename9.7.9. Finding the Login Name of the Current User9.7.10. Finding the Computer Name9.7.11. Opening or Printing Any File9.7.12. Delaying Code Execution9.7.13. Getting the Path to a Special Folder9.7.14. Locking the Computer9.8. SUMMARY
10. Working with the Windows Registry
10.1. ABOUT THE REGISTRY10.1.1. What the Registry Does10.1.2. What the Registry Controls10.1.3. Accessing the Registry10.1.3.1. RegEdit.exe10.1.3.2. Regedt32.exe10.1.3.3. Launching and Using the Registry Editor10.1.4. Registry Organization10.1.4.1. HKEY_CLASSES_ROOT10.1.4.2. HKEY_CURRENT_USER10.1.4.3. HKEY_LOCAL_MACHINE10.1.4.4. HKEY_USERS10.1.4.4.1. .DEFAULT10.1.4.4.2. Security Identifier Keys10.1.4.5. HKEY_CURRENT_CONFIG10.1.5. Registry Organization on 64-Bit Windows10.1.5.1. Registry Redirection10.1.5.2. Registry Reflection10.2. USING THE BUILT-IN VBA REGISTRY FUNCTIONS10.2.1. SaveSetting10.2.2. GetSetting10.2.3. GetAllSettings10.2.4. DeleteSetting10.2.5. Typical Uses for the Built-In VBA Registry Functions10.2.5.1. Implementing a Daily Reminders Screen10.2.5.2. Storing and Retrieving Connection Strings10.2.5.3. Storing User Preferences10.2.5.4. Storing a Last Used List10.3. USING THE WINDOWS REGISTRY APIs10.3.1. Getting Started10.3.1.1. Windows Registry Hive Constants10.3.1.2. Windows Registry Data Types10.3.1.3. Other Windows Registry Constants10.3.1.4. Windows Registry API Function Declarations10.3.2. Creating a Registry Key10.3.3. Setting the Value for a Key10.3.4. Getting the Value for a Key10.3.5. Deleting a Registry Value10.3.6. Deleting a Registry Key10.3.7. Testing the Function Wrappers10.3.8. Opening an Existing Registry Key10.3.9. Connecting to the Registry on a Remote Computer10.3.10. Enumerating Registry Keys and Values10.4. SUMMARY
11. Using DAO to Access Data
11.1. DATA ACCESS OBJECTS11.2. WHY USE DAO?11.3. NEW FEATURES IN DAO11.3.1. Multi-Value Lookup Fields11.3.2. Attachment Fields11.3.3. Append-Only Fields11.3.4. Database Encryption11.3.5. Calculated Fields11.4. REFERRING TO DAO OBJECTS11.5. THE DBENGINE OBJECT11.5.1. The Workspaces Collection11.5.2. ODBCDirect11.5.2.1. Creating a Workspace11.5.2.2. Using Transactions11.5.3. The Errors Collection11.6. THE DATABASE OBJECT11.6.1. The Default (Access) Database11.6.2. The CurrentDb Function11.6.3. Opening an External Database11.7. DAO OBJECT PROPERTIES11.7.1. DAO Property Types11.7.2. Creating, Setting, and Retrieving Properties11.7.2.1. Setting and Retrieving Built-In Object Properties11.7.2.2. Creating Object Properties11.7.2.3. Setting and Retrieving SummaryInfo Properties11.7.2.4. Setting and Retrieving User-Defined Properties11.8. CREATING SCHEMA OBJECTS WITH DAO11.8.1. Creating Tables and Fields11.8.2. Creating Indexes11.8.3. Creating Relations11.8.3.1. Putting It All Together11.8.4. Creating Multi-Value Lookup Fields11.8.5. Creating Calculated Fields11.9. DATA ACCESS WITH DAO11.9.1. Working with QueryDefs11.9.1.1. Creating a QueryDef11.9.1.2. Parameters11.9.1.3. Executing Queries11.9.1.3.1. DoCmd.RunSQL11.9.1.3.2. object.Execute11.9.1.3.3. OpenRecordset11.9.2. Working with Recordsets11.9.2.1. Creating a Recordset11.9.2.2. Opening a Recordset Based on a Table or Query11.9.2.3. Opening a Recordset Based on a Parameter Query11.9.2.4. Opening a Recordset Based on a SQL Statement11.9.2.5. Opening a Recordset That Locks Out All Other Users11.9.3. Filtering and Ordering Recordsets11.9.3.1. Filtering Records11.9.3.2. Ordering Records11.9.3.2.1. Ordering Using the ORDER BY Clause11.9.3.2.2. Ordering Using the Index Property11.9.3.2.3. Ordering Using the Sort Property11.9.4. Navigating Recordsets11.9.4.1. Navigational Methods11.9.4.2. AbsolutePosition, PercentPosition11.9.4.3. RecordCount11.9.4.4. BOF, EOF11.9.4.5. Testing for an Empty Recordset11.9.4.6. Navigating Recordsets with Multi-Value Lookup Fields11.9.5. Bookmarks and Recordset Clones11.9.5.1. Using Bookmarks11.9.5.2. Now What about Those Clones?11.9.6. Finding Records11.9.6.1. The Seek Method11.9.6.2. The Find Methods11.9.7. Working with Recordsets11.9.7.1. Retrieving Field Values11.9.7.2. Adding, Editing, and Deleting Rows11.9.7.2.1. Adding Rows11.9.7.2.2. Editing Rows11.9.7.2.3. Deleting Rows11.9.7.2.4. Canceling an Edit11.9.7.3. Using Arrays with Recordsets11.9.8. Working with Attachment Fields11.9.8.1. Navigating Attachments11.9.8.2. Adding, Saving, and Deleting Attachments11.9.8.2.1. Adding Attachments11.9.8.2.2. Saving Attachments11.9.8.2.3. Deleting Attachments11.10. APPEND-ONLY FIELDS11.11. SUMMARY
12. Using ADO to Access Data
12.1. INTRODUCTION TO ADO IN ACCESS12.2. ADDING ADO REFERENCES12.2.1. Referring to ADO Objects12.3. CONNECTING TO ADO DATA SOURCES12.3.1. Creating an Implicit Connection12.3.2. Creating an ADO Connection Object12.3.3. Creating a Connection String12.3.4. Creating a Data Link Connection12.3.5. Closing a Connection12.3.6. Working with Cursors12.3.6.1. Server-Side Cursors12.3.6.2. Client-Side Cursors12.3.7. Using Transactions12.3.7.1. Transaction Support in ADO12.3.7.2. Creating a Transaction12.3.7.3. Nesting Transactions12.4. DATA ACCESS WITH ADO12.4.1. Overview of the ADO Object Model12.4.2. Using the Execute Method12.4.2.1. The Connection.Execute Method12.4.2.2. The Command.Execute Method12.4.2.3. Specifying Command Parameters12.4.2.4. Creating Parameters Dynamically12.4.3. Creating Recordsets12.4.3.1. Creating a Recordset from a SQL Statement12.4.3.2. Creating a Recordset from a Table or View12.4.3.3. Creating a Shaped Recordset12.4.3.4. Creating a Recordset Containing Multiple Recordsets12.4.3.5. Verifying Recordset Options12.4.4. Navigating Recordsets12.4.4.1. The Move Methods12.4.4.2. The Seek Method12.4.4.3. The Find Method12.4.4.4. The AbsolutePosition Property12.4.5. Working with Data in Recordsets12.4.5.1. Referring to Fields12.4.5.2. Retrieving Data12.4.5.3. Modifying Data12.4.5.4. Creating Batch Updates12.4.5.5. Adding New Data12.4.5.6. Deleting Data12.4.5.7. Closing Recordsets12.4.5.8. Saving Recordset Data to a File12.4.5.9. Loading Recordset Data from a File12.4.5.10. Disconnected Recordsets12.5. USING ADO EVENTS12.5.1. Declaring WithEvents12.5.2. Implementing ADO Event Methods12.5.3. Implicitly Triggering Events12.5.4. Explicitly Calling Events12.5.5. Testing the State Property12.6. SCHEMA RECORDSETS WITH ADO12.6.1. ADO Schema Recordsets12.6.2. Specifying Constraint Columns12.6.3. Using ACE Specific Schemas12.7. CREATING SCHEMA WITH ADOX12.7.1. Adding References to ADOX12.7.2. The ADOX Object Model12.7.3. Working with Tables12.7.3.1. Creating a Table12.7.3.2. Deleting a Table12.7.4. Working with Views (Queries)12.7.4.1. Creating a Query12.7.4.2. Modifying a Query12.7.4.3. Deleting a Query12.7.5. Managing Security with ADOX12.8. SUMMARY
13. Using SQL with VBA
13.1. WORKING WITH SQL STRINGS IN VBA13.1.1. Building SQL Strings with Quotes13.1.2. Using Single Quotation Marks instead of Double Quotation Marks13.1.3. Concatenating Long SQL Strings13.2. USING SQL WHEN OPENING FORMS AND REPORTS13.3. USING SQL TO ENHANCE FORMS13.3.1. Sorting on Columns13.3.2. Selections on Index Forms13.3.2.1. Easy Selection Criteria on an Index Form13.3.2.2. The Amazing Expandable SelectRecords Procedure13.3.2.3. Selection Criteria Using Numeric Keys13.3.2.4. Selection Criteria in Child Records13.3.2.5. Disabling Buttons if No Records Are Displayed13.3.3. Cascading Combo Boxes13.3.4. Using SQL for Report Selection Criteria13.3.5. Altering the SQL inside Queries13.4. THE REPLACEORDERBYCLAUSE AND REPLACEWHERECLAUSE FUNCTIONS13.5. SUMMARY
14. Using VBA to Enhance Forms
14.1. VBA BASICS14.1.1. Properties14.1.2. Event Properties: Where Does the Code Go?14.1.3. Naming Conventions14.2. CREATING FORMS THE 2010 WAY14.2.1. Columnar and Tabular Layouts14.2.2. Anchoring14.2.3. The Modal Dialog Box Mode14.2.4. Control Wizards - Creating Command Buttons Using VBA or Macros14.2.5. Command Button Properties14.2.6. Attachment Controls14.2.7. Combo Boxes14.2.7.1. Combo Box as a Lookup14.2.7.2. Auto Expand14.2.7.3. Allow Value List Edits14.2.7.4. List Items Edit Form14.2.7.5. Not In List()14.2.7.6. Field List14.2.7.7. Synchronizing Two Combo Boxes Using AfterUpdate()14.2.8. Using the BeforeUpdate Event14.2.9. Saving E-mail Addresses Using the Textbox AfterUpdate Event14.2.10. Outputting to PDF14.2.11. OpenArgs14.2.12. IsLoaded()14.2.13. On Timer ()14.2.14. Late Binding14.2.15. On Click(): Open a Form Based on a Value on the Current Form14.2.16. Multiple Form Instances14.2.17. Displaying Data in TreeView and ListView Controls14.2.17.1. Filling the TreeView Control14.2.17.2. Filling the ListView Control14.2.17.3. Web Forms14.3. SUMMARY
15. Enhancing Reports with VBA
15.1. INTRODUCTION TO REPORTS15.1.1. How Reports Are Structured15.1.2. New in Access 200715.1.3. New in Access 201015.1.3.1. Enhancements to Layout View15.1.3.2. Web Reports15.1.3.3. SubReports in Forms15.1.3.4. Detecting Whether a SubReport Is Opened in a Form or Report15.1.3.5. Improved Conditional Formatting15.2. CREATING A REPORT15.3. WORKING WITH VBA IN REPORTS15.3.1. Control Naming Issues15.3.2. The Me Object15.4. IMPORTANT REPORT EVENTS AND PROPERTIES15.4.1. Opening a Report15.4.1.1. Open Event15.4.1.2. NoData Event15.4.1.3. Load Event15.4.1.4. Current Event15.4.2. Section Events15.4.2.1. Format Event15.4.2.2. Retreat Event15.4.2.3. Paint Event15.4.2.4. Print Event15.4.2.5. Page Event15.4.3. Closing a Report15.4.3.1. Unload Event15.4.3.2. Close Event15.5. REPORT PROPERTIES15.5.1. Section Properties15.5.1.1. WillContinue15.5.1.2. HasContinued15.5.1.3. ForceNewPage15.5.1.4. KeepTogether15.5.1.5. RepeatSection15.5.2. Control Properties15.6. WORKING WITH CHARTS15.7. COMMON REPORT REQUESTS15.7.1. Changing the RecordSource at Runtime15.7.2. Gathering Information from a Form15.7.3. Changing the Printer15.7.4. Dictionary-Style Headings15.7.5. Shading Alternate Rows15.7.6. Conditional Formatting of a Control15.7.7. Creating a Progress Meter Report15.8. LAYOUT VIEW15.9. REPORT VIEW15.9.1. Considerations When Designing for Report View15.9.1.1. Where Are All My Pages?15.9.1.2. Events15.9.1.3. Controls15.9.2. Interactivity15.9.2.1. Hyperlinks15.9.2.2. Drill-Down/Click-Through15.9.2.3. Multiple Report Instances15.9.2.4. Query by Report15.10. SUMMARY
16. Customizing the Ribbon
16.1. RIBBON OVERVIEW16.2. CUSTOM MENU BARS AND TOOLBARS16.2.1. Custom Menu Bars16.2.2. Shortcut Menu Bars16.3. RIBBON CUSTOMIZATION USING THE OPTIONS DIALOG BOX16.4. RIBBON CUSTOMIZATION16.5. SAVING A CUSTOM RIBBON16.6. SPECIFYING THE CUSTOM RIBBON16.6.1. Defining a Ribbon Using XML16.6.1.1. Using the Ribbon Schema16.6.1.2. Writing the XML16.6.1.3. Adding Tabs and Groups16.6.1.4. Contextual Tabs16.6.1.5. Adding Controls16.6.1.5.1. Menus and Menu Separators16.6.1.5.2. Buttons, Toggle Buttons, and Split Buttons16.6.1.5.3. Check Boxes16.6.1.5.4. Combo Boxes and Drop-Downs16.6.1.5.5. Edit Boxes and Labels16.6.1.5.6. Separator16.6.1.5.7. DialogBoxLauncher16.6.1.5.8. Grouping Controls16.6.1.5.9. AutoScaling16.6.2. Writing Callback Routines and Macros16.6.2.1. Using Expressions16.6.2.2. Using Access Macros16.6.2.3. Using VBA16.6.3. More Callback Routines16.6.3.1. Checking a Checkbox16.6.3.2. Determining Whether to Preselect a Checkbox16.6.3.3. Filling a Combo Box or Drop-Down16.6.3.4. Selecting an Item in a Combo Box or Drop-Down16.6.3.5. Disabling a Control16.6.4. Displaying Images16.6.4.1. imageMso Attribute16.6.4.2. loadImage Callback16.6.4.3. getImage Callbacks16.6.5. Refreshing Ribbon Content16.6.5.1. onLoad Callback16.6.5.2. Dynamically Setting Text for a Button Control16.7. CREATING AN INTEGRATED RIBBON16.7.1. Building the Report Manager16.7.1.1. Creating the Reports Table16.7.1.2. Using dynamicMenu16.7.1.3. Writing the Callbacks16.7.2. Building the Custom Filter Interface16.7.2.1. Creating the Report16.7.2.2. Building the Contextual Tab16.7.2.3. Writing the Callbacks16.8. CREATING A RIBBON FROM SCRATCH16.8.1. Defining the Tabs and Groups16.8.2. Building the Home Tab16.8.2.1. Building the Flight Group16.8.2.2. Building the Cruise Group16.8.2.2.1. Writing the XML16.8.2.2.2. Writing the Callbacks16.8.2.3. Building the Hotel Group16.8.2.4. Building the Rental Cars Group16.8.3. Building the Settings Tab16.8.4. Building the Administration Tab16.9. MORE RIBBON TIPS16.9.1. Setting Focus to a Tab16.9.2. Additional Resources16.10. SUMMARY
17. Customizing the Office Backstage
17.1. INTRODUCING THE OFFICE BACKSTAGE17.1.1. Access 2010 Backstage17.1.2. Parts of the Backstage17.1.3. Uses for the Backstage in Custom Applications17.2. WRITING A BACKSTAGE CUSTOMIZATION17.3. CONTROLS IN THE BACKSTAGE17.3.1. Tab17.3.2. Group17.3.2.1. primaryItem17.3.2.2. topItems17.3.2.3. bottomItems17.3.3. TaskGroup, Category, and Task17.3.4. TaskFormGroup17.3.5. Button17.3.5.1. style Attribute17.3.5.2. isDefinitive Attribute17.3.6. GroupBox17.3.7. Hyperlink17.3.8. ImageControl17.3.9. LayoutContainer17.3.10. RadioGroup17.4. DESIGNING THE LAYOUT OF COMPONENTS17.4.1. Single-Column Layout17.4.2. Two-Column Layout17.4.3. Column Widths17.4.4. Creating a Grid17.4.4.1. Column and Row Span17.4.4.2. Creating a Table-Type Grid17.5. EXTENDING THE EXISTING BACKSTAGE17.5.1. Adding a Group to an Existing Tab17.5.2. Adding a Category to an Existing TabForm-Group17.5.3. Adding a Task to an Existing TaskGroup17.6. BACKSTAGE-SPECIFIC CALLBACKS17.6.1. onShow17.6.2. onHide17.6.3. getStyle17.6.4. getHelperText17.6.5. getTitle17.6.6. getTarget17.7. BACKSTAGE SCENARIOS17.7.1. Access Runtime Experience17.7.2. Setting the Title of a Tab to the Application Title17.7.3. About Page and Contact Form17.7.4. Warning for a Missing Reference17.7.5. Custom Database Information17.7.6. Creating a Bulleted or Numbered List17.7.7. Welcome Page with Image17.7.8. Other Possible Examples17.7.8.1. Administration17.7.8.2. Link Browser17.7.8.3. Reminders17.7.8.4. Report Manager17.8. SUMMARY
18. Working with Office 2010
18.1. WORKING WITH OUTLOOK 201018.1.1. Setting References to Outlook18.1.2. Creating Outlook Application Objects18.1.2.1. Using the New Keyword18.1.2.2. Using the CreateObject Method18.1.2.3. New versus CreateObject18.1.2.4. New Is Not Always New with Outlook18.1.2.5. Using the GetObject Method18.1.3. Working with MailItem objects18.1.3.1. Creating an E-mail18.1.3.2. Sending an E-mail18.1.3.3. Adding an E-mail to a Folder18.1.3.4. Other MailItem Settings18.1.4. Outlook Security Features18.1.4.1. Configuring Outlook Security with Exchange Server18.1.4.2. Using Redemption to Send E-mail18.1.5. Other Outlook Objects18.1.5.1. Creating Tasks18.1.5.2. Modifying Tasks18.1.5.3. Deleting Tasks18.1.5.4. Creating Calendar Items18.1.5.5. Creating, Modifying, and Deleting Outlook Items18.1.6. More Information about Outlook18.2. WORKING WITH EXCEL 201018.2.1. Setting References to Excel18.2.2. Creating Excel Application Objects18.2.2.1. Using the New Keyword18.2.2.2. Using the CreateObject Method18.2.2.3. Using CreateObject without References to Excel18.2.2.4. Using the GetObject Method18.2.2.5. Showing the Excel Application Window18.2.3. Working with Excel Workbooks18.2.3.1. Creating a New Workbook18.2.3.2. Opening an Existing Workbook18.2.3.3. Saving a Workbook using SaveAs18.2.3.4. Saving a Workbook using Save18.2.3.5. Closing a Workbook18.2.4. Working with Sheets in Excel18.2.4.1. Activating an Existing Sheet18.2.4.2. Creating a New Sheet18.2.4.3. Deleting a Sheet18.2.5. Working with Data in Excel18.2.5.1. Getting Data in a Cell18.2.5.2. Modifying Data in a Cell18.2.5.3. Modifying Settings for a Cell18.2.5.4. Using CopyFromRecordset18.2.5.5. Using TransferSpreadsheet18.2.6. More Information about Excel18.3. WORKING WITH WORD 201018.3.1. Setting References to Word18.3.2. Creating Word Application Objects18.3.2.1. Using the New Keyword18.3.2.2. Using the CreateObject Method18.3.2.3. Using CreateObject without References to Word18.3.2.4. Using the GetObject Method18.3.2.5. Showing the Word Application Window18.3.3. Working with Document Objects18.3.3.1. Creating a New Document18.3.3.2. Opening an Existing Document18.3.3.3. Saving a Document using SaveAs18.3.3.4. Saving a Document using Save18.3.3.5. Closing a Document18.3.4. Working with Data in Word18.3.4.1. Adding Text to a Document18.3.4.2. Adding Data to the Ends of a Document18.3.4.3. Formatting Text in a Word Document18.3.4.4. Automating Mail Merges18.3.4.5. Using OutputTo18.3.5. More Information about Word18.4. SUMMARY
19. Working with SharePoint
19.1. SHAREPOINT 201019.1.1. What Is SharePoint?19.1.2. SharePoint 2010 Requirements19.1.3. SharePoint 2010 Versions19.1.4. Access Services on SharePoint Server19.2. ACCESS FEATURES OVERVIEW19.2.1. SharePoint Features in Access 201019.2.2. Access Features in SharePoint 201019.3. SHAREPOINT FEATURES IN ACCESS19.3.1. Access Web Applications19.3.1.1. Traditional Apps versus Web Apps19.3.1.1.1. Access Web Application Design Basics19.3.1.1.2. Hybrid Web Application Design Basics19.3.1.2. Getting Started with Web Apps19.3.1.2.1. Creating a New Web Application Database19.3.1.2.2. Creating a Web Application from Template19.3.1.3. Creating Web Tables19.3.1.3.1. Creating a New Web Table19.3.1.3.2. The Web Table Designer19.3.1.3.3. Adding Fields to a Web Table19.3.1.3.4. Removing Fields from a Web Table19.3.1.3.5. Data Macros19.3.1.3.6. Working with Relationships19.3.1.3.7. Linking to Other Data Sources19.3.1.4. Creating Web Queries19.3.1.4.1. Creating a New Web Query19.3.1.4.2. The Web Query Designer19.3.1.4.3. Access Query Database Objects19.3.1.5. Creating Web Forms19.3.1.5.1. Creating a New Web Form19.3.1.5.2. The Web Form Designer19.3.1.5.3. Access Form Database Objects19.3.1.6. Creating Web Reports19.3.1.6.1. Creating a New Web Report19.3.1.6.2. The Web Report Designer19.3.1.6.3. Access Report Database Objects19.3.1.7. Creating Web Macros19.3.1.7.1. Creating a New Web Macro19.3.1.7.2. Access Macros and VBA Modules19.3.1.8. Publishing to Access Services19.3.1.8.1. Publishing an Application Using Access 201019.3.1.8.2. The Web Compatibility Wizard19.3.1.9. Working with the Web Application19.3.1.9.1. Running from the Browser19.3.1.9.2. Rehydrating a Web Application19.3.1.9.3. Modifying a Web Application19.3.1.10. Access Web Application Summary19.3.2. Linked Tables to SharePoint19.3.2.1. SharePoint Linked Tables in an ACCDB19.3.2.2. SharePoint Linked Tables in an MDB19.3.2.3. Creating Linked Tables with VBA Code19.3.2.3.1. TransferSharePointList Object Model19.3.2.3.2. Creating a SharePoint Linked Table in Code19.3.2.4. Query Processing for SharePoint Data19.3.2.5. Offline Mode for SharePoint Linked Tables19.3.2.5.1. Data Storage during Offline Mode19.3.2.5.2. Offline Mode Data Synchronization Model19.3.2.5.3. Using Offline Mode via the Access UI19.3.2.5.4. Discarding Changes to an Offline Linked Table19.3.2.5.5. Caching List Data for SharePoint Linked Tables19.3.2.5.6. Using Offline Mode via Code19.3.2.5.7. VBA Code for Offline Mode19.3.2.5.8. VBA Code for Caching Mode19.3.3. Migrating a Database to SharePoint19.3.3.1. Using the Export to SharePoint Wizard19.3.3.2. Data Type Conversion19.3.3.3. Database Changes When Migrating to SharePoint19.3.3.4. Features That Do Not Migrate to SharePoint19.3.3.4.1. The Move to SharePoint Issues Table19.3.3.4.2. Table Feature Not Available on SharePoint19.3.4. Publishing a Database to SharePoint19.3.4.1. Publishing a Traditional Database Application19.3.4.2. The PublishURL Property19.3.4.3. Opening in Read-Only Mode19.3.4.3.1. Read-Only Mode for Local Tables19.3.4.3.2. Read-Only Mode for Linked Tables19.3.4.4. Opening in Edit Mode19.3.4.5. Opening Published Databases with VBA Code19.4. ACCESS FEATURES ON SHAREPOINT19.4.1. SharePoint 2.0 Shows Access Features19.4.2. Access Web Datasheet19.4.2.1. Edit in Datasheet19.4.2.2. Datasheet Task Pane19.4.2.2.1. Track this List in Access19.4.2.2.2. Export to Access19.4.2.2.3. Report with Access19.4.2.3. Open with Access19.4.2.4. Access Application Templates for SharePoint19.4.2.4.1. How It Works19.4.2.4.2. Access SharePoint Tasks Template19.4.2.4.3. Access SharePoint Issue Tracking Template19.4.2.4.4. Using the AppendOnly Property19.4.2.4.5. Using the ColumnHistory Method19.4.2.4.6. Creating SharePoint Templates with NewCurrentDatabase19.4.2.4.7. Open with Access for Non-Template Linked Lists19.4.2.5. Importing from SharePoint19.4.2.5.1. Importing from SharePoint 2010 into an ACCDB19.4.2.5.2. Importing from SharePoint 2010 into an MDB19.4.2.5.3. Importing from SharePoint Using VBA Code19.4.2.5.4. Importing through the Access User Interface19.4.2.6. Access Views on SharePoint19.4.2.6.1. Advertising Access Views on the View Menu19.4.2.6.2. Using the DisplayOnSharePointSite Property19.5. SUMMARY
20. Working with .NET
20.1. OVERVIEW20.1.1. Example Files20.2. VISUAL STUDIO .NET 201020.2.1. Getting Visual Studio 201020.2.2. Installing Visual Studio 201020.2.2.1. Installing Visual Studio before Access20.2.2.2. Installing Access before Visual Studio20.2.3. .NET Terminology20.2.4. Writing Code in Visual Studio 201020.2.4.1. Creating a New Project20.2.4.2. The Program.cs File20.2.4.3. Writing Code in C#20.2.4.3.1. Defining Namespaces20.2.4.3.2. Defining Classes20.2.4.3.3. Defining Constructors20.2.4.3.4. Defining Variables20.2.4.3.5. Defining Methods20.2.4.3.6. Instantiating Objects20.2.4.3.7. Setting Properties20.2.4.3.8. Calling Methods20.2.4.3.9. Using Statements20.2.4.4. Adding Items to the Project20.2.4.5. Building the Project20.2.4.6. Executing the Binaries20.2.5. Debugging Code in Visual Studio 201020.2.5.1. Executing Code with the Debugger20.2.5.2. Setting Breakpoints20.2.5.2.1. Stepping Into Code20.2.5.2.2. Stepping Over Code20.2.5.2.3. Continuing Code Execution20.2.5.2.4. Resetting Code Execution20.2.5.2.5. Using Conditional Breakpoints20.2.6. The MSDN Library20.3. USING ACCESS DATABASES IN .NET20.3.1. Working with ADO.NET20.3.1.1. Adding Using Statements20.3.1.2. Creating an OleDbConnection Object20.3.1.3. Maintaining Connections20.3.1.4. Creating an OleDbCommand Object20.3.1.5. Executing Commands Against a Database20.3.1.5.1. The ExecuteReader Method20.3.1.5.2. The ExecuteNonQuery Method20.3.1.5.3. The OleDbDataAdaptor Object20.3.1.6. Working with SQL20.3.2. Types of .NET Applications20.3.3. Building Client Applications20.3.3.1. Database File Permissions20.3.3.2. Deciding on a Database Location20.3.3.3. Manually Setting Permissions20.3.3.4. Expanding Environment Variables20.3.3.5. Setting Environment Variables20.3.4. Building Web Applications20.3.4.1. Creating an ASP.NET Web Application20.3.4.2. Code Execution20.3.4.3. The App_Data Folder20.3.4.4. Setting Permissions20.3.4.5. Working with Third-Party Web Hosts20.3.4.6. The Server.MapPath Method20.3.5. Other Methods of Using Access Databases20.4. AUTOMATING ACCESS WITH .NET20.4.1. The Access PIA20.4.2. Setting References20.4.3. Creating Code to Automate Access20.4.3.1. Add Using Statements20.4.3.2. The Access Application Object20.4.3.3. Creating an Instance of Access20.4.3.4. Calling the Access Object Model20.4.3.5. Calling Access from the Windows Form20.4.4. Running the Automated Application20.5. CREATING COM ADD-INS FOR ACCESS20.5.1. The Benefits of COM Add-Ins20.5.2. Creating a New COM Add-In Project20.5.3. Setting References to the Access PIA20.5.4. Adding Custom Code to the Add-In20.5.4.1. Adding Support for the Ribbon20.5.4.1.1. Inheriting IRibbonExtensibility Interface20.5.4.1.2. Adding the Ribbon XML20.5.4.1.3. Add the GetCustomUI Method20.5.4.1.4. Create the Code for the Add-In20.5.5. Installing the COM Add-In20.5.6. Running the COM Add-In20.6. USING .NET CODE IN ACCESS20.6.1. Creating a Managed Library in .NET20.6.1.1. Creating a Managed Class Library Project20.6.1.2. Coding a Managed Class20.6.1.2.1. Adding Using Statements20.6.1.2.2. Creating an Interface for the Class20.6.1.2.3. Choosing a Class Name20.6.1.2.4. Creating the Data Members20.6.1.2.5. Creating the Constructors20.6.1.2.6. Creating the Methods20.6.1.3. Signing the Managed Assemblies20.6.1.3.1. Creating an SNK File20.6.1.3.2. Setting the Project's SNK File20.6.1.4. Building the Managed Class20.6.1.5. Creating a COM Type Library for the Assembly20.6.1.6. Deploying the Managed Class20.6.2. Calling a Managed Library from VBA20.6.2.1. Choosing a Database20.6.2.2. Setting References20.6.2.3. Calling the .NET Code from VBA Code20.7. SUMMARY
21. Building Client-Server Applications with Access
21.1. DATABASE APPLICATION EVOLUTION21.2. CLIENT-SERVER APPLICATIONS21.2.1. Using the Sample Files21.2.2. Installing the Sample Database21.2.3. Choosing the Correct File Format21.3. THE ACCDB/MDB FILE FORMAT21.3.1. Linking to External Data21.3.2. Creating a DSN via Access21.3.3. DSN Connection Types21.3.4. Using ACE with ODBC Data Sources21.3.4.1. The SQL Server Profiler Tool21.3.4.2. LinkedTable Performance Considerations21.3.4.3. Query Performance Considerations21.3.4.4. Compound Key Performance Considerations21.3.4.5. Increasing DSN Performance21.3.5. Increasing ODBC Performance21.3.5.1. Server Resource Considerations21.3.5.2. Client Machine Resource Considerations21.3.5.3. Network Performance Considerations21.3.5.4. Pass-Through Queries21.3.5.4.1. pass-through Query Uses21.3.5.4.2. Creating a pass-through Query21.4. THE ADP FILE FORMAT21.4.1. Using ADPs to Link to Data21.4.1.1. Linked Servers in SQL Server21.4.1.2. Creating Linked Servers with Access21.4.1.3. Creating Linked Servers with VBA Code21.4.2. Query Options on SQL Server21.4.2.1. SQL Server Views21.4.2.2. SQL Server Stored Procedures21.4.2.3. SQL Server Functions21.5. ACCDB/MDB VERSUS ADP21.5.1. Recordset Differences21.5.2. Security Differences21.5.3. Local Data Storage21.5.4. Sharing Application Files21.6. CONTROLLING THE LOGON PROCESS21.6.1. Controlling Login for ACCDB/MDB Files21.6.2. Controlling the Login Process for ADPs21.7. BINDING ADO RECORDSETS21.7.1. Binding to a Form, ComboBox, or ListBox21.7.2. Binding to a Report21.7.3. Using Persisted Recordsets21.7.3.1. Persisting the Data to XML21.7.3.2. Loading the XML Data21.8. WORKING WITH UNBOUND FORMS21.8.1. When to Use Unbound Forms21.8.2. Creating Unbound Forms21.8.2.1. Modifying the Design of the Form21.8.2.2. Creating the Recordset21.8.2.3. Adding Code to Navigate the Recordset21.8.2.4. Enabling Records for Editing21.9. SUMMARY
22. The Access 2010 Templates
22.1. ACCESS 2010 TEMPLATE FEATURES22.2. ACCESS 2010 TEMPLATES TYPES22.2.1. Standalone Database Templates22.2.1.1. Instantiating a Standalone Template in Access 201022.2.1.2. Community Templates22.2.2. Access Web Application Templates22.2.3. Templates for SharePoint Applications22.3. APPLICATION PARTS22.4. TABLE FIELD TEMPLATES22.5. SAVE AS TEMPLATE22.5.1. Creating ACCDT Files22.5.2. Features Not Supported in ACCDT Files22.5.3. Deploying ACCDT Files22.5.3.1. Opening a Template Using the Access UI22.5.3.1.1. Double-Click22.5.3.1.2. Use the Open Dialog Box22.5.3.1.3. Selecting Templates by Category22.5.3.2. Showing Custom Templates in the Backstage22.5.3.3. Using the Access Object Model to Create Templates22.6. THE ACCDT FILE FORMAT22.6.1. The ACCDT File Parts22.6.2. The Template's Root Folder22.6.3. The Template Folder22.6.3.1. Preview Image22.6.3.2. template.xml22.6.3.3. Database Folder22.6.3.4. _rels Folder22.6.4. The Database Folder22.6.4.1. databaseProperties.xml22.6.4.2. navpane.xml22.6.4.3. relationships.xml22.6.4.4. vbaReferences.xml22.6.5. The Objects Folder22.6.5.1. Database Object Files22.6.5.2. sampleData Folder22.6.5.3. Properties Folder22.6.5.4. _rels folder22.7. SUMMARY
23. Access Runtime Deployment
23.1. THE ACCESS 2010 RUNTIME23.1.1. Why Use the Access Runtime?23.1.2. Access 2010 Runtime Versions23.1.3. Getting the Access 2010 Runtime23.1.4. Using the Access Runtime23.1.4.1. The ACCDR File Format23.1.4.2. The /Runtime Command-Line Switch23.1.4.3. Side-by-Side Installations23.1.4.4. Full Access versus the Access Runtime23.2. DEPLOYING THE ACCESS RUNTIME23.2.1. Manual Installation of the Runtime23.2.2. The Package Solution Wizard23.2.3. Using the Package Solution Wizard23.2.3.1. Starting the Package Solution Wizard23.2.3.2. Page 1: Package Solution Wizard Options23.2.3.2.1. Target System Requirements for the Setup Package23.2.3.2.2. Starting New or Choosing an Existing Template23.2.3.3. Page 2: Installation and Shortcut Options23.2.3.3.1. The Installation Options23.2.3.3.2. The Pre-Installation Requirements23.2.3.3.3. Shortcut Options23.2.3.3.4. Command-Line Options23.2.3.4. Page 3: Additional Files and Registry Keys23.2.3.4.1. Additional Files23.2.3.4.2. Additional Registry Keys23.2.3.5. Page 4: Additional MSI File Settings23.2.3.5.1. General Properties23.2.3.5.2. Feature Information23.2.3.5.3. Add/Remove Programs Information23.2.3.5.4. File Properties23.2.3.5.5. Advanced Options23.2.3.6. Finishing the Wizard23.2.3.7. More Information about MSI Files23.2.3.8. MSI Editing Tools23.2.3.9. Install Chaining23.3. SUMMARY
24. Database Security
24.1. ACCDB FILE SECURITY24.1.1. Shared-Level Security for ACCDBs24.1.1.1. Data Encryption Is Key24.1.1.2. Encrypt with Password24.1.1.3. Using the Access UI to Password Protect24.1.1.4. Using the Access UI to Remove a Password24.1.1.5. Using Code to Encrypt with Password24.1.1.5.1. Using DAO to Set the Database Password24.1.1.5.2. Using DAO to Set Encryption Options24.1.1.5.3. Using ADO to Set the Database Password24.1.1.5.4. Using the Access OM to Set the Password24.1.2. Securing VBA Code in ACCDB24.1.2.1. Locking the VBA Project24.1.2.1.1. Protecting the VBA Project24.1.2.1.2. Removing Protection from the VBA Project24.1.2.2. Creating an ACCDE File24.1.2.2.1. Using the Access UI to Create an ACCDE File24.1.2.3. Using VBA to Create an ACCDE24.1.2.3.1. Using SysCmd 603 to Create an ACCDE24.1.3. ACCDB Security Summary24.2. MDB FILE SECURITY24.2.1. Shared-Level Security for MDBs24.2.1.1. Setting a Password for an MDB File24.2.1.2. Using the Access UI to Set the Database Password24.2.1.3. Using VBA Code to Set the Database Password24.2.2. Encoding an MDB File24.2.2.1. Using the Access UI to Encode an MDB24.2.3. Securing VBA Code for MDBs24.2.3.1. Locking the VBA Project24.2.3.2. Creating an MDE file24.2.3.2.1. Using the Access UI to Create an MDE File24.2.3.2.2. Using VBA to Make an MDE24.2.4. User-Level Security24.2.4.1. User-Level Security Overview24.2.4.1.1. Planning User-Level Security24.2.4.1.2. Notes about Other Security Methods24.2.4.2. The MDW File24.2.4.3. The Database to be Secured24.2.5. Working with User-Level Security24.2.6. Using the User-Level Security Wizard24.2.7. Using the Access User Interface24.2.8. User-Level Security Using DAO24.2.8.1. Adding Groups24.2.8.2. Removing Groups24.2.8.3. Adding Users24.2.8.4. Removing Users24.2.8.5. Adding Users to Groups24.2.8.6. Removing Users from Groups24.2.8.7. Setting Permissions for the Database24.2.8.8. setting permissions for database objects24.2.8.9. Combining Permission Values24.2.8.10. Removing Permission Values24.2.8.11. Changing the Owner of an Object24.2.9. User-Level Security Using ADO24.2.9.1. Opening an ADO Connection24.2.9.2. Adding Groups24.2.9.3. Removing Groups24.2.9.4. Adding Users24.2.9.5. Adding Users to Groups24.2.9.6. Removing Users24.2.9.7. Removing Users from Groups24.2.9.8. Modifying a User's Password24.2.9.9. Ading Permissions24.2.9.10. Removing Permissions24.2.10. User-Level Security Using ADOX24.3. SUMMARY
25. Access 2010 Security Features
25.1. THE OFFICE TRUST CENTER25.1.1. What Is the Trust Center?25.1.2. Trust Center Features25.1.2.1. Trusted Publishers25.1.2.2. Trusted Locations25.1.2.3. Trusted Documents25.1.2.4. File Validation25.1.2.5. Add-Ins25.1.2.6. Macro Settings25.1.2.7. Message Bar25.1.2.8. Privacy Options25.2. DISABLED MODE25.2.1. Why Do We Have Disabled Mode?25.2.2. Enabling a Database25.2.3. Modal Prompts25.2.4. AutomationSecurity25.2.4.1. Opening Remote Databases Programmatically25.2.4.2. Other Uses for AutomationSecurity25.2.5. Macros in Access 201025.2.5.1. Unsafe Actions25.3. DIGITAL SIGNATURES AND CERTIFICATES25.3.1. Types of Digital Certificates25.3.1.1. Commercial Certificates25.3.1.2. Internal Certificates25.3.1.3. Obtaining a Digital Certificate25.3.2. Using Self-Certification25.3.2.1. Creating a Self-Certification Certificate25.3.2.2. Adding a Certificate to Your Database25.3.2.3. Using a Self-Signed Certificate on Another Computer25.3.3. Signed Packages25.3.3.1. Creating the Signed Package25.3.3.2. Extracting the Signed Package25.4. ACCESS DATABASE ENGINE EXPRESSION SERVICE25.4.1. Sandbox Mode in Access 201025.4.2. Sandbox Mode Limitations25.4.3. Workarounds25.4.3.1. Blocked Functions25.4.3.2. Blocked Custom Properties of ActiveX Controls25.5. SUMMARY
A. The Access Object Model
A.1. THE APPLICATION OBJECTA.1.1. Application Object PropertiesA.1.2. Application Object MethodsA.2. THE CURRENTDATA OBJECTA.3. THE CURRENTPROJECT OBJECTA.4. ACCESSOBJECTA.5. THE DOCMD OBJECTA.6. THE FORM OBJECTA.6.1. Form Object PropertiesA.6.2. Form Object MethodsA.6.3. Form Object EventsA.7. THE CONTROL OBJECTA.7.1. control object propertiesA.7.2. Control Object MethodsA.8. CONTROLS ON FORMS AND REPORTSA.8.1. The Attachment ControlA.8.1.1. Attachment Control Object PropertiesA.8.1.2. Attachment Control Object MethodsA.8.1.3. Attachment Control Object EventsA.8.2. The ComboBox ControlA.8.2.1. ComboBox Control Object PropertiesA.8.2.2. Combobox Control Object MethodsA.8.2.3. Combobox Control Object EventsA.8.3. The CommandButton ControlA.8.3.1. CommandButton Control Object PropertiesA.8.4. The ListBox ControlA.8.4.1. ListBox Control Object PropertiesA.8.4.2. ListBox Control Object MethodsA.8.5. The NavigationButton ControlA.8.5.1. NavigationButton Control Object PropertiesA.8.6. The NavigationControl ControlA.8.6.1. NavigationControl Control Object PropertiesA.8.7. The Subform ControlA.8.7.1. SubForm Control Object PropertiesA.8.7.2. Subform Control Object MethodsA.8.7.3. Subform Control Object EventsA.8.8. The TextBox ControlA.8.8.1. TextBox Control Object PropertiesA.8.8.2. Textbox Control Object EventsA.8.9. The WebBrowserControl ControlA.8.9.1. WebBrowserControl Control Object PropertiesA.8.9.2. WebBrowserControl Control Object EventsA.9. OTHER COMMON CONTROL MEMBERSA.10. THE IMPORTEXPORTSPECIFICATION OBJECTA.10.1. ImportExportSpecification Object PropertiesA.10.2. ImportExportSpecification Object MethodsA.11. THE MODULE OBJECTA.11.1. Module Object PropertiesA.11.2. Module Object MethodsA.12. THE PRINTER OBJECTA.12.1. Printer Object PropertiesA.13. THE REFERENCES COLLECTION AND REFERENCE OBJECTA.14. THE REPORTS COLLECTION AND REPORT OBJECTA.14.1. Report Object PropertiesA.14.2. Report Object MethodsA.14.3. Report Object EventsA.15. THE SCREEN OBJECTA.16. THE SECTION OBJECTA.16.1. Section Object PropertiesA.16.2. Section Object EventsA.17. OTHER HELPFUL INFORMATIONA.17.1. Order of EventsA.17.1.1. Forms, Controls, and SubformsA.17.1.2. Reports and SectionsA.17.1.2.1. Report View and Layout ViewA.17.1.2.2. Print PreviewA.17.1.3. RecordsA.17.1.3.1. Adding RecordsA.17.1.3.2. Editing RecordsA.17.1.3.3. Deleting Records
B. DAO Object Method and Property Descriptions
B.1. DAO-SUPPORTED OBJECTSB.1.1. ODBCDirectB.1.2. User-Level SecurityB.1.3. Containers CollectionB.1.4. Container ObjectB.1.4.1. CollectionsB.1.5. DBEngineB.1.6. CollectionsB.1.7. Databases CollectionB.1.8. Database ObjectB.1.9. CollectionsB.1.10. Documents CollectionB.1.11. Document ObjectB.1.12. CollectionB.1.13. Errors CollectionB.1.14. Error ObjectB.1.14.1. CollectionsB.1.15. Fields CollectionB.1.16. Field ObjectB.1.17. CollectionB.1.18. Field2 ObjectB.1.19. CollectionB.1.20. Groups CollectionB.1.21. Group ObjectB.1.22. CollectionsB.1.23. Indexes CollectionB.1.24. Index ObjectB.1.25. CollectionB.1.26. Parameters CollectionB.1.27. Parameter ObjectB.1.28. CollectionB.1.29. Recordsets CollectionB.1.30. Recordset ObjectB.1.31. CollectionsB.1.32. Recordset2 ObjectB.1.33. CollectionsB.1.34. Properties CollectionB.1.35. Property ObjectB.1.36. CollectionB.1.37. QueryDefs CollectionB.1.38. QueryDefObjectB.1.39. CollectionsB.1.40. Relations CollectionB.1.41. Relation ObjectB.1.41.1. CollectionsB.1.42. TableDefs CollectionB.1.43. TableDef ObjectB.1.43.1. CollectionsB.1.44. Users CollectionB.1.45. User ObjectB.1.45.1. CollectionsB.1.46. Workspaces CollectionB.1.47. Workspace ObjectB.1.47.1. CollectionsB.2. UNDOCUMENTED TOOLS AND RESOURCESB.2.1. Utilities ISAMStatsB.2.1.1. Method 1B.2.1.2. Method 2B.2.2. Methods DAO.PrivDBEngineB.2.2.1. Recordset.CollectB.2.2.1.1. Recordset.ParentB.3. DAO FIELD TYPESB.4. OPENRECORDSET CONSTANTS
C. ADO Object Model Reference
C.1. THE CONNECTION OBJECTC.1.1. Properties of the Connection ObjectC.1.2. Methods of the Connection ObjectC.1.2.1. The Connection.BeginTrans MethodC.1.2.2. The Connection.Cancel MethodC.1.2.3. The Connection.Close MethodC.1.2.4. The Connection.CommitTrans MethodC.1.2.5. The Connection.Execute MethodC.1.2.6. The Connection.Open MethodC.1.2.7. The Connection.OpenSchema MethodC.1.2.8. The Connection.RollbackTrans MethodC.1.3. Collections of the Connection ObjectC.1.3.1. The Connection.Properties CollectionC.1.3.2. The Connection.Errors CollectionC.1.3.2.1. Properties of the Errors CollectionC.1.3.2.2. Methods for the Errors CollectionC.2. THE ERROR OBJECTC.2.1. Properties of the Error ObjectC.3. THE COMMAND OBJECTC.3.1. Properties of the Command ObjectC.3.2. Methods of the Command ObjectC.3.2.1. The Command.Cancel MethodC.3.2.2. The Command.CreateParameter MethodC.3.2.3. The Command.Execute MethodC.3.3. Collections of the Command ObjectC.3.3.1. The Command.Parameters CollectionC.3.3.1.1. Properties of the Parameters CollectionC.3.3.1.2. Methods of the Parameters CollectionC.3.3.2. The Parameters.Append MethodC.3.3.3. The Parameters.Delete MethodC.3.3.4. The Parameters.Refresh MethodC.3.3.5. The Command.Properties CollectionC.4. THE PARAMETER OBJECTC.4.1. Properties of the Parameter ObjectC.4.2. Methods of the Parameter ObjectC.4.2.1. The Parameter.AppendChunk MethodC.4.3. Collections of the Parameter ObjectC.4.3.1. The Parameter.Properties CollectionC.5. THE RECORDSET OBJECTC.5.1. Properties of the Recordset ObjectC.5.2. Methods of the Recordset ObjectC.5.2.1. The Recordset.AddNew MethodC.5.2.2. The Recordset.Cancel MethodC.5.2.3. The Recordset.CancelBatch MethodC.5.2.4. The Recordset.CancelUpdate MethodC.5.2.5. The Recordset.Clone MethodC.5.2.6. The Recordset.Close MethodC.5.2.7. The Recordset.CompareBookmarks MethodC.5.2.8. The Recordset.Delete MethodC.5.2.9. The Recordset.Find MethodC.5.2.10. The Recordset.GetRows MethodC.5.2.11. The Recordset.GetString MethodC.5.2.12. The Recordset.Move MethodC.5.2.13. The Recordset.MoveFirst MethodC.5.2.14. The Recordset.MoveLast MethodC.5.2.15. The Recordset.MoveNext MethodC.5.2.16. The Recordset.MovePrevious MethodC.5.2.17. The Recordset.NextRecordset MethodC.5.2.18. The Recordset.Open MethodC.5.2.19. The Recordset.Requery MethodC.5.2.20. The Recordset.Resync MethodC.5.2.21. The Recordset.Save MethodC.5.2.22. The Recordset.Seek MethodC.5.2.23. The Recordset.Supports MethodC.5.2.24. The Recordset.Update MethodC.5.2.25. The Recordset.UpdateBatch MethodC.5.3. Collections of the Recordset ObjectC.5.3.1. The Recordset.Fields CollectionC.5.3.2. The Recordset.Properties CollectionC.6. THE RECORD OBJECTC.6.1. Properties of the Record ObjectC.6.2. Methods of the Record ObjectC.6.2.1. The Record.Cancel MethodC.6.2.2. The Record.Close MethodC.6.2.3. The Record.CopyRecord MethodC.6.2.4. The Record.DeleteRecord MethodC.6.2.5. The Record.GetChildren MethodC.6.2.6. The Record.MoveRecord MethodC.6.2.7. The Record.Open MethodC.6.3. Collections of the Record ObjectC.6.3.1. The Record.Fields CollectionC.6.3.2. The Record.Properties CollectionC.7. THE FIELDS COLLECTIONC.7.1. Properties of the Fields CollectionC.7.2. Methods of the Fields CollectionC.7.2.1. The Fields.Append MethodC.7.2.2. The Fields.CancelUpdate MethodC.7.2.3. The Fields.Delete MethodC.7.2.4. The Fields.Refresh MethodC.7.2.5. The Fields.Resync MethodC.7.2.6. The Fields.Update MethodC.8. THE FIELD OBJECTC.8.1. Properties of the Field ObjectC.8.2. Methods of the Field ObjectC.8.2.1. The Field.AppendChunk MethodC.8.2.2. The Field.GetChunk MethodC.8.3. Collections of the Field ObjectC.8.3.1. The Field.Properties CollectionC.9. THE STREAM OBJECTC.9.1. Properties for the Stream ObjectC.9.2. Methods for the Stream ObjectC.9.2.1. The Stream.Cancel MethodC.9.2.2. The Stream.Close MethodC.9.2.3. The Stream.CopyTo MethodC.9.2.4. The Stream.Flush MethodC.9.2.5. The Stream.LoadFromFile MethodC.9.2.6. The Stream.Open MethodC.9.2.7. The Stream.Read MethodC.9.2.8. The Stream.ReadText MethodC.9.2.9. The Stream.SaveToFile MethodC.9.2.10. The Stream.SetEOS MethodC.9.2.11. The Stream.SkipLine MethodC.9.2.12. The Stream.Write MethodC.9.2.13. The Stream.WriteText MethodC.10. THE PROPERTIES COLLECTIONSC.10.1. The Properties CollectionC.10.1.1. Properties of the Properties CollectionC.10.2. Methods of the Properties CollectionC.11. THE PROPERTY OBJECTC.11.1. Properties of the Property ObjectC.12. THE ADO ENUMERATIONSC.12.1. The AffectEnum MembersC.12.2. The BookmarkEnum MembersC.12.3. The CommandTypeEnum MembersC.12.4. The CompareEnum MembersC.12.5. The ConnectOptionEnum MembersC.12.6. The ConnectModeEnum MembersC.12.7. The CopyRecordOptionsEnum MembersC.12.8. The CursorLocationEnum MembersC.12.9. The CursorOptionEnum MembersC.12.10. The CursorTypeEnum MembersC.12.11. The DataTypeEnum MembersC.12.12. The EditModeEnum MembersC.12.13. The ExecuteOptionEnum MembersC.12.14. The FieldAttributeEnum MembersC.12.15. The FieldStatusEnum MembersC.12.16. The FilterGroupEnum MembersC.12.17. The GetRowsOptionEnum MembersC.12.18. The LineSeparatorEnum MembersC.12.19. The LockTypeEnum MembersC.12.20. The MarshalOptionsEnum MembersC.12.21. The MoveRecordOptionsEnum MembersC.12.22. The ObjectStateEnum MembersC.12.23. The ParameterAttributesEnum MembersC.12.24. The ParameterDirectionEnum MembersC.12.25. The PersistFormatEnum MembersC.12.26. The PositionEnum MembersC.12.27. The RecordCreateOptionsEnum MembersC.12.28. The RecordOpenOptionsEnum MembersC.12.29. The RecordStatusEnum MembersC.12.30. The RecordTypeEnum MembersC.12.31. The ResyncEnum MembersC.12.32. The SaveOptionsEnum MembersC.12.33. The SchemaEnum MembersC.12.34. The SearchDirectionEnum MembersC.12.35. The SeekEnum MembersC.12.36. The StreamOpenOptionsEnum MembersC.12.37. The StreamReadEnum MembersC.12.38. The StreamTypeEnum MembersC.12.39. The StreamWriteEnum MembersC.12.40. The StringFormatEnum Members
D. 64-Bit Access
D.1. INTRODUCING THE 64-BIT VERSION OF MICROSOFT OFFICE 2010D.2. 32-BIT TO 64-BIT ACCESS 2010 COMPARISOND.3. THE VBA 7 CODE BASED.4. ACTIVEX CONTROL AND COM ADD-IN COMPATIBILITYD.5. API COMPATIBILITYD.6. DEALING WITH LEGACY CODED.7. PERFORMANCE AND THE 64-BIT ENVIRONMENT
E. References for Projects
E.1. TYPES OF REFERENCESE.2. ADDING REFERENCES TO YOUR PROJECTSE.2.1. Reference Order Is ImportantE.2.2. The Object BrowserE.3. BUILDING CODE LIBRARIESE.3.1. Using CurrentDB versus CodeDBE.3.2. Working with References ProgrammaticallyE.3.2.1. The Reference ObjectE.3.2.2. Running a Procedure from a Library DatabaseE.3.2.3. Compiling to Validate ReferencesE.3.3. Fixing Broken ReferencesE.3.4. Avoiding Broken ReferencesE.3.5. References in Access 2010 64-bitE.3.6. Considerations When Upgrading to Access 2010E.4. RESOURCES
F. Reserved Words and Special Characters
F.1. WHAT ARE THE SOURCES OF RESERVED WORDS?F.2. RESERVED WORDS WITH ERROR MESSAGESF.3. RESERVED WORD LISTF.4. WHAT ARE SPECIAL CHARACTERS?F.4.1. ASCII Characters to AvoidF.4.2. Web ObjectsF.4.3. Bonus Code Example
G. Naming Conventions
G.1. THE BENEFITS OF USING A NAMING CONVENTIONG.2. A BRIEF HISTORYG.3. THE FUNDAMENTALS OF THE HUNGARIAN CONVENTIONG.4. RULES FOR CREATING NAMES — ADDING THE PERSONAL TOUCHG.4.1. Starting with the BasicsG.4.2. Some Additional Thoughts about Other ObjectsG.4.2.1. Variables and RoutinesG.4.2.2. FunctionsG.4.2.2.1. ConstantsG.4.2.2.2. ClassesG.4.2.2.3. Arrays and CollectionsG.4.2.2.4. AttachmentsG.4.2.2.5. MacrosG.4.2.2.6. Web ObjectsG.5. MORE DOS AND DON'TSG.6. TABLES OF TAGSG.7. STANDARDS
H. The Access Source Code Control
H.1. GETTING THE ACCESS SCCH.2. INSTALLING THE ACCESS SCCH.2.1. Installing an SCC ProgramH.2.2. Registering an SCC DatabaseH.2.3. Adding UsersH.3. USING THE ACCESS SCCH.3.1. Adding a Database to the SCCH.3.2. Modifying SCC DatabasesH.3.3. Creating a Database from the SCCH.4. THE ACCESS SCC OPTIONSH.5. SUMMARY
I. Tips and Tricks
I.1. VISUAL INTERFACE STANDARDSI.1.1. Use Businesslike ColorsI.1.2. Provide a Well-Marked ExitI.1.3. Watch Your PunctuationI.1.4. Use Consistent Button Placement & Shortcut KeysI.1.5. Hide Higher-Level FormsI.1.6. Use Read-Only "Index" FormsI.1.7. Check Your Table LinkageI.1.8. Translate Default Delete MessagesI.1.9. Looking GoodI.2. DAISY CHAIN YOUR FORMSI.2.1. Form A Opens Form BI.2.2. Form B OpensI.2.3. Form B ClosesI.2.4. When Form A Is a SubformI.3. FIND RECORDSI.3.1. Calling the Record Finder CodeI.3.2. Record Finder CodeI.3.2.1. Passing Control and Form References to a FunctionI.3.2.2. Optional ParametersI.3.3. Using the RecordsetCloneI.3.4. Searching Multiple Fields Using ConcatenationI.3.5. Handling Quotes in the Search PhraseI.3.6. Setting Focus from AfarI.4. SPLIT YOUR APPLICATIONI.5. DISPLAY INFORMATIVE FORM CAPTIONSI.6. PRELOAD RECORDSI.7. USE A SPLASH SCREENI.8. POP-UP MEMO WORKSPACE FORM WITH SPELL CHECKI.9. DETERMINE THE USER NAMEI.9.1. The Current Access UserI.9.2. The Current Windows UserI.10. CONTRIBUTOR TIPSI.10.1. Need Data in Columns: IIF Queries to the RescueI.10.1.1. The IIF Query SolutionI.10.1.2. Taking the IIF Statement a Little FurtherI.10.2. TempVarsI.10.2.1. Creating a TempVarI.10.2.2. Compared with Global VariablesI.10.2.3. Using TempVars to Identify Application UsersI.10.3. Tips for Tables and ColorsI.10.3.1. Listing All Indexed Fields in a DatabaseI.10.3.2. Prohibit Manually Deleting a TableI.10.3.3. Scripting Access TablesI.10.3.4. Implementing Audit Trail CapabilitiesI.10.3.5. Color BlenderI.10.4. Access Services 2010 in Action: Screencast Tutorial Database ProjectI.10.4.1. The Web DatabaseI.10.4.2. Benefits to the End User

Content preview from Microsoft® Access® 2010 Programmer's Reference

Appendix A. The Access Object Model

By now you've probably read at least a few of the chapters in this book and have realized that there are a lot of tasks you can accomplish by programming in VBA. One concept that should be clear is that to use VBA to manipulate Access, you need some knowledge about the Access object model. It was discussed brie?y in Chapter 5, but as a refresher, an object model is a set of objects and collections that programmers use to manipulate a program.

Microsoft Access has a rich object model that you'll use to manipulate forms, reports, queries, macros, and other components of the Access interface. All in all, there are over 5600 members in the entire Access object model, making it a bit too large to fit completely in this appendix. As such, we've included the properties, methods, and events that are used frequently. Much of the information in this appendix can also be found in some form within the Access Visual Basic Reference Help file.

THE APPLICATION OBJECT

All of the objects and collections in the Access object model are children of the Application object. Every object and collection is related to the Application object through either a direct parent/child relationship or multiple parent/child relationships.

The Application object refers to the currently running instance of Access. You can use the Application object to apply methods or to set or retrieve properties for the entire Access application. For example, you can use the Version property to determine ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780470591666Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Microsoft® Access® 2010 Programmer's Reference

by Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Appendix A. The Access Object Model

THE APPLICATION OBJECT

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.