Access.2007.VBA.Bibl..

(John Hannent) #1
FIGURE 11.13
A form that compares Outlook and Access contacts by name.

Copying Contact Data from Access to Outlook (or Vice Versa) ................................


The Select Contact combo box at the top left lets you select a contact, sorted by Contact ID.
Figure 11.14 shows the combo box with its list dropped down.

The Select Action combo box on the right side of the header of the form shown in Figure 11.11
offers a different set of choices, depending on whether the Outlook and Access contacts are identi-
cal, different, or one is missing, as shown in Table 11.1.

Part II Writing VBA Code to Exchange Data between Office Components

Free download pdf