Browse by Tags

• Access 2007
• Code
• Engine
• Reference
• Reference Code
• Table

Adding multiple attachments from a folder
31 July 08 02:55 PM

Rob Cooper recently made a post, Adding Attachments from a Folder, which shows how to add a single attachment file per row. But what if you wanted to add more than one file? One (highly contrived) scenario would be to add all of the files in a folder to one row, and do so recursively if requested, similar to Rob's example. What follows is some VBA code to do this, which borrows a bit from Rob's post and a bit from one of my earlier posts. However, I should point out this (again, highly contrived scenario) is meant only as an example and not something I would recommend doing, because if you are adding more than just a few files you can (ok, WILL) bloat your database very quickly, and in doing so can negatively impact performance and potentially hit the two gigabyte file size limit very quickly (see Access 2007 Specifications for details on database file size and object limitations). Read More...

Postedby James K. Rivera | 10 Comments    

Filed under: Access 2007, Engine, Reference, Attachment, Code, Reference Code

Adding Attachments from a Folder
25 July 08 07:40 PM

Someone asked us yesterday how to add all of the .jpg files from a folder into an Attachment field in a table. In this case, the individual wanted to add one attachment into a new record in the table. This could be pretty useful, so we thought we would Read More...

Postedby robcooper | 7 Comments    

Filed under: Access 2007, Table, Attachment, Code