How do I store, and display Photoggraphs in access

[PatrickRagan]

I am trying to build an access dbase to be used on a charitable research project, counting fish in the South China Sea, and need to be able to store photos for identification purposes in my Access database. The idea being that the researcher(s) can return from; either a diving trip, or fishing trip, and look at the dbase and say “oh that’s the cleaner fish I just saw and there was 100 of them” then enter into the relevant field the number, size etc., or even say this is a new fish here is the photo.

 

[dodgyone]

Firstly, I wouldn't just store the photogrpahs into the database has this rapidly makes it increase in size. This can cause problems:

[1]
I would create a directory out of the database for the images. Place the images in here and name each one after the fish etc.

[2]
Create a field in your table called 'fishname'... or whatever you want to call it. In this field you add the name used for the image of the fish.

[3]
On the form create an image control to be used to display the image.

[4]

Add this code the the form 'On Load event:

imagecontrol.picture = "C:\Fish\" & fishname & ".jpeg"

[5]
Add this code to the form 'On Current'

Call Form_Load

This will change the image as the record changes.

This should solve the problem for ya... shout for help if unsure