Solved

Microsot Access 2010 show imge in form

Posted on 2016-09-21
3
29 Views
Last Modified: 2016-10-10
Can anyone help me out I doing a Stationery database with photos are save in a folder on the C:\ drive.  what I am trying to do when someone pick item number red pen item number is 63987 then the photo will show up in the object frame, the photos are save as the item number as a bmp. can any one help
0
Comment
Question by:Darren Hughes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 21

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 250 total points (awarded by participants)
ID: 41809228
use an Image control. Access Image Control
Store filename in Access and set ControlSource of the Image to:
="C:\path\" & [ImgFilename]

WHERE
"C:\path\" is the path to the files
ImgFilename is a field in the table with the name of the file, including file extension

 -- alternately, you can construct the filename from your item#
       ="C:\path\" & [ItemNumber_Fieldname] & ".bmp"

Open in new window

1
 
LVL 19

Assisted Solution

by:Eric Sherman
Eric Sherman earned 250 total points (awarded by participants)
ID: 41809418
Also, where do they pick the Item Number from ... is this a listbox or combobox, etc.???

Then you would use the AfterUpdate Event of your control to change the path to your image in the Image Control on your Form Object.

ET
0
 
LVL 21
ID: 41836580
it is 2 weeks without a response from the poster. An answer was given.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question