PC Review


Reply
Thread Tools Rate Thread

Database Photos

 
 
=?Utf-8?B?c2FtRw==?=
Guest
Posts: n/a
 
      18th Sep 2005
Using FP 2002 w/ Access 2000. Have successfully got photos linked per
KB318813 and they show just fine. Have the original photos, but they are
cropped and resized in order to fit a particular table layout. Now, is it
possible to link the photos to the originals so a viewer can enlarge them, as
if you had them in thumbnails ?

Thanks,
--
samG
 
Reply With Quote
 
 
 
 
Stefan B Rusynko
Guest
Posts: n/a
 
      18th Sep 2005
Clarify
You are displaying some sort of reduced size image (say images/small_image.jpg) from your DB, and want it linked to a larger image
(say images/full_image.jpg)?
- in which case both image names would need to be in your DB as 2 different fields (as say FavoriteImage and FullImage)
Or are you displaying a larger image (say images/full_image.jpg) from your DB but w/ height/width set less than full size?
- in which case you only need the 1 image name in your DB as 1 field (as say FavoriteImage)

And where do you want to display the larger image, in the same page or in another page or popup?

If your smaller image FavoriteImage is displayed in the results using say:
<img src="<%=FP_FieldVal(fp_rs,"FavoriteImage")%>">
Your link (to a new "page" w/ just the full size image FullImage) would be something like:
<a href="<%=FP_FieldVal(fp_rs,"FullImage")%>" target="_blank">
<img src="<%=FP_FieldVal(fp_rs,"FavoriteImage")%>">
</a>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"samG" <(E-Mail Removed)> wrote in message news:4A16F946-107E-4983-8375-(E-Mail Removed)...
| Using FP 2002 w/ Access 2000. Have successfully got photos linked per
| KB318813 and they show just fine. Have the original photos, but they are
| cropped and resized in order to fit a particular table layout. Now, is it
| possible to link the photos to the originals so a viewer can enlarge them, as
| if you had them in thumbnails ?
|
| Thanks,
| --
| samG


 
Reply With Quote
 
=?Utf-8?B?c2FtRw==?=
Guest
Posts: n/a
 
      18th Sep 2005
Stefan, thanks for responding. All photos (1 per record in the db) have been
resized via Photo Shop Pro to accommodate the desired table layout. I link
to these photos via the picture properties using
<img border="0" src=<%=FP_FieldLink(fp_rs,"Photo")%>
I would like to be able to link the display photos to the original sized
photos with just a mouse click on the displayed photo (similar to what a
thumbnail photo does) and have it show in a new screen (just like the
thumbnails do now). Is this possible without having to insert a second photo
entry into the db ? If I could create a thumbnail on the fly that would be
great, then I would use the original sized photos, but I don't think this is
possible.

--
samG


"Stefan B Rusynko" wrote:

