Microsoft Office Tutorials and References
In Depth Information
Telling Access to “Run This Only If I Say So”
Figure 1-10:
You can
add your
own digital
to your
5. Specify where to store the signed copy of the database and what
filename to use.
6. Click Create.
Now when you open this database, Access doesn’t complain. Whew!
Knowing which actions you can take
Normally, when you edit a macro in Design view, Access shows you only the
actions that it considers to be safe, such as actions that don’t allow you to
change data outside the database. If you want to see all possible macro
actions, click the Show All Actions button in the Show/Hide group on the
Design tab of the Ribbon. More actions appear on the Add New Action
dropdown menu and in the Action Catalog.
Telling Access to “Run This Only If I Say So”
Every programming language worth its salt has an if-then feature, which
ensures that a command is carried out only under specific circumstances.
You may want Access to print a report for the current order only if the order
number isn’t blank, for example. If the order number is blank, don’t print the
report, and if the order number isn’t blank, print the report. The technical
term for an if-then situation is conditional execution. The condition is a value
or expression that can be either true or false — in geek speak, a Boolean.
Search JabSto ::

Custom Search