I have what I hope is a simple problem to solve in Access 2000.
I have a database that I would like to display images in. (I recently deleted all the images out of the database becuase it was getting too big).
Each record has a record ID, and all the images I want to display are stored in C:\valuations\
Not every record has an image, but all the images follow a naming format of <record ID Number>.jpg
So record 1234 has an image 1234.jpg
Is there some way I can link the image to the record to display it on the form and in the report (one record per report).
There are two outcomes I would like...
1) To be able to set up a default path to the file for each record so I dont have to manually link each file to each record. If the image is present it will automatically load.
2) To only have the image location/path stored in the database and to have it load 'as required' for viewing and printing purposes (i.e. not stored in the database).
I am a bit of an Access know-nothing so some detail would be appreciated.