Displaying Pictures in Access

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 set
up in the article http://support.microsoft.com/kb/285820/en-us. It
works fine if the image is under 1000x1000 pixels. It is set up so
the user can double click to open the image in its host application.

Most of the images are way over the limit, normally 3000x3000 pixels,
and just don't display properly unless I reduce them indivdually. This
isn't a good idea as there are thousands of images to upload, and the
database is pointless without the images. Its kinda funny as some
images such photographs display ok regardless of their size, but
others such as scanned images are just so blocky and unviewable unless
the original is less than the 1000x1000.

I have done a fair bit of research and its not a office filter problem
I have also looked at the paint picture method and no luck there.

Is there any code that you can use to say wherever the image is
stored, whatever image is loaded, whatever size it is, display it at
less than 1000x1000 pixels, without altering the original.

It sounds like a simple idea to me, but i can find nothing to help me
around this problem.

Thanks in advance

Re: Displaying Pictures in Access

On Thu, 15 Nov 2007 04:57:50 -0800 (PST), redpears007@hotmail.com
wrote:

Why not display the images in whatever viewer the user has installed
on her machine?

-Tom.


>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 set
>up in the article http://support.microsoft.com/kb/285820/en-us. It
>works fine if the image is under 1000x1000 pixels. It is set up so
>the user can double click to open the image in its host application.
>
>Most of the images are way over the limit, normally 3000x3000 pixels,
>and just don't display properly unless I reduce them indivdually. This
>isn't a good idea as there are thousands of images to upload, and the
>database is pointless without the images. Its kinda funny as some
>images such photographs display ok regardless of their size, but
>others such as scanned images are just so blocky and unviewable unless
>the original is less than the 1000x1000.
>
>I have done a fair bit of research and its not a office filter problem
>I have also looked at the paint picture method and no luck there.
>
>Is there any code that you can use to say wherever the image is
>stored, whatever image is loaded, whatever size it is, display it at
>less than 1000x1000 pixels, without altering the original.
>
>It sounds like a simple idea to me, but i can find nothing to help me
>around this problem.
>
>Thanks in advance

Re: Displaying Pictures in Access

Thanks for the reply, but the brief is for an image database. The
client does not want to go through a long winded process of constantly
opening a host application from within access, to find the required
image but to have the images displayed on the form, which they won't
do correctly if they are large. Otherwise the method for displaying
the images is fine, its just telling access to display them correctly

Surely someone out there has come across this problem and can offer a
solution?


Tom van Stiphout wrote:

> On Thu, 15 Nov 2007 04:57:50 -0800 (PST), redpears007@hotmail.com
> wrote:
>
> Why not display the images in whatever viewer the user has installed
> on her machine?
>
> -Tom.
>
>
> >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 set
> >up in the article http://support.microsoft.com/kb/285820/en-us. It
> >works fine if the image is under 1000x1000 pixels. It is set up so
> >the user can double click to open the image in its host application.
> >
> >Most of the images are way over the limit, normally 3000x3000 pixels,
> >and just don't display properly unless I reduce them indivdually. This
> >isn't a good idea as there are thousands of images to upload, and the
> >database is pointless without the images. Its kinda funny as some
> >images such photographs display ok regardless of their size, but
> >others such as scanned images are just so blocky and unviewable unless
> >the original is less than the 1000x1000.
> >
> >I have done a fair bit of research and its not a office filter problem
> >I have also looked at the paint picture method and no luck there.
> >
> >Is there any code that you can use to say wherever the image is
> >stored, whatever image is loaded, whatever size it is, display it at
> >less than 1000x1000 pixels, without altering the original.
> >
> >It sounds like a simple idea to me, but i can find nothing to help me
> >around this problem.
> >
> >Thanks in advance

Re: Displaying Pictures in Access

wrote in message
news:ae1719fb-388d-4ac6-9172-3d0a06f841f0@y5g2000hsf.googleg roups.com...
>
> Surely someone out there has come across this problem and can offer a
> solution?
>

The way I do it is to have an unbound image object on the form named
"imgMugshot" and have a text box named "txtMugshot" bound to a hyperlink
field containing the path to the image file. Then in the form's current
event:

If IsNull(Me.txtMugshot) Or Me.txtMugshot = "" Then
Me.imgMugshot.Visible = False
Else
Me.imgMugshot.Visible = True
Me.imgMugshot.Picture = HyperlinkPart(Me.txtMugshot, acAddress)
End If

Worth a try, works for me.

HTH - Keith.
www.keithwilby.com

Re: Displaying Pictures in Access

Your stated maximum dimensions are not accurate but you do accurately
describe an issue that's been with Access for far too long. I have asked
repeatedly for an update to the Image control but to no avail. Perhaps A2007
with resolve this issue once and for all.

Prior to A2007, you can use the routine on my site to load larger images
into the standard Image control. See:
http://www.lebans.com/loadjpeggif.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


wrote in message
news:ae1719fb-388d-4ac6-9172-3d0a06f841f0@y5g2000hsf.googleg roups.com...
> Thanks for the reply, but the brief is for an image database. The
> client does not want to go through a long winded process of constantly
> opening a host application from within access, to find the required
> image but to have the images displayed on the form, which they won't
> do correctly if they are large. Otherwise the method for displaying
> the images is fine, its just telling access to display them correctly
>
> Surely someone out there has come across this problem and can offer a
> solution?
>
>
> Tom van Stiphout wrote:
>
>> On Thu, 15 Nov 2007 04:57:50 -0800 (PST), redpears007@hotmail.com
>> wrote:
>>
>> Why not display the images in whatever viewer the user has installed
>> on her machine?
>>
>> -Tom.
>>
>>
>> >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 set
>> >up in the article http://support.microsoft.com/kb/285820/en-us. It
>> >works fine if the image is under 1000x1000 pixels. It is set up so
>> >the user can double click to open the image in its host application.
>> >
>> >Most of the images are way over the limit, normally 3000x3000 pixels,
>> >and just don't display properly unless I reduce them indivdually. This
>> >isn't a good idea as there are thousands of images to upload, and the
>> >database is pointless without the images. Its kinda funny as some
>> >images such photographs display ok regardless of their size, but
>> >others such as scanned images are just so blocky and unviewable unless
>> >the original is less than the 1000x1000.
>> >
>> >I have done a fair bit of research and its not a office filter problem
>> >I have also looked at the paint picture method and no luck there.
>> >
>> >Is there any code that you can use to say wherever the image is
>> >stored, whatever image is loaded, whatever size it is, display it at
>> >less than 1000x1000 pixels, without altering the original.
>> >
>> >It sounds like a simple idea to me, but i can find nothing to help me
>> >around this problem.
>> >
>> >Thanks in advance