B
bekandcurt
I have a query with a text field containing the path of the picture
associated with a building. I adapted the VBA code from "How to display
images from a folder in a form, a report, or a data access page"
(http://support.microsoft.com/default.aspx?scid=kb;en-us;285820) to link the
picture an Image control in a report.
However, the picture for the first building in the report is the one listed
under "picture" property of the Image control (right now a placeholder that I
hoped would be replaced), and building #2 displays the picture of #1, #3
displays #2, and so on. I was able to fake it out in a test by shifting the
path up one line in the underlying table, and suppose I could do this for the
500+ buildings, but it doesn't seem like the smart way to go. Why would all
the linked photos be shifted by one record, and the place holder never go
away (I tried deleting the picture control, but that doesn't fix it), and how
do I get rid of the placeholder?
To make it even more perplexing, I have the path in a text control displayed
right below the pictures, and they indicate the right picture. I also have a
form based on the same query (adapting the VBA from same article), and it
works fine.
Thanks in advance for maybe keeping me sane!
associated with a building. I adapted the VBA code from "How to display
images from a folder in a form, a report, or a data access page"
(http://support.microsoft.com/default.aspx?scid=kb;en-us;285820) to link the
picture an Image control in a report.
However, the picture for the first building in the report is the one listed
under "picture" property of the Image control (right now a placeholder that I
hoped would be replaced), and building #2 displays the picture of #1, #3
displays #2, and so on. I was able to fake it out in a test by shifting the
path up one line in the underlying table, and suppose I could do this for the
500+ buildings, but it doesn't seem like the smart way to go. Why would all
the linked photos be shifted by one record, and the place holder never go
away (I tried deleting the picture control, but that doesn't fix it), and how
do I get rid of the placeholder?
To make it even more perplexing, I have the path in a text control displayed
right below the pictures, and they indicate the right picture. I also have a
form based on the same query (adapting the VBA from same article), and it
works fine.
Thanks in advance for maybe keeping me sane!