Change Image on Form with Access 2007

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Malmorcan

Thread Starter
Joined
Aug 27, 2003
Messages
20
I have made a number of solid databases, but this is a particular challenge that no amount of searching has been able to help me with:

I want to display an image on a form depending on the selected record. I have read that I need to use an image control, or an unbound image control or something. I cannot for the life of me figure out what this is, or how to make it work.

I've got a table of paths using text fields, but on the form I don't know how to make them display as images. I've tried using the Unbound Object Frame control, but it always prompts me for a link, and doesn't work.

I've read that this can be done in Access 2007 without any coding necessary, but have yet to find an explanation that can actually take me from step A to step B (though all the C to D steps are out there).

Can anyone help? I apparently need stupid person instruction here. :/
 

OBP

Joined
Mar 8, 2005
Messages
19,895
I don't know how to do it Access 2007 without VB Code. But I have created plenty of databases working in older Versions that do it with simple vba code and I do mean pretty simple.
I can point you to a couple that I posted on this Forum if you want to see them.
 
Joined
Oct 6, 2008
Messages
1
Assuming the picture is specific to the record, could you not use an attachment field in the underlyiing table? Provided that the field Display property is set to image / icon, the form view will display the picture when the record is selected . At least it does in mine...
 
Joined
Apr 7, 2007
Messages
439
As OBP noted, you should be able to do this with a little bit of simple VBA.
 

Malmorcan

Thread Starter
Joined
Aug 27, 2003
Messages
20
Thanks for the replies, but I think I failed to really get across just how much I'm missing that initial step.

So, the fields I have are attachment fields, and they have pictures associated to them. If I create a form from the table with the wizard, I can see the pictures no problem. But, it's adding a control to another form to display the picture that I'm having a problem with. No matter what control I add to the form, it either doesn't work at all, or it just displays the link text, not the picture. I don't have the Display property as an option on any of the controls. I've tried cutting and pasting the picture field from the working form to my lookup form, but it doesn't work.

I've done some cutting and pasting of VBA code in the past, and I've gone through several examples online that show me how to do it in access 2003 or lower, but I've yet to get the code to work in 2007, which is why I was hoping to do it without using the code which is suppossedly doable. :/
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top