Book description
A comprehensive guide to programming for Access 2010 and 2007
Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements.
With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic.
Access 2010 Programmer's Reference is a comprehensive guide to the best-of-breed techniques for programming Access applications.
Coverage Includes:
Introduction to Microsoft Access 2010
New Features
Upgrading and Converting to Access 2010
Macros in Access 2010
Using the VBA Editor
VBA Basics
Using VBA in Access
Creating Classes in VBA
Extending VBA with APIs
Working with the Windows Registry
Using DAO to Access Data
Using ADO to Access Data
Using SQL with VBA
Using VBA to Enhance Forms
Enhancing Reports with VBA
Customizing the Ribbon
Customizing the Office Backstage
Working with Office 2010
Working with SharePoint
Working with .NET
Building Client-Server Applications with Access
The Access 2010 Templates
Access Runtime Deployment
Database Security
Access 2010 Security Features
Table of contents
- Copyright
- CREDITS
- ABOUT THE AUTHORS
- ABOUT THE CONTRIBUTING AUTHORS AND TECHNICAL EDITORS
- ABOUT THE TECHNICAL EDITORS
- ACKNOWLEDGMENTS
- INTRODUCTION
- 1. Introduction to Microsoft Access 2010
- 2. New Features
-
3. Upgrading and Converting to Access 2010
-
3.1. TO CONVERT OR TO ENABLE
- 3.1.1. Common Terminology
- 3.1.2. Key Decision Factors
-
3.1.3. Feature Sets and File Extensions: What's New, What's Replaced, What Happens
- 3.1.3.1. File Extensions
- 3.1.3.2. New Features Available Only with ACCDB File Format
- 3.1.3.3. Access 2010 Is Based on 2007 File Format
- 3.1.3.4. Features Not Available with ACCDB Files
- 3.1.3.5. What Happens When a 2007/2010 MDB Is Opened by Prior Versions
- 3.1.3.6. What Happens When a 2010 ACCDB Is Opened by 2007
- 3.1.4. Other Things to Consider
- 3.2. INSTALLING MULTIPLE VERSIONS OF ACCESS ON ONE PC
-
3.3. CHANGING FILE FORMATS
- 3.3.1. Selecting the Default File Format
- 3.3.2. Overriding the Default File Format
- 3.3.3. ACCDE and MDE Files
- 3.3.4. Steps for Converting or Enabling
- 3.3.5. File Conversion Using Access 2010: A One-Stop Shop
- 3.3.6. Other Considerations When Converting
- 3.3.7. Converting to Access 97 or Earlier Is a Two-Version Process
- 3.4. CONVERTING A SECURED DATABASE
- 3.5. CONVERTING A REPLICATED DATABASE
- 3.6. ENABLING A DATABASE
- 3.7. ACCESS 2010: 64-BIT CONSIDERATIONS
- 3.8. SUMMARY
-
3.1. TO CONVERT OR TO ENABLE
-
4. Macros in Access 2010
- 4.1. VBA VERSUS MACROS IN ACCESS
- 4.2. TYPES OF MACROS
- 4.3. CREATING MACROS IN ACCESS 2010
- 4.4. MACRO OBJECTS AND EMBEDDED MACROS
-
4.5. DATA MACROS
- 4.5.1. Types of Data Macros
- 4.5.2. Running Data Macros
- 4.5.3. Data Macro Blocks
- 4.5.4. Data Macro Properties
- 4.5.5. Data Macro Actions and Arguments
- 4.5.6. Error Handling
- 4.5.7. Variables
- 4.5.8. Data Macro Scenarios
- 4.6. SUMMARY
- 5. Using the VBA Editor
-
6. VBA Basics
- 6.1. THE MINDSET OF A PROGRAMMER
- 6.2. ANATOMY OF VBA PROCEDURES
- 6.3. VBA KEYWORDS
- 6.4. VBA OPERATORS
- 6.5. VARIABLES AND VBA SYNTAX
- 6.6. OTHER VBA COMPONENTS
- 6.7. VBA OBJECTS
- 6.8. USING CODE BEHIND FORMS AND REPORTS
- 6.9. USING VBA CODE TO CALL MACROS
- 6.10. WRITING CODE IN MODULES
- 6.11. EXAMPLE: USER-DEFINED FUNCTION
- 6.12. SUMMARY
-
7. Using VBA in Access
- 7.1. WHEN EVENTS FIRE
- 7.2. VBA PROCEDURES
- 7.3. EVALUATING EXPRESSIONS IN VBA
- 7.4. USING RECORDSETS
- 7.5. USING MULTIPLE RECORDSETS
- 7.6. USING VBA IN FORMS AND REPORTS
- 7.7. DEBUGGING VBA
- 7.8. INVESTIGATING VARIABLES
- 7.9. COMMON VBA TECHNIQUES
- 7.10. STRING CONCATENATION TECHNIQUES
- 7.11. VBA ERROR HANDLING
- 7.12. SUMMARY
-
8. Creating Classes in VBA
- 8.1. WHY USE CLASSES?
- 8.2. A TOUCH OF CLASS
-
8.3. CREATING A CLASS MODULE
- 8.3.1. Adding a Class Module to the Project
- 8.3.2. A Brief Word on Naming the Class
- 8.3.3. Instantiating Class Objects
- 8.3.4. Creating Class Methods
-
8.3.5. Creating Property Procedures
- 8.3.5.1. Using Property Get
- 8.3.5.2. Using Property Let
- 8.3.5.3. Using Property Set
- 8.3.5.4. Declaring Property Read-Write Attributes
- 8.3.5.5. Using Enumerated Types with Properties and Methods
- 8.3.5.6. Creating Flags
- 8.3.5.7. Exiting Property Procedures
- 8.3.5.8. Procedure Attributes
- 8.3.5.9. Friendly Procedures
- 8.4. NAMING AND IDENTIFYING OBJECTS
- 8.5. USING CLASS EVENTS
- 8.6. FORMS AND REPORTS AS OBJECTS
- 8.7. VARIABLE SCOPE AND LIFETIME
- 8.8. THE ME PROPERTY
- 8.9. CREATING A CLONE METHOD
- 8.10. CREATING AND USING COLLECTION CLASSES
- 8.11. THE THREE PILLARS
- 8.12. SUMMARY
-
9. Extending VBA with APIs
- 9.1. INTRODUCING THE WINDOWS API
- 9.2. INTRODUCING LINKING
- 9.3. DECLARING APIS
-
9.4. UNDERSTANDING C PARAMETERS
- 9.4.1. Signed and Unsigned Integers
- 9.4.2. Numeric Parameters
- 9.4.3. Object Parameters
- 9.4.4. String Parameters
- 9.4.5. Variant Parameters
- 9.4.6. Pointers to Numeric Values
- 9.4.7. Pointers to C Structures
- 9.4.8. Pointers to Arrays
- 9.4.9. Pointers to Functions
- 9.4.10. Pointers in 64-Bit Windows
- 9.4.11. The Any Data Type
- 9.5. ERR.LASTDLLERROR
- 9.6. DISTRIBUTING APPLICATIONS THAT REFERENCE TYPE LIBRARIES AND CUSTOM DLLS
-
9.7. USEFUL API FUNCTIONS
- 9.7.1. Returning the Path to the Windows Folder
- 9.7.2. Determining Whether the System Processor Is 32-Bit or 64-Bit
- 9.7.3. Determining Whether Windows Is 32-Bit or 64-Bit
- 9.7.4. Determining Whether Office Is 32-Bit or 64-Bit
- 9.7.5. Displaying the Windows Open Dialog Box
- 9.7.6. Finding the Position of a Form
- 9.7.7. Finding the Temp Directory
- 9.7.8. Generating a Unique Temp Filename
- 9.7.9. Finding the Login Name of the Current User
- 9.7.10. Finding the Computer Name
- 9.7.11. Opening or Printing Any File
- 9.7.12. Delaying Code Execution
- 9.7.13. Getting the Path to a Special Folder
- 9.7.14. Locking the Computer
- 9.8. SUMMARY
-
10. Working with the Windows Registry
- 10.1. ABOUT THE REGISTRY
- 10.2. USING THE BUILT-IN VBA REGISTRY FUNCTIONS
-
10.3. USING THE WINDOWS REGISTRY APIs
- 10.3.1. Getting Started
- 10.3.2. Creating a Registry Key
- 10.3.3. Setting the Value for a Key
- 10.3.4. Getting the Value for a Key
- 10.3.5. Deleting a Registry Value
- 10.3.6. Deleting a Registry Key
- 10.3.7. Testing the Function Wrappers
- 10.3.8. Opening an Existing Registry Key
- 10.3.9. Connecting to the Registry on a Remote Computer
- 10.3.10. Enumerating Registry Keys and Values
- 10.4. SUMMARY
-
11. Using DAO to Access Data
- 11.1. DATA ACCESS OBJECTS
- 11.2. WHY USE DAO?
- 11.3. NEW FEATURES IN DAO
- 11.4. REFERRING TO DAO OBJECTS
- 11.5. THE DBENGINE OBJECT
- 11.6. THE DATABASE OBJECT
- 11.7. DAO OBJECT PROPERTIES
- 11.8. CREATING SCHEMA OBJECTS WITH DAO
- 11.9. DATA ACCESS WITH DAO
- 11.10. APPEND-ONLY FIELDS
- 11.11. SUMMARY
-
12. Using ADO to Access Data
- 12.1. INTRODUCTION TO ADO IN ACCESS
- 12.2. ADDING ADO REFERENCES
- 12.3. CONNECTING TO ADO DATA SOURCES
-
12.4. DATA ACCESS WITH ADO
- 12.4.1. Overview of the ADO Object Model
- 12.4.2. Using the Execute Method
- 12.4.3. Creating Recordsets
- 12.4.4. Navigating Recordsets
-
12.4.5. Working with Data in Recordsets
- 12.4.5.1. Referring to Fields
- 12.4.5.2. Retrieving Data
- 12.4.5.3. Modifying Data
- 12.4.5.4. Creating Batch Updates
- 12.4.5.5. Adding New Data
- 12.4.5.6. Deleting Data
- 12.4.5.7. Closing Recordsets
- 12.4.5.8. Saving Recordset Data to a File
- 12.4.5.9. Loading Recordset Data from a File
- 12.4.5.10. Disconnected Recordsets
- 12.5. USING ADO EVENTS
- 12.6. SCHEMA RECORDSETS WITH ADO
- 12.7. CREATING SCHEMA WITH ADOX
- 12.8. SUMMARY
-
13. Using SQL with VBA
- 13.1. WORKING WITH SQL STRINGS IN VBA
- 13.2. USING SQL WHEN OPENING FORMS AND REPORTS
- 13.3. USING SQL TO ENHANCE FORMS
- 13.4. THE REPLACEORDERBYCLAUSE AND REPLACEWHERECLAUSE FUNCTIONS
- 13.5. SUMMARY
-
14. Using VBA to Enhance Forms
- 14.1. VBA BASICS
-
14.2. CREATING FORMS THE 2010 WAY
- 14.2.1. Columnar and Tabular Layouts
- 14.2.2. Anchoring
- 14.2.3. The Modal Dialog Box Mode
- 14.2.4. Control Wizards - Creating Command Buttons Using VBA or Macros
- 14.2.5. Command Button Properties
- 14.2.6. Attachment Controls
- 14.2.7. Combo Boxes
- 14.2.8. Using the BeforeUpdate Event
- 14.2.9. Saving E-mail Addresses Using the Textbox AfterUpdate Event
- 14.2.10. Outputting to PDF
- 14.2.11. OpenArgs
- 14.2.12. IsLoaded()
- 14.2.13. On Timer ()
- 14.2.14. Late Binding
- 14.2.15. On Click(): Open a Form Based on a Value on the Current Form
- 14.2.16. Multiple Form Instances
- 14.2.17. Displaying Data in TreeView and ListView Controls
- 14.3. SUMMARY
-
15. Enhancing Reports with VBA
- 15.1. INTRODUCTION TO REPORTS
- 15.2. CREATING A REPORT
- 15.3. WORKING WITH VBA IN REPORTS
- 15.4. IMPORTANT REPORT EVENTS AND PROPERTIES
- 15.5. REPORT PROPERTIES
- 15.6. WORKING WITH CHARTS
- 15.7. COMMON REPORT REQUESTS
- 15.8. LAYOUT VIEW
- 15.9. REPORT VIEW
- 15.10. SUMMARY
-
16. Customizing the Ribbon
- 16.1. RIBBON OVERVIEW
- 16.2. CUSTOM MENU BARS AND TOOLBARS
- 16.3. RIBBON CUSTOMIZATION USING THE OPTIONS DIALOG BOX
- 16.4. RIBBON CUSTOMIZATION
- 16.5. SAVING A CUSTOM RIBBON
-
16.6. SPECIFYING THE CUSTOM RIBBON
- 16.6.1. Defining a Ribbon Using XML
- 16.6.2. Writing Callback Routines and Macros
- 16.6.3. More Callback Routines
- 16.6.4. Displaying Images
- 16.6.5. Refreshing Ribbon Content
- 16.7. CREATING AN INTEGRATED RIBBON
- 16.8. CREATING A RIBBON FROM SCRATCH
- 16.9. MORE RIBBON TIPS
- 16.10. SUMMARY
-
17. Customizing the Office Backstage
- 17.1. INTRODUCING THE OFFICE BACKSTAGE
- 17.2. WRITING A BACKSTAGE CUSTOMIZATION
- 17.3. CONTROLS IN THE BACKSTAGE
- 17.4. DESIGNING THE LAYOUT OF COMPONENTS
- 17.5. EXTENDING THE EXISTING BACKSTAGE
- 17.6. BACKSTAGE-SPECIFIC CALLBACKS
-
17.7. BACKSTAGE SCENARIOS
- 17.7.1. Access Runtime Experience
- 17.7.2. Setting the Title of a Tab to the Application Title
- 17.7.3. About Page and Contact Form
- 17.7.4. Warning for a Missing Reference
- 17.7.5. Custom Database Information
- 17.7.6. Creating a Bulleted or Numbered List
- 17.7.7. Welcome Page with Image
- 17.7.8. Other Possible Examples
- 17.8. SUMMARY
-
18. Working with Office 2010
- 18.1. WORKING WITH OUTLOOK 2010
- 18.2. WORKING WITH EXCEL 2010
- 18.3. WORKING WITH WORD 2010
- 18.4. SUMMARY
-
19. Working with SharePoint
- 19.1. SHAREPOINT 2010
- 19.2. ACCESS FEATURES OVERVIEW
-
19.3. SHAREPOINT FEATURES IN ACCESS
-
19.3.1. Access Web Applications
- 19.3.1.1. Traditional Apps versus Web Apps
- 19.3.1.2. Getting Started with Web Apps
- 19.3.1.3. Creating Web Tables
- 19.3.1.4. Creating Web Queries
- 19.3.1.5. Creating Web Forms
- 19.3.1.6. Creating Web Reports
- 19.3.1.7. Creating Web Macros
- 19.3.1.8. Publishing to Access Services
- 19.3.1.9. Working with the Web Application
- 19.3.1.10. Access Web Application Summary
-
19.3.2. Linked Tables to SharePoint
- 19.3.2.1. SharePoint Linked Tables in an ACCDB
- 19.3.2.2. SharePoint Linked Tables in an MDB
- 19.3.2.3. Creating Linked Tables with VBA Code
- 19.3.2.4. Query Processing for SharePoint Data
-
19.3.2.5. Offline Mode for SharePoint Linked Tables
- 19.3.2.5.1. Data Storage during Offline Mode
- 19.3.2.5.2. Offline Mode Data Synchronization Model
- 19.3.2.5.3. Using Offline Mode via the Access UI
- 19.3.2.5.4. Discarding Changes to an Offline Linked Table
- 19.3.2.5.5. Caching List Data for SharePoint Linked Tables
- 19.3.2.5.6. Using Offline Mode via Code
- 19.3.2.5.7. VBA Code for Offline Mode
- 19.3.2.5.8. VBA Code for Caching Mode
- 19.3.3. Migrating a Database to SharePoint
- 19.3.4. Publishing a Database to SharePoint
-
19.3.1. Access Web Applications
-
19.4. ACCESS FEATURES ON SHAREPOINT
- 19.4.1. SharePoint 2.0 Shows Access Features
-
19.4.2. Access Web Datasheet
- 19.4.2.1. Edit in Datasheet
- 19.4.2.2. Datasheet Task Pane
- 19.4.2.3. Open with Access
-
19.4.2.4. Access Application Templates for SharePoint
- 19.4.2.4.1. How It Works
- 19.4.2.4.2. Access SharePoint Tasks Template
- 19.4.2.4.3. Access SharePoint Issue Tracking Template
- 19.4.2.4.4. Using the AppendOnly Property
- 19.4.2.4.5. Using the ColumnHistory Method
- 19.4.2.4.6. Creating SharePoint Templates with NewCurrentDatabase
- 19.4.2.4.7. Open with Access for Non-Template Linked Lists
- 19.4.2.5. Importing from SharePoint
- 19.4.2.6. Access Views on SharePoint
- 19.5. SUMMARY
-
20. Working with .NET
- 20.1. OVERVIEW
-
20.2. VISUAL STUDIO .NET 2010
- 20.2.1. Getting Visual Studio 2010
- 20.2.2. Installing Visual Studio 2010
- 20.2.3. .NET Terminology
- 20.2.4. Writing Code in Visual Studio 2010
- 20.2.5. Debugging Code in Visual Studio 2010
- 20.2.6. The MSDN Library
-
20.3. USING ACCESS DATABASES IN .NET
- 20.3.1. Working with ADO.NET
- 20.3.2. Types of .NET Applications
- 20.3.3. Building Client Applications
- 20.3.4. Building Web Applications
- 20.3.5. Other Methods of Using Access Databases
- 20.4. AUTOMATING ACCESS WITH .NET
- 20.5. CREATING COM ADD-INS FOR ACCESS
-
20.6. USING .NET CODE IN ACCESS
- 20.6.1. Creating a Managed Library in .NET
- 20.6.2. Calling a Managed Library from VBA
- 20.7. SUMMARY
-
21. Building Client-Server Applications with Access
- 21.1. DATABASE APPLICATION EVOLUTION
- 21.2. CLIENT-SERVER APPLICATIONS
- 21.3. THE ACCDB/MDB FILE FORMAT
- 21.4. THE ADP FILE FORMAT
- 21.5. ACCDB/MDB VERSUS ADP
- 21.6. CONTROLLING THE LOGON PROCESS
- 21.7. BINDING ADO RECORDSETS
- 21.8. WORKING WITH UNBOUND FORMS
- 21.9. SUMMARY
-
22. The Access 2010 Templates
- 22.1. ACCESS 2010 TEMPLATE FEATURES
- 22.2. ACCESS 2010 TEMPLATES TYPES
- 22.3. APPLICATION PARTS
- 22.4. TABLE FIELD TEMPLATES
- 22.5. SAVE AS TEMPLATE
- 22.6. THE ACCDT FILE FORMAT
- 22.7. SUMMARY
-
23. Access Runtime Deployment
- 23.1. THE ACCESS 2010 RUNTIME
-
23.2. DEPLOYING THE ACCESS RUNTIME
- 23.2.1. Manual Installation of the Runtime
- 23.2.2. The Package Solution Wizard
-
23.2.3. Using the Package Solution Wizard
- 23.2.3.1. Starting the Package Solution Wizard
- 23.2.3.2. Page 1: Package Solution Wizard Options
- 23.2.3.3. Page 2: Installation and Shortcut Options
- 23.2.3.4. Page 3: Additional Files and Registry Keys
- 23.2.3.5. Page 4: Additional MSI File Settings
- 23.2.3.6. Finishing the Wizard
- 23.2.3.7. More Information about MSI Files
- 23.2.3.8. MSI Editing Tools
- 23.2.3.9. Install Chaining
- 23.3. SUMMARY
-
24. Database Security
-
24.1. ACCDB FILE SECURITY
- 24.1.1. Shared-Level Security for ACCDBs
- 24.1.2. Securing VBA Code in ACCDB
- 24.1.3. ACCDB Security Summary
-
24.2. MDB FILE SECURITY
- 24.2.1. Shared-Level Security for MDBs
- 24.2.2. Encoding an MDB File
- 24.2.3. Securing VBA Code for MDBs
- 24.2.4. User-Level Security
- 24.2.5. Working with User-Level Security
- 24.2.6. Using the User-Level Security Wizard
- 24.2.7. Using the Access User Interface
-
24.2.8. User-Level Security Using DAO
- 24.2.8.1. Adding Groups
- 24.2.8.2. Removing Groups
- 24.2.8.3. Adding Users
- 24.2.8.4. Removing Users
- 24.2.8.5. Adding Users to Groups
- 24.2.8.6. Removing Users from Groups
- 24.2.8.7. Setting Permissions for the Database
- 24.2.8.8. setting permissions for database objects
- 24.2.8.9. Combining Permission Values
- 24.2.8.10. Removing Permission Values
- 24.2.8.11. Changing the Owner of an Object
-
24.2.9. User-Level Security Using ADO
- 24.2.9.1. Opening an ADO Connection
- 24.2.9.2. Adding Groups
- 24.2.9.3. Removing Groups
- 24.2.9.4. Adding Users
- 24.2.9.5. Adding Users to Groups
- 24.2.9.6. Removing Users
- 24.2.9.7. Removing Users from Groups
- 24.2.9.8. Modifying a User's Password
- 24.2.9.9. Ading Permissions
- 24.2.9.10. Removing Permissions
- 24.2.10. User-Level Security Using ADOX
- 24.3. SUMMARY
-
24.1. ACCDB FILE SECURITY
- 25. Access 2010 Security Features
-
A. The Access Object Model
- A.1. THE APPLICATION OBJECT
- A.2. THE CURRENTDATA OBJECT
- A.3. THE CURRENTPROJECT OBJECT
- A.4. ACCESSOBJECT
- A.5. THE DOCMD OBJECT
- A.6. THE FORM OBJECT
- A.7. THE CONTROL OBJECT
- A.8. CONTROLS ON FORMS AND REPORTS
- A.9. OTHER COMMON CONTROL MEMBERS
- A.10. THE IMPORTEXPORTSPECIFICATION OBJECT
- A.11. THE MODULE OBJECT
- A.12. THE PRINTER OBJECT
- A.13. THE REFERENCES COLLECTION AND REFERENCE OBJECT
- A.14. THE REPORTS COLLECTION AND REPORT OBJECT
- A.15. THE SCREEN OBJECT
- A.16. THE SECTION OBJECT
- A.17. OTHER HELPFUL INFORMATION
-
B. DAO Object Method and Property Descriptions
-
B.1. DAO-SUPPORTED OBJECTS
- B.1.1. ODBCDirect
- B.1.2. User-Level Security
- B.1.3. Containers Collection
- B.1.4. Container Object
- B.1.5. DBEngine
- B.1.6. Collections
- B.1.7. Databases Collection
- B.1.8. Database Object
- B.1.9. Collections
- B.1.10. Documents Collection
- B.1.11. Document Object
- B.1.12. Collection
- B.1.13. Errors Collection
- B.1.14. Error Object
- B.1.15. Fields Collection
- B.1.16. Field Object
- B.1.17. Collection
- B.1.18. Field2 Object
- B.1.19. Collection
- B.1.20. Groups Collection
- B.1.21. Group Object
- B.1.22. Collections
- B.1.23. Indexes Collection
- B.1.24. Index Object
- B.1.25. Collection
- B.1.26. Parameters Collection
- B.1.27. Parameter Object
- B.1.28. Collection
- B.1.29. Recordsets Collection
- B.1.30. Recordset Object
- B.1.31. Collections
- B.1.32. Recordset2 Object
- B.1.33. Collections
- B.1.34. Properties Collection
- B.1.35. Property Object
- B.1.36. Collection
- B.1.37. QueryDefs Collection
- B.1.38. QueryDefObject
- B.1.39. Collections
- B.1.40. Relations Collection
- B.1.41. Relation Object
- B.1.42. TableDefs Collection
- B.1.43. TableDef Object
- B.1.44. Users Collection
- B.1.45. User Object
- B.1.46. Workspaces Collection
- B.1.47. Workspace Object
- B.2. UNDOCUMENTED TOOLS AND RESOURCES
- B.3. DAO FIELD TYPES
- B.4. OPENRECORDSET CONSTANTS
-
B.1. DAO-SUPPORTED OBJECTS
-
C. ADO Object Model Reference
-
C.1. THE CONNECTION OBJECT
- C.1.1. Properties of the Connection Object
-
C.1.2. Methods of the Connection Object
- C.1.2.1. The Connection.BeginTrans Method
- C.1.2.2. The Connection.Cancel Method
- C.1.2.3. The Connection.Close Method
- C.1.2.4. The Connection.CommitTrans Method
- C.1.2.5. The Connection.Execute Method
- C.1.2.6. The Connection.Open Method
- C.1.2.7. The Connection.OpenSchema Method
- C.1.2.8. The Connection.RollbackTrans Method
- C.1.3. Collections of the Connection Object
- C.2. THE ERROR OBJECT
- C.3. THE COMMAND OBJECT
- C.4. THE PARAMETER OBJECT
-
C.5. THE RECORDSET OBJECT
- C.5.1. Properties of the Recordset Object
-
C.5.2. Methods of the Recordset Object
- C.5.2.1. The Recordset.AddNew Method
- C.5.2.2. The Recordset.Cancel Method
- C.5.2.3. The Recordset.CancelBatch Method
- C.5.2.4. The Recordset.CancelUpdate Method
- C.5.2.5. The Recordset.Clone Method
- C.5.2.6. The Recordset.Close Method
- C.5.2.7. The Recordset.CompareBookmarks Method
- C.5.2.8. The Recordset.Delete Method
- C.5.2.9. The Recordset.Find Method
- C.5.2.10. The Recordset.GetRows Method
- C.5.2.11. The Recordset.GetString Method
- C.5.2.12. The Recordset.Move Method
- C.5.2.13. The Recordset.MoveFirst Method
- C.5.2.14. The Recordset.MoveLast Method
- C.5.2.15. The Recordset.MoveNext Method
- C.5.2.16. The Recordset.MovePrevious Method
- C.5.2.17. The Recordset.NextRecordset Method
- C.5.2.18. The Recordset.Open Method
- C.5.2.19. The Recordset.Requery Method
- C.5.2.20. The Recordset.Resync Method
- C.5.2.21. The Recordset.Save Method
- C.5.2.22. The Recordset.Seek Method
- C.5.2.23. The Recordset.Supports Method
- C.5.2.24. The Recordset.Update Method
- C.5.2.25. The Recordset.UpdateBatch Method
- C.5.3. Collections of the Recordset Object
- C.6. THE RECORD OBJECT
- C.7. THE FIELDS COLLECTION
- C.8. THE FIELD OBJECT
-
C.9. THE STREAM OBJECT
- C.9.1. Properties for the Stream Object
-
C.9.2. Methods for the Stream Object
- C.9.2.1. The Stream.Cancel Method
- C.9.2.2. The Stream.Close Method
- C.9.2.3. The Stream.CopyTo Method
- C.9.2.4. The Stream.Flush Method
- C.9.2.5. The Stream.LoadFromFile Method
- C.9.2.6. The Stream.Open Method
- C.9.2.7. The Stream.Read Method
- C.9.2.8. The Stream.ReadText Method
- C.9.2.9. The Stream.SaveToFile Method
- C.9.2.10. The Stream.SetEOS Method
- C.9.2.11. The Stream.SkipLine Method
- C.9.2.12. The Stream.Write Method
- C.9.2.13. The Stream.WriteText Method
- C.10. THE PROPERTIES COLLECTIONS
- C.11. THE PROPERTY OBJECT
-
C.12. THE ADO ENUMERATIONS
- C.12.1. The AffectEnum Members
- C.12.2. The BookmarkEnum Members
- C.12.3. The CommandTypeEnum Members
- C.12.4. The CompareEnum Members
- C.12.5. The ConnectOptionEnum Members
- C.12.6. The ConnectModeEnum Members
- C.12.7. The CopyRecordOptionsEnum Members
- C.12.8. The CursorLocationEnum Members
- C.12.9. The CursorOptionEnum Members
- C.12.10. The CursorTypeEnum Members
- C.12.11. The DataTypeEnum Members
- C.12.12. The EditModeEnum Members
- C.12.13. The ExecuteOptionEnum Members
- C.12.14. The FieldAttributeEnum Members
- C.12.15. The FieldStatusEnum Members
- C.12.16. The FilterGroupEnum Members
- C.12.17. The GetRowsOptionEnum Members
- C.12.18. The LineSeparatorEnum Members
- C.12.19. The LockTypeEnum Members
- C.12.20. The MarshalOptionsEnum Members
- C.12.21. The MoveRecordOptionsEnum Members
- C.12.22. The ObjectStateEnum Members
- C.12.23. The ParameterAttributesEnum Members
- C.12.24. The ParameterDirectionEnum Members
- C.12.25. The PersistFormatEnum Members
- C.12.26. The PositionEnum Members
- C.12.27. The RecordCreateOptionsEnum Members
- C.12.28. The RecordOpenOptionsEnum Members
- C.12.29. The RecordStatusEnum Members
- C.12.30. The RecordTypeEnum Members
- C.12.31. The ResyncEnum Members
- C.12.32. The SaveOptionsEnum Members
- C.12.33. The SchemaEnum Members
- C.12.34. The SearchDirectionEnum Members
- C.12.35. The SeekEnum Members
- C.12.36. The StreamOpenOptionsEnum Members
- C.12.37. The StreamReadEnum Members
- C.12.38. The StreamTypeEnum Members
- C.12.39. The StreamWriteEnum Members
- C.12.40. The StringFormatEnum Members
-
C.1. THE CONNECTION OBJECT
- D. 64-Bit Access
-
E. References for Projects
- E.1. TYPES OF REFERENCES
- E.2. ADDING REFERENCES TO YOUR PROJECTS
- E.3. BUILDING CODE LIBRARIES
- E.4. RESOURCES
- F. Reserved Words and Special Characters
- G. Naming Conventions
- H. The Access Source Code Control
-
I. Tips and Tricks
-
I.1. VISUAL INTERFACE STANDARDS
- I.1.1. Use Businesslike Colors
- I.1.2. Provide a Well-Marked Exit
- I.1.3. Watch Your Punctuation
- I.1.4. Use Consistent Button Placement & Shortcut Keys
- I.1.5. Hide Higher-Level Forms
- I.1.6. Use Read-Only "Index" Forms
- I.1.7. Check Your Table Linkage
- I.1.8. Translate Default Delete Messages
- I.1.9. Looking Good
- I.2. DAISY CHAIN YOUR FORMS
- I.3. FIND RECORDS
- I.4. SPLIT YOUR APPLICATION
- I.5. DISPLAY INFORMATIVE FORM CAPTIONS
- I.6. PRELOAD RECORDS
- I.7. USE A SPLASH SCREEN
- I.8. POP-UP MEMO WORKSPACE FORM WITH SPELL CHECK
- I.9. DETERMINE THE USER NAME
- I.10. CONTRIBUTOR TIPS
-
I.1. VISUAL INTERFACE STANDARDS
Product information
- Title: Microsoft® Access® 2010 Programmer's Reference
- Author(s):
- Release date: August 2010
- Publisher(s): Wrox
- ISBN: 9780470591666
You might also like
book
Excel® 2007 VBA Programmer's Reference
Get ready to take your Excel applications to the next level by harnessing the power of …
book
Access™ 2007 VBA Programmer's Reference
This resource provides the tools you need to leverage Access 2007's built-in functionality and VBA in …
book
Access 2003 VBA Programmer's Reference
Covers all features of VBA programming for Access database applications Begins with an overview of VBA …
book
Microsoft® Access® 2010 In Depth
Access 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their …