> Clarify
> You are displaying some sort of reduced size image (say images/small_image.jpg) from your DB, and want it linked to a larger image
> (say images/full_image.jpg)?
> - in which case both image names would need to be in your DB as 2 different fields (as say FavoriteImage and FullImage)
> Or are you displaying a larger image (say images/full_image.jpg) from your DB but w/ height/width set less than full size?
> - in which case you only need the 1 image name in your DB as 1 field (as say FavoriteImage)
>
> And where do you want to display the larger image, in the same page or in another page or popup?
>
> If your smaller image FavoriteImage is displayed in the results using say:
> <img src="<%=FP_FieldVal(fp_rs,"FavoriteImage")%>">
> Your link (to a new "page" w/ just the full size image FullImage) would be something like:
> <a href="<%=FP_FieldVal(fp_rs,"FullImage")%>" target="_blank">
> <img src="<%=FP_FieldVal(fp_rs,"FavoriteImage")%>">
> </a>
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
> _____________________________________________
>
>
> "samG" <(E-Mail Removed)> wrote in message news:4A16F946-107E-4983-8375-(E-Mail Removed)...
> | Using FP 2002 w/ Access 2000. Have successfully got photos linked per
> | KB318813 and they show just fine. Have the original photos, but they are
> | cropped and resized in order to fit a particular table layout. Now, is it
> | possible to link the photos to the originals so a viewer can enlarge them, as
> | if you had them in thumbnails ?
> |
> | Thanks,
> | --
> | samG
>
>
>

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      18th Sep 2005
You can create a thumbnail image using the large image just by setting the width value, say 125
pixels for the thumbnail to be displayed on your page.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"samG" <(E-Mail Removed)> wrote in message
news:C4952FC1-A2FA-4519-8150-(E-Mail Removed)...
> Stefan, thanks for responding. All photos (1 per record in the db) have been
> resized via Photo Shop Pro to accommodate the desired table layout. I link
> to these photos via the picture properties using
> <img border="0" src=<%=FP_FieldLink(fp_rs,"Photo")%>
> I would like to be able to link the display photos to the original sized
> photos with just a mouse click on the displayed photo (similar to what a
> thumbnail photo does) and have it show in a new screen (just like the
> thumbnails do now). Is this possible without having to insert a second photo
> entry into the db ? If I could create a thumbnail on the fly that would be
> great, then I would use the original sized photos, but I don't think this is
> possible.
>
> --
> samG
>
>
> "Stefan B Rusynko" wrote:
>
>> Clarify
>> You are displaying some sort of reduced size image (say images/small_image.jpg) from your DB, and
>> want it linked to a larger image
>> (say images/full_image.jpg)?
>> - in which case both image names would need to be in your DB as 2 different fields (as say
>> FavoriteImage and FullImage)
>> Or are you displaying a larger image (say images/full_image.jpg) from your DB but w/
>> height/width set less than full size?
>> - in which case you only need the 1 image name in your DB as 1 field (as say FavoriteImage)
>>
>> And where do you want to display the larger image, in the same page or in another page or popup?
>>
>> If your smaller image FavoriteImage is displayed in the results using say:
>> <img src="<%=FP_FieldVal(fp_rs,"FavoriteImage")%>">
>> Your link (to a new "page" w/ just the full size image FullImage) would be something like:
>> <a href="<%=FP_FieldVal(fp_rs,"FullImage")%>" target="_blank">
>> <img src="<%=FP_FieldVal(fp_rs,"FavoriteImage")%>">
>> </a>
>>
>> --
>>
>> _____________________________________________
>> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> "Warning - Using the F1 Key will not break anything!" (-;
>> To find the best Newsgroup for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>> _____________________________________________
>>
>>
>> "samG" <(E-Mail Removed)> wrote in message
>> news:4A16F946-107E-4983-8375-(E-Mail Removed)...
>> | Using FP 2002 w/ Access 2000. Have successfully got photos linked per
>> | KB318813 and they show just fine. Have the original photos, but they are
>> | cropped and resized in order to fit a particular table layout. Now, is it
>> | possible to link the photos to the originals so a viewer can enlarge them, as
>> | if you had them in thumbnails ?
>> |
>> | Thanks,
>> | --
>> | samG
>>
>>
>>



 
Reply With Quote
 
=?Utf-8?B?c2FtRw==?=
Guest
Posts: n/a
 
      19th Sep 2005
Thanks Stefan and Thomas for your input. Playing around I found another way
to accomplish the task. First, I will use only full size photos, loading
each with the size required for the table layout via using the Picture
Properties. Then, under or on top of the picture have "Click to enlarge"
with the same db link as I have in the
Picture Properties. It works just great. Thanks again.
--
samG


"samG" wrote:

> Using FP 2002 w/ Access 2000. Have successfully got photos linked per
> KB318813 and they show just fine. Have the original photos, but they are
> cropped and resized in order to fit a particular table layout. Now, is it
> possible to link the photos to the originals so a viewer can enlarge them, as
> if you had them in thumbnails ?
>
> Thanks,
> --
> samG

 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      19th Sep 2005
It works
- but it is bad for your users / bandwidth
- your page load time will be for the full size images (not the displayed size) and may take forever to open

IMHO
add the smaller "thumbnail" images back to your site in addition to the full size images

You can also use the same DB field if you really need to,
- rename all of your "thumbnail" size images consistently by a constant prefix as say "sm_fullimagename.jpg", where
"fullimagename.jpg" is the real name for your each of your full size images in the DB field named "Photo"

Your link would then be
<a href="<%=FP_FieldVal(fp_rs,"Photo")%>" target="_blank">
<img src="<%="sm_" & FP_FieldVal(fp_rs,"Photo")%>"></a>
Which would result in an actual link for a Photo named fullimagename.jpg as
<a href="fullimagename.jpg" target="_blank">
<img src="sm_fullimagename.jpg"></a>
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"samG" <(E-Mail Removed)> wrote in message news:7BF493B3-AD59-4149-9401-(E-Mail Removed)...
| Thanks Stefan and Thomas for your input. Playing around I found another way
| to accomplish the task. First, I will use only full size photos, loading
| each with the size required for the table layout via using the Picture
| Properties. Then, under or on top of the picture have "Click to enlarge"
| with the same db link as I have in the
| Picture Properties. It works just great. Thanks again.
| --
| samG
|
|
| "samG" wrote:
|
| > Using FP 2002 w/ Access 2000. Have successfully got photos linked per
| > KB318813 and they show just fine. Have the original photos, but they are
| > cropped and resized in order to fit a particular table layout. Now, is it
| > possible to link the photos to the originals so a viewer can enlarge them, as
| > if you had them in thumbnails ?
| >
| > Thanks,
| > --
| > samG


 
Reply With Quote
 
=?Utf-8?B?c2FtRw==?=
Guest
Posts: n/a
 
      19th Sep 2005
You can also accomplish the same by inserting the same code for Picture Source
<%=FP_FieldLink(fp_rs,"Photo")%> into the Location for Default HyperLink in
the Picture Properties, but you still have to tell the viewer somewhere to
click it since the picture will not give any hint that there is a link. It
works great either way. Thanks Stefan for the hint in your initial response.
--
samG


"samG" wrote:

> Thanks Stefan and Thomas for your input. Playing around I found another way
> to accomplish the task. First, I will use only full size photos, loading
> each with the size required for the table layout via using the Picture
> Properties. Then, under or on top of the picture have "Click to enlarge"
> with the same db link as I have in the
> Picture Properties. It works just great. Thanks again.
> --
> samG
>
>
> "samG" wrote:
>
> > Using FP 2002 w/ Access 2000. Have successfully got photos linked per
> > KB318813 and they show just fine. Have the original photos, but they are
> > cropped and resized in order to fit a particular table layout. Now, is it
> > possible to link the photos to the originals so a viewer can enlarge them, as
> > if you had them in thumbnails ?
> >
> > Thanks,
> > --
> > samG

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      19th Sep 2005
If the large images are optimized correctly, then there is no reason to have to have a thumbnail
version as well as a large version, just the large version is needed.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Stefan B Rusynko" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> It works
> - but it is bad for your users / bandwidth
> - your page load time will be for the full size images (not the displayed size) and may take
> forever to open
>
> IMHO
> add the smaller "thumbnail" images back to your site in addition to the full size images
>
> You can also use the same DB field if you really need to,
> - rename all of your "thumbnail" size images consistently by a constant prefix as say
> "sm_fullimagename.jpg", where
> "fullimagename.jpg" is the real name for your each of your full size images in the DB field named
> "Photo"
>
> Your link would then be
> <a href="<%=FP_FieldVal(fp_rs,"Photo")%>" target="_blank">
> <img src="<%="sm_" & FP_FieldVal(fp_rs,"Photo")%>"></a>
> Which would result in an actual link for a Photo named fullimagename.jpg as
> <a href="fullimagename.jpg" target="_blank">
> <img src="sm_fullimagename.jpg"></a>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
> _____________________________________________
>
>
> "samG" <(E-Mail Removed)> wrote in message
> news:7BF493B3-AD59-4149-9401-(E-Mail Removed)...
> | Thanks Stefan and Thomas for your input. Playing around I found another way
> | to accomplish the task. First, I will use only full size photos, loading
> | each with the size required for the table layout via using the Picture
> | Properties. Then, under or on top of the picture have "Click to enlarge"
> | with the same db link as I have in the
> | Picture Properties. It works just great. Thanks again.
> | --
> | samG
> |
> |
> | "samG" wrote:
> |
> | > Using FP 2002 w/ Access 2000. Have successfully got photos linked per
> | > KB318813 and they show just fine. Have the original photos, but they are
> | > cropped and resized in order to fit a particular table layout. Now, is it
> | > possible to link the photos to the originals so a viewer can enlarge them, as
> | > if you had them in thumbnails ?
> | >
> | > Thanks,
> | > --
> | > samG
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
photos in database Jan Microsoft Access Getting Started 6 23rd Mar 2008 07:37 PM
Contacts Database with Photos Bell via AccessMonster.com Microsoft Access Form Coding 2 18th Dec 2007 04:31 AM
Photos in a Membership Database =?Utf-8?B?UnlhblBpdHQ=?= Microsoft Access 1 22nd Aug 2006 12:04 PM
Photos in My Database =?Utf-8?B?ZXNt?= Microsoft Access 4 5th Jul 2004 01:21 PM
Adding photos to a database... Nick Goldman Microsoft Access Getting Started 9 12th Aug 2003 03:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:43 AM.