Access 2010 - Products Report with Images

kjbowser · 2014-12-10T12:47:08.000Z

I have a hit roadblock in trying to produce a report for our Product Development Team. They have an Access database of products and their specifications. One of the fields of the items table is a reference to the item’s image.

\server\share\folder\filename.jpg

I have created a form based on a query that displays a subset of items one at a time and that works great when the Default View is set to Single Form. When I switch the property to Continuous Forms, every item in the subset has the same image, that of the first item in the subset. Similarly, printing the form gives me the same image on every item.

I do not wish to embed the image as an OLE Object because this database is going to grow very large. Any suggestions will be greatly appreciated.

rockn · 2014-12-10T14:06:49.000Z

Is it only the image that repeats or are all of the records with descriptions, etc. the same as well?

kjbowser · 2014-12-10T14:08:02.000Z

Only the image.

rockn · 2014-12-10T14:19:12.000Z

What sort of control are you using to display the images? It looks like it needs to be set to an unbound image control and set the control source to Ftype.

kjbowser · 2014-12-10T14:22:16.000Z

Unbound Image Control! Duh! That did it. Rockn, you rock! I freakin’ love Spiceworks.

rockn · 2014-12-10T14:22:51.000Z

De nada! Have a good one.