Jump Start VBA Skills with MS Access Macros - Creating and running a macro in MS Access: opening the macro designer
(Page 2 of 5 )
Create an access database file Macro.mdb (this is my name for it) as shown. The left side shows all the Access objects that includes macros.
Click on Macros, and you will see that you are allowed only to create a New Macro, as this is a new file with no other objects. Now click on the tab with the icon New. This opens up the next window, the Macro Designer, where you can fashion the macro. It comes up with a default name, Macro1.
Later on, before you leave the macro designer, you will get a chance to save the macro with a name of your choice. Presently it has two columns, Action and Comment. Action is where you state what needs to happen when the macro runs. The comment is for your reference, and lets you explain it in a more descriptive form. Below the column you have the action arguments. Since there are no actions, there are no arguments. The two columns are there by default; you may add additional columns by going to tools->option->view as shown. Here you can choose to show the Names column and the Conditions column.
This picture shows the macro designer with all four columns (you may have to close and open the macro designer to make the changes visible). In the Macro Name column you give the macro a name, and the condition is some condition that you may want to impose on the action. We will not use this column for this introductory tutorial.
Next: Creating the first macro >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 29 
