Saving Attachments in Access Forms

[Hinfer]

Hi everyone,

I am a new Access user, and don't really know how to move about the application. Is there any way to save attachments (documents, e-mail, business approvals) in an Access form? They would need to be retrieved for later use. If yes, how would I go about doing that?

Thanks,

Silvia

 

[rdeleon]

I'm not sure about the emails, but I have stored the document name and target directory rather than the documents themselves.

Just my two cents.

Rene'

 

[luceze]

You might take a look at OLE. You can link files or embed them in your tables (embedding takes up a lot of space) for later retrieval.

HTH,
Eric

 

[nberryman]

Try a Hyperlink ?



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[red54]

I've done it both ways. To put an actual copy into ole control on your form you'll have to paste it into there. One client is using Adobe Reader 5.0, and Macro Scheduler (from Adobe) to semi-automate the process. Not satisfied with the procedure, and file is HUGE. Reason I'm on Tek-Tips today as a matter of fact.

Using name and path to object makes for a great number of files on your system (if you are going to be putting a large number of docs on).

So it depends on how many docs you are going to do. If it is a small amount I'd use scan, copy to clipboard and paste into ole control. Large amount I'd put the objects on another drive(back up regularly) and put link to them in database.

Time flies when you don't know what you're doing...

 

[SilFaz]

Thanks everyone, I really appreciate the feedback!!!!

Silvia