Join Alicia Katz Pollock for an in-depth discussion in this video Triggering data macros, part of Access 2010 New Features.
Access 2010 has a new macro technique called data Mmacros, which can trigger by…your data instead of your database objects.…You can now add logic macros directly to your tables and any dependent objects…will inherit the macro.…The macro is stored in the table instead of in the dependent objects.…This means, for example, that the action will get triggered automatically when…you're looking at a form or running a report instead of having to be…reprogrammed every time.…This allows you to take actions based on the data in your table.…Some examples include an inventory database, adding records to an order table if…an items quantity falls below a certain level.…
Sending thank you e- mails based on orders placed.…Popping up warnings if all required fields are not completed.…So, let's go take a look and see how this works.…We are going to open up our Employees table.…What we are going to do is the employees that go into this table either are in…the Purchasing department or the Marketing department.…Any time we put in the Purchasing department we want the Salary to automatically…
- 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.