Make a database that each record shows a picture located in folders (paths)

[adonis2008]

Hi,
I have to write a Thesis, where my appendix has more than 1,000 pictures.
I am not an expert (little vb code, I understand). So, how can I make a mdb (Access 2003) with records that can show on reports images. The images will appear in each record (in the reports or forms) through paths. The paths will be text in one column (table), but without the full path (e.g. C:\..\), but only (...photos01\image.jpg). (Perhaps CurrentProject.Path is something that I have to use). However I dont have such an experience to do it. Could you please provide me with a code to copy paste it, and some steps to build this mdb.
Thank you.

[DLN]

You can create the table with the field type as a Hyperlink and use the Hyperlink to hold the link to the Image.

In the form you can create an image that is set to the field that is Hyperlinked and when it changes records on the form the image should change.

Is this what you were asking?

[adonis2008]

I did the first step, but in the picture properties (during form design) there is no active choice for data source. What did I miss?

[DLN]

Under Image properties there is there is Picture and it has the address.
C:\mypictures\image1.jpg

What you'll need to do is add some code to so then the record changes it uses the hyperlink address to update the location of the picture.