Using Access 2013 with Images

[apchampa]

I want a form in Access 2013 to be able to add/remove and view images. This is for an inventory database. Each item may have 1 image or 10 images. I'm assuming the best way to store the images is outside of Access and in folders then have Access link to the images (assumption). If I do this, what is the best method for the user to be able to select on the form and find the images that need to be associated with the item? Can I display the images or thumbnails of the images on the form so someone can see all the item info with the images? I would appreciate getting pointed in the right direction. Thanks...

[June7]

If images stored externally, save image name (with or without full path and file extension) in a field in related table. Bind an Image control to the field and all images will be displayed. If the field has only the image filename without extension, the full path can be concatenated by expression in ControlSource property, like:

="C:\MyImages\" & [fieldname] & ".jpg"

[apchampa]

Let me clarify........ I would like the user to be able to select a record and then have a "Browse" button to select the image(s) related to that record and then these image(s) will be associated with the record going forward. The image files can remain stored in a local folder or they can be imported into the DB, either way would work. I'm playing around now to see how I can do this. Any help is appreciated. Thanks.

[June7]

Options:

1. attachment field and store image in table, use the attachment field dialog to navigate to image file location and imbed into field

2. store image name in text field, use FileDialog to open file navigator for user to find the file and grab the full file path or just file name https://msdn.microsoft.com/en-us/lib...ffice.11).aspx