473,324 Members | 2,196 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

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
2 1799
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: paul | last post by:
Hi I have one table Student number First Name Surname I have a folder containing student photographs where the name of the photo
0
by: TN Bella | last post by:
This may be a double post... I appreciate all the help I have gotten on here - thank you! So with that in mind, I figured I would try another post! :) I need to reformat the following...
2
by: RAJ | last post by:
In our multi-tier application, we have several ASP.NET user controls which will update the same data source provided by middle tier logic. In this particular scenario we have one user control...
1
by: R Padala | last post by:
Hi, We are building an internet based application that would allow any one to purchase online (php generated) reports that include a few photographs. What is the best way to serve the images...
24
by: Rhino | last post by:
I am dabbling with print CSS for the first time and I need some guidance. The web pages on my site look fine - to my untrained eye - when displayed on the monitor in any of the standard browsers....
3
by: boyet59 | last post by:
VerosMedia.com offers professional, digital retouching and photo restoration services. ** Restoration of treasured, family photographs. ** Portrait and model portfolio retouching. ** Photo...
0
by: thegametb | last post by:
I got this wrestling database I'm developing. It's not as straight and narrow as most sport databases are, but this has got me stumped a bit. I am trying to implement their stats in to their specific...
2
by: sorobor | last post by:
dear sir .. i am using cakephp freamwork ..By the way i m begener in php and javascript .. My probs r bellow I made a javascript calender ..there is a close button ..when i press close button...
4
by: redpears007 | last post by:
Hi Again, Throwing this one out to you again as i am not getting anywhere and can find little to no information out there. I am currently displaying images (Jpegs) in access via the routine...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.