• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • 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
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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