Attachments in Access 2003 1

[Dausa67]

I have tried to find this by searching but I just don't understand.

I have a form using access 2003 that I need to be able to drag n drop emails and excel files into and be able to open from a record.

Example; I have a list of part numbers that are emailed to me. I want to be able to attach the email or excel document to the record in which I am tracking.

Is there an easy way to do this that any donkey such as myself could understand?

Clay

 

[MajP]

Not sure how automated you want this. If I have an OLE field, I just drag and drop the Excel document into it. If I have an email, I drag and drop it onto my desktop and then drag it into the form.

 

[Dausa67]

That is exactly what I want. I must have something wrong in my settings that will not allow me to do that.

My table settings are as follows:
Field Name = Comment
Data Type = OLE Oject

I have the control source set to comment.


Clay