Screen updating ms access

posted by | Leave a comment

For example, if a file does not exist, you may want the macro to end.You let macros make such decisions by adding conditions to your macros.As such, set the arguments to specify the object you want closed (the report).To do this, select the first argument, Object Type, and then click your mouse on the pull-down arrow to its right.(Notice that there are no arguments for the Stop Macro action; it simply stops the macro.) Figure 18-9 The conditional and its action have been entered. 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.When you are done entering these two actions, you should be ready to enter the fourth action--the one that will print the report. In the fourth row of the Action column, select this action; your Macro window will appear as shown in Figure 18-10. There are two arguments for the Open Report action which you must set.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.The condition you will check now is whether there are any records in the table to print.

With this in mind, the steps for your macro would be: To begin, display the Macro window.In this case, the default option (Print) should be selected.This argument causes Access to immediately print the report.When you do, you can select from the reports you have defined in your database.Select the My Friends, Alphabetic List report (this is the only one you have defined).

Leave a Reply

Free chat fuck no sighn up