Access uses macro control program--1.6. Several explanations for using macros
Updated: November 3, 2006 00:00:00 Author:
6. A few instructions on using macros Instructions for macro operations are not required, but can make macros easier to understand and maintain. SQL expressions cannot be used in the macro "condition" column. Normally, executing the macro directly is just for testing. You can attach the macro to a form, report, or control to respond to events after ensuring the macro is designed correctly, or you can create a custom menu command that executes the macro.
If you want Microsoft Access to temporarily ignore an action, enter False as the condition. Ignoring operations for the time being helps identify problems in macros. If you want to quickly create a macro that performs an action on a specified database object, drag the object from the Database window to the action row of the Macro window. For example, dragging a form to the action line creates a macro that opens the form. The steps are as follows: Click the Vertical Tile command on the Window menu to place the Macro window and the Database window so that both can be displayed on the screen; then in the DB window, click the tab of the object type you want to drag, click the corresponding object, and drag it into an operation line. If you are dragging a macro, the operation that performs the macro will be added, while dragging other objects (tables, queries, forms, reports, or modules) will be added to open the corresponding object.
Related Articles
Access Use Query Notes on Executing Calculations in Query
Access uses query precautions for performing calculations in queries...2006-11-11Short int, long, float, double usage problem description
This problem is encountered when exporting Access data to DBF, the field width in DBF does not refer to the number of bytes occupied by the fields in Access, but the number of characters.2009-11-11Escape characters about SQL statements in ACCESS
Escape characters about SQL statements in ACCESS...2007-04-04Chinese Access2000 Quick Tutorial--1.7 Creating Index
Chinese Access2000 Quick Tutorial--1.7 Creating Index...2006-11-11What is the use of union? What is the difference between INNER JOIN?
What is the use of union? What is the difference between INNER JOIN?2006-07-07Use criteria for conditional query--1.4. Select query conditions from form
Use criteria for conditional query--1.4. Select the query conditions from the form...2006-11-11Four ways to randomly obtain 10 pieces of data in four databases
This article mainly introduces four methods to obtain 10 data at random in the database. Friends who need it can refer to it.2014-03-03Compression and repair methods of ACCESS database files [Pictures and texts]
This page introduces simple compression and repair functions. Online compression is prone to problems, so you can finally implement it locally.2010-11-11Access uses query--1.1. Create calculated fields with select query
Access uses query--1.1. Create calculated fields with select query...2006-11-11Access database prompts OleDbException (0x80004005): The operation must use an updateable query
When using Access as a database, this problem has depressed me for several days! [OleDbException (0x80004005): The operation must use an updateable query. ]2011-06-06