Access.2007.VBA.Bibl..

End Select

ErrorHandlerExit:

Exit Sub

ErrorHandler:

MsgBox “Error No: “ & Err.Number _

& “; Description: “ & Err.Description

Resume ErrorHandlerExit

End Sub

Exporting Text Data ......................................................................................

When exporting data to text files (say, for import into a mainframe computer program, or another

application that can import data from comma-delimited or fixed-width text files), often you need

to filter the data, usually by date. The Export Job Data to Text File (frmExportTextData) form has

two textboxes bound to Date fields that you can use to select dates for a date range used to filter

the records to be exported to a text file.

Controls bound to Date fields on an Access 2007 form have a long-awaited feature

shown in Figure 10.15: a pop-up calendar to make it easy to select a date.

FIGURE 10.15

The Export Job Data to Text File form, with a pop-up date selector.

NEW FEATURENEW FEATURE

Part II Writing VBA Code to Exchange Data between Office Components