Solved

Microsot Access 2010 show imge in form

Posted on 2016-09-21
3
22 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
  • 2
3 Comments
 
LVL 19

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 19
ID: 41836580
it is 2 weeks without a response from the poster. An answer was given.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

770 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