inserting images with relevant code

[90405]

I would appreciate the best method to input images corresponding to unique images.

Product name:
Product code:

Each product code, has 3 images
1 image in GIf
2 image in Jpeg

If I establish a table with fields:

Product name
Product code
Image name (format) xxxxxx.gif or xxxxxx.jpeg
Image code

How do I get it to equate the correct image to the correct product name and code?

Preferably I would like to do this with hyperlinks and not stick the image directly into the Access database.

based on my understanding:
a) I have to create a folder and stick the images into it
b) stick hyperlinks into Excel and link this to Access table

I need a method where hundreds of these images will be processed.

thanking you in advance

 

[The_Doc_Man]

I have a digital photo DB where the only thing I store in the database is the name/path of the photo file. On the form, when I execute the Form_Current event, I add a line of code to copy the file name to the .image property (I think that's the right property) of the unbound image control on the form.

Works like a champ. Not even a hyperlink and it is easy code, too. Just load the file text to a property. You could put in an error trap or test the length of the string or do a FileFind on the string as a sanity check. Dozens of possibilities apply to this one.