Re: insert photo into olebound object

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Roger Carlson (NO-Rog3erc-SPAM_at_hotmail.com)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 11:06:38 -0400

The usual way to handle this is to leave the pictures in a directory in the
file system and simply store the path to the file in each record. Then you
can load the picture into a form or report programmatically at run-time.

On my website (see sig below) is a small sample database called
"Pictures.mdb" which illustrates how this is done. 

-- 
--Roger Carlson
  www.rogersaccesslibrary.com
  Reply to: Roger dot Carlson at Spectrum-Health dot Org
"Wayne" <anonymous@discussions.microsoft.com> wrote in message
news:C880D3AD-AB92-4539-B249-3B8027550BEB@microsoft.com...
> Ok I hope I can explain this correctly.
> I have a form that has four fields that are hyperlinks to a photos.
> I would like to create a report that will display these photos.
> I can get the location of the Hyperlink by the following command
>
> Dim tmo As String
> tmo = photo.Hyperlink.Address
>
> Is there a way that I can take the address of the file and insert the
photo into an olebound object.
> That way I can insert the object into a temp dB and have the form pull
from teh temp Db.
> I need to do this, because I do not want to store photos in my Db due to
the size issue.
>
> Any help would be greatful
>
> Thanks
> Wayne
>

Relevant Pages

  • Re: CF dying?
    ... That means that I can only store about 207 CR2 files on a DVD. ... Just buy a couple of WD Passport 500GB drives. ... pictures, right as they came out of the camera. ... process to annotate these old photos. ...
    (rec.photo.digital)
  • Re: Color problem printing photos online
    ... need to upload a few photos to a website like Shutterfly and then ... or Target left me with prints that looked grainy and unrealistic. ... at the store, there's never a problem with the coloring. ... The digital pictures are high quality so ...
    (rec.photo.digital.slr-systems)
  • Re: OT - Photography Question
    ... I store a RAW and a JPG image and the two ... I also store photos on DVD and make an original and a backup so I end ... I need to start getting out more and taking pictures. ... the street because Garmin needs their old acreage. ...
    (rec.outdoors.rv-travel)
  • Re: OT - Emergency planning
    ... I scan important old photos to my computer. ... I then store them on archival ... archival disks you can buy that are supposed to be good for something like ... pictures, and I'm humble enough to admit I was SUCH a cute baby. ...
    (sci.med.transcription)
  • Re: Sign Photography - your thoughts
    ... My Fotopic site, which consists largely of sign photos, is here: ... Normally I publish pictures conforming only to the first two types. ... spend a lot of time working on a sign photos website, ... publication in my own activities, ...
    (misc.transport.road)