473,221 Members | 1,784 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,221 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 1796
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: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.