#MS ACCESS MACROS HOW TO#

You can halt the current macro or all macros, cancel the event that triggered the macro, or quit the application. Include conditions that test values in a database, a form, or a report and use the results of a test to determine what action runs next.Д®xecute other macros or execute Visual Basic functions. You can base the parameters of a query on the values of controls in any open form. You can then open the file in Microsoft Word 2010 or Notepad.Д®xecute a select query or an action query. Send the output data from a report to a Rich Text Format (.rtf) file or a Notepad (.txt) file. Open a report in Print Preview or Report view or send a report directly to the printer. Open any table, query, form, or report in any available view or close any open table, query, form, or report. Uses of MacrosДЄccess 2010 provides various types of macro actions that you can use to automate your application. You might find that article useful as a quick reference when youвЂ™re designing macros for your applications. In Article 6, вЂњMacro Actions,вЂќ on the companion CD, youвЂ™ll find summaries of the client macro actions and of the web macro actions. YouвЂ™ll find that youвЂ™ll use nearly all the available macro actions in Visual Basic, so learning macros is an excellent introduction to programming in Access in general. However, even if you think youвЂ™re ready to jump right into Visual Basic, you should study all the macro actions first.

#MS ACCESS MACROS HOW TO#

(YouвЂ™ll learn how to automate a web database in Chapter 21, вЂњAutomating a Web Application Using Macros.вЂќ) As youвЂ™ll learn in Chapter 24, вЂњUnderstanding Visual Basic Fundamentals,вЂњ on the companion CD, you probably should use Microsoft Visual Basic for complex applications or for applications that will be shared by several users over a network. Macros are also essential if you want to automate a web database and display the application in a web browser using Access Services and SharePoint 2010. Macros are particularly useful for building small, personal applications or for prototyping larger ones. For the remainder of this chapter and the next, weвЂ™ll only use the term macros to refer to user interface macros. Within a user interface macro, you can include multiple actions and define condition checking so that different actions are performed depending on the values in your forms or reports. The event might be a change in the data, the opening or closing of a form or a report, or even a change of focus from one control to another. The unique power of user interface macros in Access is their ability to automate responses to many types of events without forcing you to learn a programming language. In Access 2010, you can define a user interface macro to execute just about any task you would otherwise initiate with the keyboard or the mouse. In this chapter and the next, youвЂ™ll learn about user interface macros. Data macros are attached to table events or the table itself and interact only at the data layer. In Chapter 7, вЂњCreating Table Data Macros,вЂќ you learned about the new data macro feature in Microsoft Access 2010. Making Your Application Come Alive with Macros Understanding Macro Actions That Are Not Trusted

Ms access macros