Access 2002 Visual Basic for Applications
Step by Step
332 pages, parution le 29/11/2001
Résumé
Teach yourself just what you need to know about developing
add-ins for Microsoft Office XP. This title, aimed at
beginner developers, is a teach-yourself guide to creating
custom software solutions, automating tasks, and taking
creative control of Access Version 2002 by exploiting its
built-in programming language, Microsoft Visual Basic(r)
for Applications (VBA). You'll learn to automate databases,
write your own functions and procedures, customize menus
and toolbars, connect applications to the Web, and more.
The popular S-by-Step method lets you choose your best
starting point, and the easy-to-follow lessons include
clear objectives and real-world business examples so you
can learn exactly what you need to know, at your own speed.
Prepared by an author with extensive knowledge of VBA and
Access, this book includes numerous screen shots that
illustrate specific step-by-step programming procedures,
plus a companion CD-ROM full of practice files that are
tightly integrated with the lessons.
Contents
- Introduction ix
- Getting Help xi
- Using the Book's CD-ROM xiii
- Conventions and Features xvii
- Using Wizards for Application Development 2
- Creating a Database Using the Database Wizard 2
- Adding an Object to Your Application 10
- Adding a Command Button to a Form 13
- Customizing a Command Button 22
- Modifying a Command Button Created Using the Wizard 27
- Making a Form Read-Only by Default 31
- Creating a Command Button Without a Wizard 33
- Creating Event Procedures for Form Events 38
- Displaying a Message to the User 40
- Creating a Combo Box to Find Records 45
- Filtering Data 52
- Understanding Form and Control Events 67
- Performing Actions as the User Moves in a Form 69
- Performing Actions as the User Changes Data 72
- Responding to Keyboard Events 75
- Validating Data 78
- Understanding Modules and Procedures 89
- Creating General Procedures in a Standard Module 91
- Using General Procedures on a Form 99
- Creating General Functions in a Form Module 101
- So Many Options, So Few Rules 106
- Stepping Through Code Line by Line 109
- Finding and Fixing Bugs in Your Code 120
- Replacing Standard Error Messages 132
- Responding to a Combo Box Error 136
- Creating Error-Handling Routines 141
- Creating an Application from Scratch 150
- Creating a Dialog Box to Go to a Specific Record 152
- Filtering Data in a Report 167
- Making Forms Work Together 176
- Displaying Related Records in a Pop-Up Form 177
- Opening a Form to Add Related Records 184
- Using Menus and Toolbars in Your User Interface 193
- Creating a Custom Menu Bar 194
- Customizing Toolbars 203
- Controlling How Your Application Starts 214
- Customizing Your Application's Appearance 218
- Preparing to Distribute Your Application to Users 220
- Introducing the Issues Application 230
- Understanding Objects and Collections 232
- Referring to Objects and Collections 237
- Using the For Each Statement with a Collection 239
- Using a Multiple-Selection List Box 241
- Working Directly with Database Objects 243
- Finding and Changing Data in a Recordset 245
- Creating and Running an Action Query 250
- Using Standard Reporting Features 256
- Responding to Report Events 258
- Calculating Totals While a Report Is Printing 264
- Controlling Printer Settings 269
- Using Automation Objects 276
- Sending Commands to Microsoft Word 277
- Getting Information from Another Application 283
- Working with Folders in Microsoft Outlook 285
- Using Access Objects from Microsoft Excel 289
- Using Hyperlinks 292
- Creating Web Pages for Your Application 305
- What's Next 319
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Microsoft Press |
| Auteur(s) | Evan Callahan |
| Parution | 29/11/2001 |
| Nb. de pages | 332 |
| Format | 18,8 x 23,4 |
| Couverture | Broché |
| Poids | 800g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780735613584 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
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
