Search a folder then add Image

[Daryl M via AccessMonster.com]

Hey folks,

I've read again and again NOT to add an image in an OLE field. Not a problem.
I got it.

My JPEGS are on the same disk as the database. This database is for a bunch
of comic books I acquired after an eviction. I have a form that displays the
appropriate info for any particular comic and it has an image control that
displays the cover via the oncurrent event. Works GREAT. The underlaying
table has the fields: ImagePath, and ImageNam.

Problem is, I need a form very similar to this one for data entry. I would
like to double click or right click on the image control open the folder with
the images, choose an image by say double clicking and Viola, access will add
the name of the selected photo to tblComic.ImageNam.

Any suggestions greatly appreciated.

 

[Wayne Morgan]

You can use the code example found here
http://www.mvps.org/access/api/api0001.htm to browse for the picture file
and return its path and name so that you can store those in the database
field.