Microsoft Access 2010 Bible

Chapter 30: Using Access Macros 1073 The first OnError action in the macro lets Access know to move to the submacro ErrorHandler ...

Part IV: Professional Database Development 1074 Use the MacroError object as a debugging tool or to display messages to the user ...

Chapter 30: Using Access Macros 1075 l (^) Debug window: Use the debug window to look at any values, temporary variables, or pro ...

Part IV: Professional Database Development 1076 Follow these steps to create an embedded macro that opens frmContacts: Click th ...

Chapter 30: Using Access Macros 1077 FIGURE 30.20 An embedded macro doesn’t have a name. The title bar displays the control and ...

Part IV: Professional Database Development 1078 Note The VBA language supplies a DoCmd object that accomplishes many macro actio ...

Chapter 30: Using Access Macros 1079 To try the conversion process, convert the mcrHelloWorldEnhanced macro used earlier in this ...

1080 Part IV: Professional Database Development FIGURE 30.23 The newly converted module When you open the VBA editor for the new ...

Chapter 30: Using Access Macros 1081 Summary In this chapter, you learned how to create a variety of different macros, from simp ...

...

1083 CHAPTER Distributing Access Applications IN THIS CHAPTER Setting options for your current database Making sure your applica ...

Part IV: Professional Database Development 1084 Defining the Current Database Options Access databases have a number of options ...

Chapter 31: Distributing Access Applications ........................................................................... 1085 Ne ...

Part IV: Professional Database Development 1086 Display Status Bar Deselect the Display Status Bar check box to remove the statu ...

Chapter 31: Distributing Access Applications 1087 You must close and reopen the current database for the changes to take effect. ...

Part IV: Professional Database Development 1088 Remove Personal Information from File Properties on Save Checking this box autom ...

Chapter 31: Distributing Access Applications 1089 Access only stores one copy of an image (in its original format) and dynamical ...

Part IV: Professional Database Development 1090 In the Grouping Options section, click on a category on the left side of the dia ...

Chapter 31: Distributing Access Applications 1091 Ribbon Name The Ribbon Name option lets you specify a customized (usually trim ...

Part IV: Professional Database Development 1092 Tip The Name AutoCorrect option is turned on by default in Access applications. ...