Microsoft access dcount how to#

The View argument lets you indicate how you want Access to handle the report. Select the My Friends, Alphabetic List report (this is the only one you have defined). When you do, you can select from the reports you have defined in your database. If you select this argument, you can click your mouse on the pull-down arrow at the right of the argument box.

The first, Report Name, is where you identify the name of the report you want to use. There are two arguments for the OpenReport action which you must set. In the fourth row of the Action column, select this action your Macro window will appear as shown in Figure 18-10.ДЇigure 18-10 After entering the fourth macro step. To print a report, use the OpenReport action. When you are done entering these two actions, you should be ready to enter the fourth action-the one that will print the report.

Microsoft access dcount how to#

You already know how to enter the actions that turn off the screen updating (the Echo action) and change the mouse pointer to an hourglass (the Hourglass action) you used these actions in the previous macro. You can now enter the rest of the macro's actions. (Notice that there are no arguments for the StopMacro action it simply stops the macro.)ДЇigure 18-9 The conditional and its action have been entered. At this point, your Macro window should look like that shown in Figure 18-9. To end the macro, you can use the Stop Macro action. As you'll recall, if there are no records in the table, you want the macro to end. If the count of records in the My Friends table is equal to 0, the condition is True, and Access will execute the action on that row. When you use DCount in the following conditional statement, DCount returns the number of records in the entire table:Д®nter this condition in the first row of the Condition column. The DCount function determines the number of records that meet a specific criteria. You do this using the DCount function in the macro. For a review on Access expressions, turn to Chapter 3, 'Taking a Closer Look.' Condition expressions are the same as those you use in validation rules, filtering, and sorting.ДЇor the first step of this macro, you will want Access to determine if there are any records to print. In the Condition column, you specify expressions that tell Access when it should execute the actions you specify in the Action column. Access changes the Macro window to look like that shown in Figure 18-8.ДЇigure 18-8 Access displays the Condition column. To do so, click your mouse on the Conditions tool (to the left of the Insert Rows tool) or choose the Conditions option from the View menu. To add conditional statements to your macro, you need to add a third column. Notice that there are only two columns, Action and Comment.

With this in mind, the steps for your macro would be: If there are no records, you will want to exit the macro without printing anything. The condition you will check now is whether there are any records in the table to print. You created a report to do this in Chapter 8, 'Creating Simple Reports,' so all you need to do is make a simple macro that will run the report. For example, assume you want to create a macro to automatically generate a report of the records in the My Friends table.

These conditions determine when certain macro actions run. You let macros make such decisions by adding conditions to your macros. For example, if a file does not exist, you may want the macro to end. As your macros become more complex, you may want them to make decisions, based on specific conditions. When Access runs a simple macro, Access begins at the macro's first action and performs each action, one after another, in the order the actions appear in the Macro window Action column.