Linking Pictures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

holly - 04 May 2007 18:57 GMT

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

Reply to this Message

Daniel - 04 May 2007 22:20 GMT

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

Signature

Hope this helps,

Daniel P

> 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

Reply to this Message