Access.2007.VBA.Bibl..

FIGURE 9.19 A folder with some Contact ID documents, for creating attachments. In the LoadAttachmentsfunction listed as follows, ...

Extract Contact ID from file name, using Midand InStrfunctions to start at the beginning of the number and end before the space ...

End If NextDoc: Next fil Open the Contacts form to see the attachments that have been loaded. DoCmd.OpenForm FormName:=”frmConta ...

collection of a record and saves each one to a file in the Output Documents folder selected on the main menu: Public Function Sa ...

ErrorHandlerExit: Exit Function ErrorHandler: MsgBox “Error No: “ & Err.Number _ & “; Description: “ & Err.Descripti ...

I n the previous chapter, you learned how to work with text files, using one old method and two new ones. For some types of text ...

These days, it is not likely that you would want to export Access data to a Lotus spreadsheet or a dBASE database, but there is ...

FIGURE 10.2 Selecting a text file to import. After selecting the file, clicking OK on the Get External Data - Text File dialog ...

Clicking Next brings up a screen where you can adjust the column widths, as shown in Figure 10.4. FIGURE 10.4 Adjusting column ...

FIGURE 10.5 Specifying field names for an imported text file. FIGURE 10.6 Primary key choices for an imported text file. Working ...

You have now supplied all the information needed to set up the specification; the next steps, where you save the specification, ...

FIGURE 10.8 The Manage Data Tasks dialog, where you can select a saved import or export specification. Sometimes the wizard does ...

Importing and Exporting Text File Data in VBA Code.............................................. The main menu of the sample app ...

FIGURE 10.11 The Import Job Data from Text File form, as initially opened. FIGURE 10.12 Selecting a comma-delimited text file fo ...

After selecting a text file, click the “Inspect New Jobs from Text File” button to import data from the text file to a temporar ...

FIGURE 10.14 An append query that does some data type conversion before appending the newly imported jobs to the main tblJobs ta ...

The “Inspect New Jobs from Text File” command button’s event procedure first checks that a text file has been selected and then ...

Application.CurrentProject.ImportExportSpecifications(strSpec). Execute ‘Old style syntax causes error ‘DoCmd.TransferText trans ...

The “Source Text File” command button’s event procedure opens a File Picker dialog for selecting a text file for importing, filt ...

ErrorHandler: MsgBox “Error No: “ & Err.Number _ & “; Description: “ & Err.Description Resume ErrorHandlerExit End S ...