Microsoft Access 2010 Bible
Chapter 30: Using Access Macros 1053 The most common event to which you might assign a macro is a button’s Click event. Follow t ...
Part IV: Professional Database Development 1054 Tip You aren’t limited to the button’s Click event. If you want a macro to run e ...
Chapter 30: Using Access Macros 1055 Action Action Argument Action Argument Setting Echo Echo On No Status Bar Text Step 1: Dele ...
Part IV: Professional Database Development 1056 l (^) SetWarnings: This action turns the system messages on or off using the War ...
Chapter 30: Using Access Macros 1057 FIGURE 30.6 mcrBackupContactsAndProducts archives data from the live tables into the backup ...
Part IV: Professional Database Development 1058 The macro action drop-down list contains Submacro as an entry. While working on ...
Chapter 30: Using Access Macros 1059 Next, the developer selected Submacro a second time from the Add New Action list, and pro- ...
Part IV: Professional Database Development 1060 To implement a macro using submacros, create a form (frmMainMenu) with three but ...
Chapter 30: Using Access Macros 1061 l (^) Where Condition: This argument lets you enter a SQL Where clause or expression that s ...
Part IV: Professional Database Development 1062 The macro that opens the reports uses submacros, as well as the Condition column ...
Chapter 30: Using Access Macros 1063 Submacro Name Condition Action Action Argument Action Argument Setting [Forms]![frmReportMe ...
Part IV: Professional Database Development 1064 To implement this macro, set the On Click event properties of the buttons (cmdCo ...
Chapter 30: Using Access Macros 1065 Temporary Variables In previous versions of Access, you could use variables only in VBA cod ...
Part IV: Professional Database Development 1066 FIGURE 30.12 mcrHelloWorldEnhanced uses the SetTempVar action to get a value fro ...
Chapter 30: Using Access Macros 1067 For this example, use frmReportMenuEnhanced (shown in Figure 30.13), which contains the sam ...
Part IV: Professional Database Development 1068 FIGURE 30.14 mcrReportMenuEnhanced uses temporary variables to open the report i ...
Chapter 30: Using Access Macros 1069 variables you’ve already implemented with macros? Well, you don’t have to abandon them; ins ...
Part IV: Professional Database Development 1070 FIGURE 30.15 Errors in macros cause the macro to cease operation. A common error ...
Chapter 30: Using Access Macros 1071 The OnError action The OnError action lets you decide what happens when an error occurs in ...
Part IV: Professional Database Development 1072 TABLE 30.6 (continued) Macro Name Action Action Argument Action Argument Setting ...
«
51
52
53
54
55
56
57
58
59
60
»
Free download pdf