Access uses macro control programs 4. Common macro operations
Updated: November 3, 2006 00:00:00 Author:
Macro operations are very rich. If you just make a small database, the process of the program can be fully implemented with macros without using Visual Basic. Some operations have no parameters (such as Beep), while some operations must specify parameters (such as OpenForm). Generally, setting the parameters of the operation in the order of parameters is a good way, because selecting a parameter will determine the selection of the parameters that follow the parameter. Common macro operations operate illustrate Beep Beep through the computer's speakers. Close Closes the specified Microsoft Access window. If no window is specified, the active window is closed. GoToControl Move focus to open form, form data table, table data table, query data table, specific fields or controls for the current record in the query data table. Maximize Zoom in the active window to fill the Microsoft Access window. This operation allows the user to see as many objects in the active window as possible. Minimize Narrow the active window to the subtitle bar at the bottom of the Microsoft Access window. MsgBox Displays a message box containing warning messages or other information. OpenForm Open a form and limit the records displayed on the form by selecting the form's data input and window method. OpenReport Open a report in Design view or print a report now. You can also limit records that need to be printed in the report. PrintOut Print active objects in the open database, or print data tables, reports, forms, and modules. Quit Exit Microsoft Access. The Quit operation can also specify whether to save the database object before exiting Access. RepaintObject Completes screen updates for the specified database object. If no database object is specified, the active database object is updated. Updates all recalculations of all controls including the object. Restore Restores the window in maximum or minimized size to its original size. RunMacro Run the macro. This macro can be in a macro group. SetValue Sets the values of fields, controls, or properties on a Microsoft Access form, form datasheet, or report. StopMacro Stops the currently running macro.
Related Articles
Escape characters about SQL statements in ACCESS
Escape characters about SQL statements in ACCESS...2007-04-04Use the criteria to conduct conditional query-1.3. Enter parameters before running the query
Use the criteria to conduct conditional query-1.3. Enter parameters before running the query...2006-11-11Access uses macro control program--1.5. An example of a macro-check password
Access uses macro control program--1.5. An example of a macro - verify password...2006-11-11Multi-table query skills
Multi-table query skills...2006-07-07How to restore the method to delete tables from databases in Access 2000, Access 2002, or Access 2003
Methods to restore the deletion of tables from databases in Access 2000, Access 2002, or Access 2003...2007-08-08Access string processing function sorting
Some string processing function codes used in the access database can be used as reference.2011-05-05Share the method of modifying the automatic numbered ID value to zero by ACCESS database
This article introduces the method of modifying the automatic numbered ID value to zero in ACCESS database. Friends who need it can refer to it.2013-10-10Access's comment field limit is 64K
2008-01-01Compression 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-11Microsoft Access Database General Specifications
Microsoft Access Database General Specifications...2006-07-07