What are these?

[Mark A. Sam]

Hello,

I have an attachment field named Documents, in a table. On the field list
of the form it shows Documents and three other objects, Documents.FileData,
Documents.FileName, and Documents.FileType.

When I dragged them onto the form, Documents.FileData is identified as an
Attachment, with a ControlSource as Documents.FileData. Documents.FileName
and Documents.FileType as textboxes with ControlsSource properties of the
same name. They display on the ControlSource list but when I open the form
(actually subform), the textboxes display a #Name? error and the attachment
displays nothing.

I am just wondering if they can be utilized somehow.

Thank you and God Bless,

Mark A. Sam

 

[Allen Browne]

Hi Mark

If you create a query using your table, you will see that the FileData,
FileName and FileType are available in the table in the upper pane of query
design. If you drag show the attachment field's FileType in the grid, it
will display JPG or DOC or whatever type it is.

Note that this has the side effect of showing a record multiple times. For
example, if you have 3 attachments for a record, the record appears on 3
rows.

You can programmatically manipulate the attachments if needed.