Microsoft Access 2010 Bible

Chapter 26: Bulletproofing Access Applications 913 FIGURE 26.11 Switchboard forms control a user’s access to the application. Re ...

Part IV: Professional Database Development 914 Notice the Display Navigation Pane check box, the Allow Full Menus check box, and ...

Chapter 26: Bulletproofing Access Applications 915 Overlapping Windows The Overlapping Windows interface has its advantages as w ...

Part IV: Professional Database Development 916 l (^) Buttons: A numeric expression that defines the number and type of buttons t ...

Chapter 26: Bulletproofing Access Applications 917 The Button value you provide MsgBox can be a combination of several options. ...

Part IV: Professional Database Development 918 TABLE 26.2 MsgBox Return Values Button Pressed Constant Returned Value Returned O ...

Chapter 26: Bulletproofing Access Applications 919 FIGURE 26.14 The progress meter after initialization Incrementing the meter i ...

Part IV: Professional Database Development 920 Checking for obvious hardware errors Whenever possible, you should monitor how mu ...

Chapter 26: Bulletproofing Access Applications 921 The logging information you add to a database might include updating a time s ...

Part IV: Professional Database Development 922 l (^) The name of the control that was active at the time the error occurred (may ...

Chapter 26: Bulletproofing Access Applications 923 A prototype of using LogError() is shown in the following subroutine. Notice ...

Part IV: Professional Database Development 924 TABLE 26.4 Start-up Option Properties of the Application Object Startup Option Pr ...

Chapter 26: Bulletproofing Access Applications 925 Note Because AllowBypassKey is a developer-only property, it isn’t built into ...

Part IV: Professional Database Development 926 Setting property values You use the Application object’s SetOption method to set ...

Chapter 26: Bulletproofing Access Applications 927 Using AddStartupProperty() is quite easy. You must know the exact property na ...

Part IV: Professional Database Development 928 Building bulletproof forms You can take several steps to make each form in an app ...

Chapter 26: Bulletproofing Access Applications 929 a form from the form’s BeforeUpdate event instead of individually checking ea ...

Part IV: Professional Database Development 930 Tip If your database has a password associated with it, the user will still be pr ...

Chapter 26: Bulletproofing Access Applications 931 In the Password field, type the password that you want to use to secure the ...

Part IV: Professional Database Development 932 FIGURE 26.20 Choosing to remove a password from an encrypted Access database. The ...