Download all files from attachment field.

[chrisfl]

I had the bright idea of creating an Attachment field for each record in my database so that the source material for the record (usually a PDF) could be opened and reviewed easily. A few people have asked me not only for the data but copies of the source files as well - is there a way to export attachments from every field into a directory instead of going one-by-one?



Thanks!

[June7]

Review http://blogs.office.com/b/microsoft-...cess-2007.aspx

EDIT: that link appears to have gone bad, which is unfortunate because the code samples were terrific

[ItsMe]

I have a sample DB that implements the code June linked to if you are having troubles.

[chrisfl]

I have a sample DB that implements the code June linked to if you are having troubles.

That would be awesome. Thanks to you as well, June - I was afraid the answer would be totally over my head.

[ItsMe]

The sample is a little confusing at first blush. I created it to help another member in another thread and it requires interaction that suits their original need.

The idea is you create a record by:

• Type some text into a field in the startup form to create a new record
• Click the file picker and select a file on your computer
• Click the other control button to attach the selected file to the record you just created

You can create more records and attach additional files by navigating to a new record and repeating the process.

Once you have the table populated with attachments you can remove the attachments using the other form, "frmExpAttachment"

The form is bound to the table (so is the first form) and will display the records you added in single form view. Navigate to the record you desire and remove the attachment using the control buttons provided. There is some code in the click event of "cmdRetrieve", that is commented out, that can delete the attachment if you wish.