Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 145
  • Last Modified:

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
0
VBNewbie
Asked:
VBNewbie
  • 2
  • 2
  • 2
  • +2
1 Solution
 
kiprimshotCommented:
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
0
 
kiprimshotCommented:
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.
0
 
bobbit31Commented:
if you are using a picture box do:

picture1.picture = loadpicture ("<path to image>")
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Richie_SimonettiIT OperationsCommented:
Do you know in advance which picture format is?
are All jpg, gif or bmp or something?
0
 
DanRollinsCommented:
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
0
 
Richie_SimonettiIT OperationsCommented:
To me, split between kiprimshot and bobbit.
Cheers
0
 
DanRollinsCommented:
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
0
 
NetminderCommented:
Per recommendation, force-accepted.

Netminder
CS Moderator

kiprimshot: points for you at http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20328650
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now