How to use command button to select image and show it in an access form one after one

[kanchan]

in the attached form i can select multiple image but my next and back button does not work ,also i want the path to the file shown above.to copy the name from there and paste it in the table,to write remarks,Plz help me to over come the issues if possible.thanks.

 

[stumac]

You are not storing the image in a table - therefor for every image that is entered it just overwrites the previous...

Can there be multiple remarks per image or will there only ever be one?

If there can be multiple you need to have a second table for the images with a primary key that can link to foreign key in the table for remarks.

If not you need to at least add a field in to the current table to store the image/image path. (I have updated your example to show this... please use this as an example and not to overwrite your existing work).

 

[kanchan]

Thanks a lot,i thought the database would become heavy if i store the image path but may be it isn't. Moreover there will be multiple remarks per image and in the current table i want to add 2/3 fields like text box or combo, and later export the table in a excel work book for reporting purpose.i will try to work with your example and thanks again.