What are these?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark A. Sam - 16 Nov 2007 20:09 GMT

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

Reply to this Message

Allen Browne - 17 Nov 2007 01:10 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I have an attachment field named Documents, in a table. On the field list
> of the form it shows Documents and three other objects,
[quoted text clipped - 12 lines]
>
> Mark A. Sam

Reply to this Message

Jordan Millns - 17 Nov 2007 21:26 GMT

Thats A Tricky One

Reply to this Message