Access.2007.VBA.Bibl..

When you import data from an XML file, there is no option for specifying the name of the Access table; it will have the same nam ...

Case 1 HTML DoCmd.TransferText transfertype:=acImportHTML, _ TableName:=strTable, _ FileName:=strHTMLXMLFileAndPath, _ hasfieldn ...

XML File (frmExportHTMLXMLData) form will open (as shown in Figure 10.26). The form has From Date and To Date textboxes for spec ...

FIGURE 10.27 An exported HTML file opened in Internet Explorer. The code for clearing old data and inspecting the jobs to export ...

strOutputPath = GetOutputDocsPath() Select Case intFileType Case 1 HTML strFileName = “Jobs.htm” strFileNameAndPath = strOutputP ...

FIGURE 10.28 A security warning when opening an XML file in Windows Vista. If you select to allow blocked content, you’ll get an ...

FIGURE 10.30 An XML file opened in Internet Explorer. You can also open an XML file in Excel. After selecting it, you get an Ope ...

If you accept the default option of “As an XML table,” you’ll get the message shown in Figure 10.32. FIGURE 10.32 Creating an XM ...

Emailing Exported Text Files ............................................................................................ Once y ...

Check that at least one contact has been selected. If lst.ItemsSelected.Count = 0 Then MsgBox “Please select at least one contac ...

NextContact: Next varItem ErrorHandlerExit: Set appOutlook = Nothing Exit Sub ErrorHandler: Outlook is not running; open Outlook ...

F or a long time — really, since Office 97, when Outlook was introduced — I have wanted to write VBA code to synchronize Access ...

Creating a Denormalized Table from a Set of Linked Tables .............................................. There are situations wh ...

FIGURE 11.1 The Relationships diagram for the Synchronizing Contacts database. Because Outlook only supports a fixed number of a ...

FIGURE 11.2 Selecting a default phone number type on the Contact Information form. Of course, you will sometimes need to enter p ...

Figure 11.3 shows the Contact Addresses tab of the Contact Information form; unless you need to enter data for very wealthy peop ...

FIGURE 11.4 The Company Info tab of the Company and Contact Information form. Figure 11.5 shows the Contact Info tab, with a Con ...

FIGURE 11.5 The Contact Info tab of the Company and Contact Information form. The sample database’s main menu (shown in Figure 1 ...

FIGURE 11.6 The main menu of the Synchronizing Contacts database. The code for the Attachments Folder Path button (listed next) ...

If .Show = -1 Then txt.Value = CStr(fd.SelectedItems.Item(1)) Else Debug.Print “User pressed Cancel” End If End With On Error Re ...