Microsoft® Access® 2010 Inside Out

Sharing Data Macro Logic

The new Logic Designer in Access 2010 includes a very useful feature for sharing and reusing data macro logic. To illustrate this feature, open the tblTerminations table in Datasheet view in the Back Office Software System data copy sample web database (BOSSDataCopy.accdb). Next, click the Table contextual ribbon tab under Table Tools, and then click the After Insert button in the After Events group to open the Logic Designer. You’ve already explored the data macro logic attached to this table event earlier in this chapter. Press Ctrl+A to highlight all the logic on the macro design surface and then press Ctrl+C to copy all the logic to the Windows Clipboard. Now, open Notepad or a different text editor and then press ...