Microsoft Access 2013 Inside Out

Sharing data macro logic

The Logic Designer in Access includes a very useful feature for sharing and reusing data macro logic. To illustrate this feature, open the tblTerminations table in the Back Office Software System data copy sample web app (BOSSDataCopy.app) in Design view. Next, click the On Insert button in the 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 the logic to the Windows Clipboard. Now open Notepad (or a different text editor), and then press Ctrl+V to paste all the logic into Notepad.

As you can see in Figure 4-71, Access copies the data ...