467,146 Members | 1,256 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,146 developers. It's quick & easy.

Need help displaying photographs

Lyn
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.
Nov 13 '05 #1
  • viewed: 1521
Share:
2 Replies
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.*******@iiNet.net.au> wrote in message
news:eg****************************@40tude.net...
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.

Nov 13 '05 #2
Lyn
Larry,
Thank you for your response. It is not what I was hoping to hear, but at
least it will save me wasting more time on a fruitless search.

Cheers,
Lyn.

On Mon, 15 Aug 2005 00:53:42 GMT, Larry Linson wrote:
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.*******@iiNet.net.au> wrote in message
news:eg****************************@40tude.net...
Hi,
I am struggling to display photographs in a list format. Any help will be
greatly appreciated.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by paul | last post: by
reply views Thread by TN Bella | last post: by
1 post views Thread by R Padala | last post: by
24 posts views Thread by Rhino | last post: by
3 posts views Thread by boyet59@gmail.com | last post: by
4 posts views Thread by redpears007@hotmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.