store directory of OLE object

Tech-Archive recommends: Fix windows errors by optimizing your registry

anonymous_at_discussions.microsoft.com
Date: 02/22/04


Date: Sun, 22 Feb 2004 03:58:53 -0800

I have a form to store pictures. The pictures are linked
to the db and not stored in it.
I have the following fields in a table

ImgID - PK
Pic - data type OLE Object
File_Path - data type text

I am able to bring up the InsertObject dialog box where I
can browse to select the picture from the directory where
it is stored using the commands below.

DoCmd.GoToControl "Pic"
DoCmd.RunCommand acCmdInsertObject

How can I store the directory where the file is located
in the db in the File_Path in the table. I would like to
automatically copy it from the InsertObject dialog box
and insert it in the File_Path field, or any method where
I do not have to type it manually?



Relevant Pages

  • Re: [PHP] Re: how to display images stored in DB
    ... On 2/25/07, zerof wrote: ... It is not a good practice to store pictures in DataBases, use links, ... posters to upload images and I store all the images on the file system and ...
    (php.general)
  • Re: How will the change affect multiple recorders?
    ... >> Hmmm...that's rather fallacious analogy Tony.. ... >> More like two people that may take their washing machine to a place ... way, to be stored, just as film is used to store pictures, and how ...
    (uk.rec.video.digital)
  • Re: How workable is Vista?
    ... The most common cause for such big word files is pictures. ... .doc format doesn't seem to be able to store pictures in jpg - it uses a sort of mangled raw bitmap that can't be well compressed by external programs. ...
    (comp.arch.embedded)
  • using mem card pictures for screen saver
    ... I have a Dell Axim 50 and I currently store pictures on the internal memory card. ... Is there a way to point the screen saver to use those pictures? ...
    (microsoft.public.pocketpc)
  • Re: Table Stability
    ... microsoft Wrote: ... > Data type - all text. ... No pictures is being stored in the table. ... Prev by Date: ...
    (microsoft.public.access.forms)