When the word ‘Macros’ is mentioned in the context of Microsoft Access Macros, most users feel a little overwhelmed and shy away from implementing any. They know it’s part of the smooth running and the automation for an Access database system but still there is the perception that is can sometimes be a barrier and a bit of a learning curve here.

So, to help you get up and running (and assuming your have found where macros are managed and stored) here are 5 simple to use Microsoft Access macros (based on version 2010):

1. Maximizing a window by calling the ‘MaximizeWindow’ command which has no arguments (parameters). You attach this to an event on a form or a report when loading it and hey presto! it will give you a full screen view of your form or report.
2. Running a Report by calling the ‘OpenReport’ command and you must specify at least the report name you want to call. Additional arguments can be applied to help choose the output (print, preview or layout) with the addition to filter records when running.
3. Navigating or creating a record by calling the ‘GoToRecord’ command which allows you to choose between the object type (table, query, form or a function) with the name of the object and then the action you wish to perform which includes first, last and new.
4. Calling an Access menu command by calling ‘RunMenuCommand’ command which simulates a large selection of pre-defined Microsoft Access commands via the Ribbon Bar which extends the flexibility of the limited number of Microsoft Access macros this object offers. This is typically used with other macro commands.
5. Interacting with users by calling the ‘MessageBox’ command where a message prompt appears to ask user to logically make a decision (yes or no) and is a great way to pause and branch to other calling macro commands emulating the way we (that’s human beings) think.

It’s worthwhile spending some time with this object (Microsoft Access macros) and browse through the 70 or so commands available. By the time you combine and specify different arguments, you have a good level of automation available to you and will not require any special programming knowledge – welcome to the world of easy programming!

Another Tip for you! There is one macro command which will give the power true flexibility of controlling your Microsoft Access database and that’s the ‘RunCode’ command. This will call VBA code (functions) that suddenly releases and merges the power of code with Microsoft Access macros.

I invite you to keep up to date with my articles and eBooks which covers a lot of details and can be found at http://AccessDatabaseTutorial.com.

From Ben Beitler – “Your Access Database Expert”