Grabbing images from folder based on filename

[Sirhceth]

I hope my wording makes sense...



Basically I have a form which grabs data from a table. Included are 5 bounded object frames that come from 5 image fields in the table. The fields are filled with the file names and not the full directory... for example: c:\temp_pics\1234.jpg would be listed as 1234.jpg.

Is there a way to use these fields to grab an image from a folder that will have all pictures mentioned in a said database?

Thanks,

Sirhceth

[June7]

I use Image control to dynamically display images. Set the ControlSource property to the field with the image path/name. If the data is only the name, the path can be supplied by concatenation of literal text:

="c:\temp_pics\" & [fieldname]

[ItsMe]

Is there a way to use these fields to grab an image from a folder that will have all pictures mentioned in a said database?

Not sure what grabbing an image is, exactly. You will need the full path in order to do anything with a file. I will store file names in their own column. That is a common thing to do. You can use code to concatenate the file name to a known directory and grab the file.

Dim strPath as string
dim strFileName as string

strPath = "c:\temp_pics\"
strfileName = Me.NameOfControl.Value

Application.FollowHyperlink strpath & strfilename