What is Macro? and How to use/make it.
- Thread starter asdaqamin
- Start date
seth_belgium
WoW-Addict
- Local time
- Today, 22:16
- Joined
- Oct 4, 2005
- Messages
- 175
A macro is a simplified, visualized version of VBA-coding. With a macro you can sequence a number of actions Access has to perform when the macro is run.
Examples of macro-usage:
-> Opening a form and going to the last record.
-> Running several queries, print a report, run some more queries, open a form and display a message to a user.
The possibilities of a macro are pretty restricted when you compare it to VBA (Visual Basic for Applications) code.
So basically; if you want to perform a sequence of simple actions like described above, you definately should start experimenting with macros. As you get better at it, you'll want to do more that macro's can offer, and you'll have to start learning some VBA-code.
Finally: A macro can be opened in the database window by double-clicking it or from a form with a commandbutton. Just follow the steps in the wizard for creating such buttons on a form. You can select "Open a macro" or "Run macro", I don't know the exact phrasing anymore.
For all the actions macro's can perform and how to use them; Press F1...
Good luck!
Seth
Examples of macro-usage:
-> Opening a form and going to the last record.
-> Running several queries, print a report, run some more queries, open a form and display a message to a user.
The possibilities of a macro are pretty restricted when you compare it to VBA (Visual Basic for Applications) code.
So basically; if you want to perform a sequence of simple actions like described above, you definately should start experimenting with macros. As you get better at it, you'll want to do more that macro's can offer, and you'll have to start learning some VBA-code.
Finally: A macro can be opened in the database window by double-clicking it or from a form with a commandbutton. Just follow the steps in the wizard for creating such buttons on a form. You can select "Open a macro" or "Run macro", I don't know the exact phrasing anymore.
For all the actions macro's can perform and how to use them; Press F1...
Good luck!
Seth
statsman
Active member
- Local time
- Today, 16:16
- Joined
- Aug 22, 2004
- Messages
- 2,082
An excellent example of a macro would be "Autoexec".
Just like the old days in MS-DOS, Access will automatically run the Autoexec macro every time you open the database.
Good contents for Autoexec:
"Maximize" - expands Access to full screen so that you're not working in a little corner.
"Open Form" Opens a form on the screen at startup, such as your Main Switchboard.
Just like the old days in MS-DOS, Access will automatically run the Autoexec macro every time you open the database.
Good contents for Autoexec:
"Maximize" - expands Access to full screen so that you're not working in a little corner.
"Open Form" Opens a form on the screen at startup, such as your Main Switchboard.
Similar threads
