Could anyone advise how I can attach a file or email to a record on a form?

In A2007, create and a new field in the underlying table and select FieldType
Attachment. Put this filed on your form and click for the attachment
dialogue. This is a Multivalued Field and you will not be able to export the
contents to another DB.

For earlier versions, consider using hyperlinks and storing the attachments
outside the DB

"Marty" wrote:

> Could anyone advise how I can attach a file or email to a record on a form?

On Mon, 5 Nov 2007 15:55:00 -0800, Marty
<(E-Mail Removed)> wrote:

Access2007 has new support for attaching files to a record. You'd use
the new ACCDB format, and the Attachment data type.
No way to attach an email. Your next best choice may be to add the
body of the message to a memo field. If it is really important to have
the exact email with all its formatting and attachments, I would look
into keeping the email in Outlook/Exchange and storing a unique email
identifier so you can look it up again later.

-Tom.


>Could anyone advise how I can attach a file or email to a record on a form?

One way to attache email to the DB......

Select the e mail message.
Click File-Save as
Give it a name and select Outlook Message Format Save

Open the DB and attach the file
From here, when you open it will open in Outlook, looking like it did when
it arrived.

"Tom van Stiphout" wrote:

> On Mon, 5 Nov 2007 15:55:00 -0800, Marty
> <(E-Mail Removed)> wrote:
>
> Access2007 has new support for attaching files to a record. You'd use
> the new ACCDB format, and the Attachment data type.
> No way to attach an email. Your next best choice may be to add the
> body of the message to a memo field. If it is really important to have
> the exact email with all its formatting and attachments, I would look
> into keeping the email in Outlook/Exchange and storing a unique email
> identifier so you can look it up again later.
>
> -Tom.
>
>
> >Could anyone advise how I can attach a file or email to a record on a form?
>

Thank you. This will help.

"Tom Ventouris" wrote:

> In A2007, create and a new field in the underlying table and select FieldType
> Attachment. Put this filed on your form and click for the attachment
> dialogue. This is a Multivalued Field and you will not be able to export the
> contents to another DB.
>
> For earlier versions, consider using hyperlinks and storing the attachments
> outside the DB
>
> "Marty" wrote:
>
> > Could anyone advise how I can attach a file or email to a record on a form?

Thank you for your help!

"Tom Ventouris" wrote:

> In A2007, create and a new field in the underlying table and select FieldType
> Attachment. Put this filed on your form and click for the attachment
> dialogue. This is a Multivalued Field and you will not be able to export the
> contents to another DB.
>
> For earlier versions, consider using hyperlinks and storing the attachments
> outside the DB
>
> "Marty" wrote:
>
> > Could anyone advise how I can attach a file or email to a record on a form?