• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

Show Image in Access 2010 Form

How can I show an image for each record in a form in MS Access2010
0
mcthomas00
Asked:
mcthomas00
  • 2
1 Solution
 
gozolietCommented:
Am on my phone but hopefully these quick points help, otherwise I can get more specifics in morning.

I am assuming you have a path to an image as part of the record. If you are storing the whole image in the database than the image control should work easily.

Here's a very straightforward tutorial on displaying an image using an unbound image frame and setting the path in code.
http://www.databasedev.co.uk/bound_image_form.html

In access 2007 and up you can also use an image control and set it to be bound to a field containing the full path to an image. This will work for continuous forms.

If your record is only storing the image filename and they are all in the same path, adjust your forms query to include a computed field like (where filename is the column storing the image file name)

Logolink: "\\server\share\imagefolder\" & [filename]

Then set the image control to be bound to the logo link field.

Hope this helps.
0
 
als315Commented:
Take a look at my article:
Images on continuous forms
0
 
mcthomas00Author Commented:
I've requested that this question be deleted for the following reason:

Time elapsed
0
 
mcthomas00Author Commented:
time elapse
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

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