Jump Start VBA Skills with MS Access Macros - Creating the first macro

(Page 3 of 5 )

Let's create a very simple macro. This is my favorite macro. It's more universal than 'Hello, world." You need to understand English to appreciate "Hello world." This macro, when it runs, simply 'beeps.' To create this macro go to the designer and click on the Action column's first row, where you find a drop-down arrow. From the list, click on Beep, and the designer should appear as shown. Read the explanation in blue at the bottom in the Action Arguments section.

Now you have created your first macro. Click on the designer's close button at the top right most point. The message asks you whether you want to save changes to the macro you created. Click on Yes.

This will bring up this little message asking you to change the name for the macro .

I just called it 'MyBeep.' This will close the message box and shows the main window with the newly created "MyBeep" displayed as shown.

Now you may "run" the macro by going to the main window's left most point and clicking on "!" or from the pop-up drop-down. This should produce a beep from your computer.

Next: Converting this macro to VBA code >>
 

More Microsoft Access Articles
More By Jayaram Krishnaswamy

Comments On: Jump Start VBA Skills with MS Access Macros

· It's my pleasure to welcome you to read and comment on this article. VBA is a...    · Is it possible to add a pop up window in Access.fro instance if one has a stock...    · Does not mean I have a code ready. With DAP you should be able to do this and much...    · Hello!Not sure where to look for the "steps for query and report creation",...    · By the quoted text in your question, what I mean is, that I am assuming that I am...   >>> Post your comment now!