Access.2007.VBA.Bibl..

FIGURE 11.7 Selecting a form for comparing Access and Outlook contacts. When you select one of these forms to open, a message bo ...

FIGURE 11.9 An Outlook Select Folder dialog for selecting the Contacts folder for synchronizing. Re-creating the Flat-file Table ...

Use the following section of code to allow selection of a custom Contacts folder from the Folder Picker dialog. SelectContactFol ...

rstTarget![BusinessAddressStreet] = Nz(.BusinessAddressStreet) rstTarget![BusinessAddressPostOfficeBox] = Nz(.BusinessAddressP ...

rstTarget![CompanyMainTelephoneNumber] = _ Nz(.CompanyMainTelephoneNumber) rstTarget![HomeFaxNumber] = _ Nz(.HomeFaxNumber) rstT ...

Nz(.Email3DisplayName) rstTarget![GovernmentIDNumber] = _ Nz(.GovernmentIDNumber) rstTarget![Hobby] = Nz(.Hobby) rstTarget![Mana ...

If you always synchronize your Access contacts to the same Outlook folder, you can comment out the SelectContactFoldercode segme ...

rstTarget.AddNew rstTarget![CustomerID] = Nz(rstSource!CustomerID) strTargetCustomerID = rstTarget![CustomerID] rstTarget![Compa ...

The next source object is qryContactIDsPhones(see Figure 11.10). It has only two fields, so to match the many phone and ID field ...

rstTarget![BusinessFaxNumber] = Nz(rstSource!BusinessFaxNumber) rstTarget![BusinessTelephoneNumber] = Nz(rstSource!BusinessTel ...

NextSourceRecord1: rstSource.MoveNext Loop rstSource.Close Company phones and IDs are handled similarly; only one possible value ...

FIGURE 11.11 A calculated query field that converts StreetAddress to BusinessAddressStreet. The rstSource recordset is then sele ...

rstTarget![HomeAddressStreet] = _ Nz(rstSource!HomeAddressStreet) rstTarget![HomeAddressPostOfficeBox] = _ Nz(rstSource!HomeAddr ...

The two tables (tblOutlookContacts and tblAccessContacts) have matching fields; they are displayed in subforms on the two forms ...

FIGURE 11.13 A form that compares Outlook and Access contacts by name. Copying Contact Data from Access to Outlook (or Vice Vers ...

FIGURE 11.14 Selecting a contact by Contact ID. TABLE 11.1 Contact Match Status and Actions to Select Contact Status Available A ...

To copy data in one field, rather than updating an entire contact record, select either “Access to Outlook” or “Outlook to Acces ...

You can use the following lines to export to the default local Contacts folder, or a hard-coded folder of your choice. To use th ...

& strFirstName & Chr$(39) _ & “ And [LastName] = “ & Chr$(39) _ & strLastName & Chr$(39) ‘Debug.Print “S ...

con.CompanyName = Nz(rstSource![CompanyName]) con.Department = Nz(rstSource![Department]) con.JobTitle = Nz(rstSource![JobTitle] ...