Hi,
I am struggling to display photographs in a list format. Any help will be
greatly appreciated.
Originally I had attempted to store photographs as embedded OLE Objects,
but had lots of trouble. I eventually abandoned this on advice from this
group that this format was not reliable, not to mention that it bloated the
database.
Since then I have successfully been able to manage individual photographs
by linking a picture file to an Image Control on the form.
I now require to be able to display thumbnails of ALL the photographs (or a
selected subset) as a "listing" in another form, where each photo record is
displayed in a separate row. Obviously I can't use Image Control as it
would display the same picture in every row. Unbound Object Frame has a
similar problem. A Bound Object Frame seems to be the best answer, and I
thought that I might be able to store the file path of the photograph in a
text field in the table and use that as the link. However, my research
shows that the Bound Object Frame requires the link to be stored in an OLE
Object field which has a size of about 460 KB (for a file path of about 50
characters). Also it cannot natively display JPG files.
Before I spend a lot more time on this, it occurred to me that this sort of
problem must have been solved many times before by experts in this group.
Can anyone help? I am looking more for a strategy at this stage rather
than a detailed solution. That is: a) what is the best type of control to
use to display photos in a record listing; and b) how to link that
economically to a picture file.
I am using Access 2003, and do not have access to a copy of Microsoft Photo
Editor (needed to display JPG files via OLE, as I understand it).
I have read the following Microsoft article which has been very helpful,
but it does not seem to cover exactly what I want:
http://office.microsoft.com/en-us/as...472041033.aspx (Use
images in your Access forms, reports and controls)
Thanks in advance for any help.
Cheers,
Lyn.