You could assign the path to the image control using the After Update event
of a combo, but I am puzzled as to why it is not working. I see you are
using 07. I have not used 07 yet, so I don't know of any differences between
that and 03.
I really don't have any other ideas. What kind of image control are you using?
--
Dave Hargis, MicrosoftAccessMVP
:
Assuming you have the path and name of the image for each recordin your
form's recordset, you can use the Form Current event to change the path to
the image.
--
Dave Hargis, MicrosoftAccessMVP
:
I have tried following several (what seem to be obviously simple) ways
to display dynamic images on my form that will change as the records
are changed, but NOTHING seems to work. I have a form designedthat
has interlocked combo boxes (change any one, and the rest change to
matching info.). Operating in A07, I have tried using 07 procedures
(followingMShelp files over and over again) and "previous version"
ways (spending days going to all of these sites that are suggested).
The form likes to occasionally display one picture for all records, so
obviously we are just speaking the wrong language, but I am beginning
to run out of hair to pull out. Who can give me the straight scoop on
making these pics work?- Hide quoted text -
- Show quoted text -
Hey Klatuu, Thanks for taking the time to reply.
OK, tried that... and
Also placed code in the AfterUpdate event of the image, the image
control, the form itself, in the OnLoad event of the form, the OnDirty
event of each of the combo boxes, as well as the AfterUpdate events of
each [and ALL] of the combo boxes separately and combined. I've tried
using Image Control insertion, OLE (although I'm trying to avoid using
that), and Attachments. Nothing is working. I have been at this one
issue for about 2 weeks now, and am almost convinced that the software
needs to be reinstalled or something. I've even tried saving the
entire db in "non-SQL Server compatibility" just in case the tags were
causing the problem. Right now I have stepped back from it to research
a bit. Currently I have it configured with the full path and file name
in the text field of the record source table, the image control
inserted into the form (that displays only the same picture) and the
field name (containing the path and file name) in the control source
of the image control. I have removed any VBA code from ALL events and
have considered drinking heavily. Where else can I look for any
resolution?- Hide quoted text -
- Show quoted text -
Hey, Klatuu... Thanks again.
I would imagine the default image controller(s) which installed with
A07 are the ones being used.... I took a look at my References tool
and nothing is marked as "missing" or anything else unusual. I'm not
receiving any error messages, etc. Seems like all of the .dll files
are loading.
Is there some way to link the image control to ALL of the combo boxes?
That way if any of them changes (either by direct selection, or
incidental selection from one of the other boxes) the action will
cause the image to update to the current record being displayed....
I'm certain that's what the OnCurrent/AfterUpdate functions are
supposed to dowhataya think?
Are you using a simple image control (as opposed to bound or unbound
object frame)?
Are you putting the path for the image file in the Picture property of
the image control?
That should be all you need to do.
I'm not sure, from what you say, where the path is actually coming
from.
If the path is in a field of the record behind the form, set the
Picture property to the field in the Form_Current event.
Or if the path comes from the combobox, set the Picture property in
the combobox' AfterUpdate event to the column of the combobox where
the path is stored.
If you do that, what happens exactly?
--David Stelle, Access App developer- Hide quoted text -
- Show quoted text -
Thanks Klatuu and David for your responses....
Here's the way I have it set up and the things I have tried to this
point. This is kinda drawn out, so bare with me.
Form setup is a set of combo boxes that contain related selections for
an inventory. One contains Local Part numbers, another is matching
Vendor Part numbers, another is matching Tag numbers, another is the
Part Name, etc. There are about 9 combo boxes on the form all tied to
eachother, meaning that if any combo box is selected and an item
changed, the remaining boxes update to show the corresponding
information for that part. They are all tied using the SELECT
DISTINCTROW feature in their row sources with the same control source
(in this case the local Part Number). I'm sure that sounds ok so far.
What I would like to do is add an image for each part that updates
with the selections made on the form (regardless of which one). I only
have one image for each part. The record source table contains a text
field called Image with the entire path/image name in the field (I
have also tried placing just the image name in the field, adjusting
the VBA code for the difference. All of my images are JPEG, in
greyscale (no color).
I have tried using a basic Image Handler/Controller on the form (both
Bound and Unbound), I have tried using Attachments and OLE objects
(Bound and Unbound), I have tried using VBA (ie, Me!
[ImageName].Picture = Me![Image].Value where ImageName is the img
control and Image is the field of the background table, using both the
"!" and just the "."). I have tried different code variations based on
several suggestions and examples in the Form_Current (OnCurrent) event
of the form, in the OnLoad event for the form, in the AfterUpdate
event of the form and the img control, in the AfterUpdate event of the
different combo boxes. Per your suggestion, I placed the path to the
file in the Picture property box - nothing.... I placed the Picture
property in the OnCurrent event of the form in both the property box -
Access errored on an improper macro, and in VBA code - nothing. As far
as the "path coming from the combo box and setting the Picture
property in its AfterUpdate event to the column of the combo box where
the path is stored" I'm not sure I follow you. If you could walk me
through it, I'd be all too happy to give that a try. If you're merely
saying place the imagepath (or the field containing the imagepath) in
the combo box AfterUpdate event, then, I tried that and nothing
happened. Right now, I have removed all VBA code concerningn images.
My control source is the Image field of the background table. I have
no Picture property for the basic (unbound) image control still on the
form. I have removed all OnCurrent and AfterUpdate events for the form
and image control.
Here's what happens. When I open the form sometimes, it displays one
picture for all records (and it happens to be the picture I made that
shows "No Image Available". How ironic is that?). Other times I can
get a different picture to show up, but again only for all records. I
can't get the images to change with their matching records. I have
never inserted the "No Image Available" picture into the form, so I
don't know how the form knows where to find it, but it does. Besides
the path of the image which still exists in the record source table.
That's about it. I'm have heard that in Access 2007, all you need to
do is insert a bound image control on the form and have the field of
the record table point to the image controls record source and Access
handles the rest, but it doesn't seem to be working that way. My next
thought was to check relationships and object depencies, but I think I
may be stretching a bit. Let me know what you think. And thanks again.
