Microsoft Access 2010 Bible

xxvi

Contents

Chapter 26: Bulletproofing Access Applications . . . . . . . . . . . . . . . . . . . 897

Introducing Bulletproofing ................................................................................................898

Looking at the Characteristics of Bulletproofed Applications .............................................898

Identifying the Principles of Bulletproofing .......................................................................899

Building to a specification .......................................................................................900

Becoming one with documentation .........................................................................902

Considering your users ...........................................................................................903

Getting the application to the users .........................................................................905

Enabling the users to actually use the application ....................................................907

Controlling the flow of information .........................................................................912

Keeping the user informed ......................................................................................915

Tracking down problems ........................................................................................919

Securing the environment .......................................................................................923

Protecting your database .........................................................................................927

Continuing to improve the product .........................................................................938

Summary ..........................................................................................................................938

Chapter 27: Using the Windows Application Programming Interface . . . 939

What the Windows API Is .................................................................................................939

Reasons to Use the Windows API ......................................................................................940

Common code base .................................................................................................941

Tested and proven code ..........................................................................................941

Cross-platform compatibility ...................................................................................941

Smaller application footprint ...................................................................................941

Application consistency ...........................................................................................941

DLL Documentation .........................................................................................................942

Finding the documentation .....................................................................................942

Making sense of the documentation ........................................................................942

Recognizing what you can’t do with the API ............................................................945

How to Use the Windows API ...........................................................................................946

The Declare statement .............................................................................................946

Wrapper functions ..................................................................................................949

API Examples ....................................................................................................................950

Retrieving system information .................................................................................952

Going over general-purpose Windows API functions ..............................................960

Manipulating application settings with the Windows API ........................................962

Summary ..........................................................................................................................967

Chapter 28: Object-Oriented Programming with VBA  . . . . . . . . . . . . . . 969

Introducing Object-Oriented Programming ......................................................................970

Getting to know objects ..........................................................................................970

Defining objects with class modules ........................................................................972

Looking at a simple class module ............................................................................973

Adding a class module to a database .......................................................................974

02_475348-ftoc.indd xxvi02_475348-ftoc.indd xxvi 4/1/10 1:42 PM4/1/10 1:42 PM