Automatically add images to access database by looking up file names specified inside

[hassan.tajdar]

Hi Everyone,

I have a database where in column 1 the "material numbers" are given for which I want to attach images in the database. All the images that I want to add are stored in one folder location on my pc from where I have to add them manually as attachments into the database. Since I am going to be doing this on a regular basis I was looking for some help in writing a VBA script for looking up file names from Column 1 and adding them as attachments. The image files are named according to the corresponding "material numbers".



So if in column 1 i have an entry 123456, then the image file also has the name 123456.

[ranman256]

Rather than add the image to the db, I have code to just display the image.
1. it builds the path dynamically based on the ID 123456
2. it keeps the db small by not filling it up with images that already exist outside the db

any interest in this?

[June7]

Attachment field is a type of multi-value field. VBA code opens parent and child recordsets. Review https://msdn.microsoft.com/en-us/lib...ffice.12).aspx

But as ranman stated, embedded files, especially images, can really chew up 2GB Access file size limit. Suggest using ControlSource property of Image Control to dynamically load images from external folder location. An expression in ControlSource can be like: ="C:\foldername\" & [fieldname] & ".pdf"

[hassan.tajdar]

Rather than add the image to the db, I have code to just display the image.
1. it builds the path dynamically based on the ID 123456
2. it keeps the db small by not filling it up with images that already exist outside the db

any interest in this?

Yes please! If you can also tell me where to insert the code (as in create a new module for VB code?) it would be quite helpful!