Importing hundreds Pictures in table weekly basis as attachments

[wasim_sono]

HI



I am using MS-AccessI need to attache pictures (in hundreds) daily basis in my table having attachment field. Pictures have been taken through Hand held computers and saved with concerned meter no + other related information Like M268658502152017121650 in this first 8-characters (M2686585) are meter no. This meter no is stored in table already. I have to attach this picture in table with matching meter no. Actually first get meter no from picture name and then match it to related record and then attach it to concerned field programmatically.

[CJ_London]

Not a good idea to store that volume of pictures in a db - you will quickly run out of space.

Better to store in a designated folder and have the file name stored in the db as a text field. File name might be a combination of meterno (which you already have) and date - which can perhaps be determined from your related information. Looks like the next 8 digits are the date 02152017 (15th Feb 2017?)

[wasim_sono]

Actually this information is stored for printing of utility bill. Therefore every month we need to new pictures with reading and print on bill. If we store file name in the text field then how to pick the related pictures and print on bill?

[CJ_London]

you would use an image control.

Set the controlsource to something like

="C:\meterimages" & me.txtMeterNo & ".gif"

[wasim_sono]

I'm using Access 2013. When I select Image control it appends browse popup window for selecting pic. as I select picture it store by default for every record. I also put ="H:\Akmal Imtiaz\Hyderabad\Gr-IV_Feb-2017_Area 5878 Book 01_Part_1" & [me].[meter_no] & "jpeg" in control source of image control but still not found result.

[CJ_London]

if meterno is 123456 then this

="H:\Akmal Imtiaz\Hyderabad\Gr-IV_Feb-2017_Area 5878 Book 01_Part_1" & [me].[meter_no] & "jpeg"

will produce

H:\Akmal Imtiaz\Hyderabad\Gr-IV_Feb-2017_Area 5878 Book 01_Part_1123456jpeg

looks like you are missing a '.' - should be ".jpeg"

Also, check the file extension - can be ".jpg"

and perhaps a '_' before the meterno?

Also there is not usually square brackets around me

[CJ_London]

Here is a very simple db to explain

in the image control source, change "C:\Dev" to the name of the folder you put the images and you should get something like this when you run the report

edit: for some reason, when the post is saved, it is dropping the last backslash from C:\Dev.

[wasim_sono]

Thanks Ajax for giving your valuable comments.

I have solved my problem by applying "." in extension and change Jpeg with jpg.