Results for:
Attachment

• Dashboard graphics in forms and reports

  8 Jan 2010

  Mike Alexander, Excel MVP recently sent us a pointer to a blog post with some cool ideas to spice up your application with data visualizations . Here is a quick sample: Mike didn’t mention attachments in his post but the attachment control works really well for storing images. I have a similar technique...
• Adding multiple attachments from a folder

  31 Jul 2008

  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...
• Adding Attachments from a Folder

  25 Jul 2008

  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 post it more broadly. This code accepts parameters...
• Using VBA code to open a file stored in the new Access 2007 Attachment field

  30 Aug 2007

  Someone asked me about using the Attachment data type in Access 2007 for a specific task. They wanted to use it as a simple data type where it would only be used to hold 1 file per record, and they wanted to be able to open the file in an external application using a button on a form instead of using...
• Adding, removing, and saving files from the new Attachment field in Access 2007

  24 Aug 2007

  One of the coolest new features in Access 2007 is the new Attachments data type. There are some very helpful dialogs for working with this data type, but there are also some useful additions to DAO to make automating the process of adding and saving attachments easy, too. What follows is some VBA code...