Join Alicia Katz Pollock for an in-depth discussion in this video Developing macros with Macro Designer, part of Access 2010 New Features.
Access 2010 has enhanced the Macro Designer window and tools to make it easy to…develop macros from scratch.…Let's start by going to the Create tab and then over here and click on Macro and…that starts a new macro.…The first thing you'll notice is that the Macro Designer now works right inside…Access without opening up a subprogram.…It's structure looks much more like real programming than the previous macro grid.…It features an IntelliSense Builder.…To get started choose the first action off the drop-down list.…I'll choose OpenReport.…As you choose your actions, boxes will appear to set your conditions and parameters.…
I'll choose my Report Name and we'll use Salaries Report.…If I want to add a filter right here I could.…For my second action I could pick it off of the dropdown list.…But let's take a look at the Action Catalog over here on the right-hand side.…The actions are all grouped together by their function.…If I click on the plus signs I can open them all up to see.…I can also click up here and search.…
- Working with Application Parts
- Implementing the Table Tools ribbon
- Using Quick Start and calculated fields
- Designing with Layout View formatting tools
- Taking advantage of enhancements to the Conditional Formatting feature
- Automating with macros
- Working with external data
- Integrating SharePoint publishing
Skill Level Intermediate
Q: My macro isn't running correctly. I followed along with the author and I'm not receiving an error message, but the actions are performed correctly.
A: There are several possible reasons why a macro would malfunction. Make sure that the macro is written correctly. Capitalization and punctuation matters. Also make sure to click in all the same places when recording the macro. With enough practice, building macros will become more routine, and spotting errors will becoming easier.