Résumé
Microsoft Access is the bestselling stand-alone relational database program for Windows offering both power and ease of use. And in many respects, Microsoft has made Automation the centerpiece of its vision for application development. DAO Object Model: The Definitive Reference will guide you through the Access object models, allowing you, with the support of Automation, to reference the application components you want to manipulate. An understanding of the object models is essential for developers who work with data in Access tables, or who want to manipulate components of the Access interface from other Office apps. The Data Access Objects (DAO) model is used to write and read data in Access tables. The Access object model is used to manipulate forms, reports, queries, macros, and other components of the Access interface, including most of the commands by means of the DoCmd object.
This book will include an introduction and a brief description of the differences between VBA (used in most Office applications) and VBScript (used in Outlook). This chapter will also cover Office utilities and add-ons helpful in writing and debugging code, such as the Object Browser, the Integrated Development Environment (IDE) for VBA and the Interactive Debugger for VBScript. The book will then be divided into two parts; one covering the Access Object Model and the other, the Data Access Objects. Each section will have a description of what the object represents; listings of properties, events, and methods; and one or more code samples illustrating its use in VBA and/or VBScript code. Each property, event, or method section will have an explanation of the language element, and many will have code samples (either VBA or VBScript) as well.
This book will detail, to an advanced user or keen intermediate user, the Access object models and how they are used. It will be the reference guide VB developers reach for when working with data in Access tables, or for manipulating components of the Access interface from other Office applications.
Table of contents
- Preface
- 1: Introduction
- Early and Late Binding
- The Object Models for Working with Access
- The Visual Basic Dialects
- 2: DBEngine Object
- DBEngine Properties
- DBEngine Methods
- 3: Errors Collection and Error Object
- Errors Collection Properties
- Errors Collection Methods
- Error Object Properties
- 4: Workspaces Collection and Workspace Object
- Workspaces Collection Properties
- Workspaces Collection Methods
- Workspace Object Properties
- Workspace Object Methods
- 5: Databases Collection and Database Object
- Databases Collection Properties
- Databases Collection Methods
- Database Object Properties
- Database Object Methods
- 6: Containers Collection and Container Object
- Containers Collection Properties
- Containers Collection Methods
- Container Object Properties
- 7: QueryDefs Collection and QueryDef Object
- QueryDefs Collection Properties
- QueryDefs Collection Methods
- QueryDef Object Properties
- QueryDef Object Methods
- 8: Recordsets Collection and Recordset Object
- Recordsets Collection Properties
- Recordsets Collection Methods
- Recordset Object Properties
- Recordset Object Methods
- 9: Relations Collection and Relation Object
- Relations Collection Properties
- Relations Collection Methods
- Relation Object Properties
- Relation Object Methods
- 10: TableDefs Collection and TableDef Object
- TableDefs Collection Properties
- TableDefs Collection Methods
- TableDef Object Properties
- TableDef Object Methods
- 11: Groups Collection and Group Object
- Groups Collection Properties
- Groups Collection Methods
- Group Object Properties
- Group Object Methods
- 12: Users Collection and User Object
- Users Collection Properties
- Users Collection Methods
- User Object Properties
- User Object Methods
- 13: Fields Collection and Field Object
- Fields Collection Properties
- Fields Collection Methods
- Field Object Properties
- Field Object Methods
- 14: Parameters Collection and Parameter Object
- Parameters Collection Properties
- Parameters Collection Methods
- Parameter Object Properties
- 15: Indexes Collection and Index Object
- Indexes Collection Properties
- Indexes Collection Methods
- Index Object Properties
- Index Object Methods
- 16: Properties Collection and Property Object
- Properties Collection Properties
- Properties Collection Methods
- Property Object Properties
- A: Object Model Browser
- B: Object Model Browser Reference
- Index
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | O'Reilly |
| Auteur(s) | Helen Feddema |
| Parution | 15/01/2000 |
| Nb. de pages | 550 |
| EAN13 | 9781565924352 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
