asked on

DB linking pictures

I would like to create a program that reads records from an Access DB. When I type in a record (ie B&D Drill), I would like a picture of that record to pop-up in a picutre box. For example. I have my program running, I type in B&D Drill and then I hit enter and a picture of the record should populate the picture box. The picture files are kept in a separate folder. The name of the picture are the same name of the record (ie record name is B&D Drill and picture file is called B&D Drill.jpg).

Thanks

kiprimshot

asuming you use an image control
..

'put this kind of code in the necessary event

dim strPath as string
dim strImagePath as string

strPath = yourPath example: "\\SERVER1\"
strImagePath = yourPath & txtImage.text & ".jpg"
Me.image.Picture = strImagePath

kiprimshot

If you need to have it pop up you could set the visible property to true when you open it or use another little form and load the form.

ASKER CERTIFIED SOLUTION

bobbit31

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Richie_Simonetti

Do you know in advance which picture format is?
are All jpg, gif or bmp or something?

DanRollins

Hi VBNewbie,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:

Accept kiprimshot's comment(s) as an answer.

VBNewbie, if you think your question was not answered at all or if you need help, you can simply post a new comment here. Community Support moderators will follow up.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer

Richie_Simonetti

To me, split between kiprimshot and bobbit.
Cheers

DanRollins

Thanks for the input Richie_Simonetti,
My first thought was that both were the same answer, but I can see now that they cover two different scenarios. Recommended disposition:

split points between kiprimshot and bobbit31

DanRollins -- EE database cleanup volunteer

Netminder

Per recommendation, force-accepted.

Netminder
CS Moderator

kiprimshot: points for you at https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20328650