Linking Pictures

H

holly

I have some 17,000 items in a form and I'm trying to get those items'
pictures to show on the form. How do I put the pathname in without the name
of the acutal picutre so that it suffices all the pictures' names. Meaning I
put the actual pathname for one item and it shows for all the items and not
just the one it refers to, how do I do that for all
 
D

Daniel

I'm not sure if I followed.

Let say all your images are stored in the c:\media\images" directory and you
have a naming convention which is the productid which is on your form. then
you use the oncurrent event to update the image to be displayed in your
control.


Me.ImageControlNameOnYourForm.Picture = "c:\media\images\ &
"Me.ProductID.Value

If I didn't understand the question properly please explain further and I'll
post back. you might also benefit form the following sample databases

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#images
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album
http://www.rogersaccesslibrary.com/download3.asp?SampleName=Pictures.mdb
http://www.rogersaccesslibrary.com/download3.asp?SampleName=PicturesLoad.mdb
 
Top