Access.2007.VBA.Bibl..

FIGURE 10.27

An exported HTML file opened in Internet Explorer.

The code for clearing old data and inspecting the jobs to export is similar to the code for other

export types; only the event procedure for the “Export Jobs to HTML/XML File” button is listed as

follows; it uses a Select Casestatement to export the data to either an HTML file (using the

TransferTextmethod) or an XML file, using the ExportXMLmethod of the Access

Application object:

Private Sub cmdExportJobs_Click()

On Error GoTo ErrorHandler

Dim intFileType As Integer

Dim strQuery As String

Dim strTitle As String

Dim strPrompt As String

Dim strOutputPath As String

Dim strFileName As String

Dim strFileNameAndPath As String

intFileType = Nz(Me![fraFileType].Value, 1)

strQuery = “qryFilteredJobs”

Working with External Data 10