Alas, there is no "good way" to do what you want in a continuous forms view
in Access without using Bound OLE frames and OLE Objects. That's a
limitation of continuous forms view, not of the imaging support.
Plenty of Access users have requested improvement in this area, so perhaps
one day it will work its way up the priority list and something will be
done.
Larry Linson
Microsoft Access MVP
"Lyn" <l.hancock@iiNet.net.au> wrote in message
news:egz9hbwbofez.ui4zqniseemf$.dlg@40tude.net...[color=blue]
> 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.[/color]
