Access 2007 Create and use attachment fields

Access2007 additional fields are used to store multiple files in a single field, and the data types of these files can be different.

First, add and set additional fields

The fields that create the attachment data type are the same as those used to create other data types and fields. The following are the main ways to use additional fields.

Example 1 in the Northwind database, in the Products table, add a Product information field and set it to the attachment data type. Then, in the Product Information field, add a quality report (Word document) about product information, and a picture of the product. Action steps are as follows:

(1) Open the Northwind database, and then open the Products table.

(2) Click the Design view icon in the lower-right corner of the Products table to open the Design view for the Products table.

(3) In Design view, add a product information field, and then set the data type of the field to "attachment," as shown in Figure 1.

(4) Click the Datasheet view icon in the lower-right corner of the Products table to open Datasheet view of the Products table.

Displays the symbol for the field caption in the attached field, which is used to represent the attachment data type. Displays a (0) symbol in the cell of the field value, which indicates that the attachment is empty.

(5) Double-click the Attachment field of the first record to open the Attachment dialog box and click the Add button, as shown in Figure 2.

Figure 1 Design view of the Products table

Figure 2 Adding an attachment

(6) In the Open Select File dialog box, select the quality report, and then click the Open button.

(7) When you return to the "Attach" dialog box, the added file appears in the dialog box.

(8) Use the same method to add the picture folder of the product to the "Attachments" dialog box.

(9) Click "OK" button to add the attachment complete. In Datasheet view, the field value cell displays (2), indicating that two files are attached to the field.

Ii. display of information in the Annex

The information contained in the attachment cannot be displayed explicitly in Datasheet view, only in Form view.

(1) Open the "Products" form, you can see the product attachment information, then the field name "Product Information" is also correctly displayed.

(2) If you want to see other files in the attachment, right-click the attachment, select Forward on the Open shortcut menu, and then display the next file information attached in the Product information field.

Note: Only icons can be displayed for type information such as documents, spreadsheets, and so on.

Display the next file information you can also use a shortcut, and when you click the attachment control, a color gradient toolbar appears at the top left of the attachment, and the next attached file information is displayed in the toolbar by clicking the Green button.

Iii. Deletion and modification of annexes

There are two ways to delete and modify attachments, one in Datasheet view and the other in Form view. They are the same way of doing things. Action steps are as follows:

(1) In Form view, right-click the attachment, and on the Open shortcut menu, click Manage Attachments.

(2) In the Open Attachment dialog box, select the attachment, and then click the Delete button, you can delete the attachment.

Original: http://www.officeba.com.cn/article/htmldata/detail/2007/11/21/1503.html