Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: How to paste photos

Discussion in 'Information Technology' started by Khoshravan, Jul 28, 2006.

Tags:
  1. Khoshravan

    Khoshravan
    Expand Collapse
    Guest

    I am trying to utilize following knowledgebase article:
    ACC: How to Load OLE Objects from a Folder into a Table
    Article ID : 158941

    What is the Class in the MAcro written in that article?
    Larry Linson also points out this issue. He says: "I omitted that and it
    seems to work quite well without setting the Class property"

    In my case the program loaded the photos but viewing in a report, it only
    shows the jpg icons not photos itself.
    Could you please kindly hint one more step to finalize the task.
    TIA
    --
    Rasoul Khoshravan Azar
    Civil Engineer
    Osaka, Japan


    "Douglas J. Steele" wrote:

    > The sample databases to which I pointed you should show you what you need.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "Khoshravan" <khoshravan@discussions.microsoft.com> wrote in message
    > news:E22BF6AC-3C77-4E0B-90F1-7075FA042E67@microsoft.com...
    > > Dear Douglas
    > > I gave up the method to copy and store the photos inside db.
    > > Could you please kindly tell me the standard procedure to include links to
    > > photos?
    > > I simply write click in the photo field (in table) and follow the
    > > directions. It shows the message package in the photo field after
    > > finishing
    > > but it doesn't show either in table, form or report. Am I doing something
    > > wrong?
    > > --
    > > Rasoul Khoshravan Azar
    > > Civil Engineer
    > > Osaka, Japan
    > >
    > >
    > > "Douglas J. Steele" wrote:
    > >
    > >> You really shouldn't store the pictures in the database, but just store a
    > >> link to where the picture is on the hard drive: Access is very
    > >> inefficient
    > >> on storing images.
    > >>
    > >> If you really want to store them in the database, though, check the
    > >> sample
    > >> imaging databases at http://accdevel.tripod.com. They illustrate three
    > >> approaches to handling images in Access, and the download includes an
    > >> article discussing considerations in choosing an approach. Two of the
    > >> approaches do not use OLE Objects and, thus, avoid the database bloat,
    > >> and
    > >> some other problems, associated with images in OLE Objects.
    > >>
    > >> If you are printing the images in reports, to avoid memory leakage, you
    > >> should also see MVP Stephen Lebans'
    > >> http://www.lebans.com/printfailures.htm.
    > >> PrintFailure.zip is an Access97 MDB containing a report that fails during
    > >> the Access formatting process prior to being spooled to the Printer
    > >> Driver.
    > >> This MDB also contains code showing how to convert the contents of the
    > >> Image
    > >> control to a Bitmap file prior to printing. This helps alleviate the "Out
    > >> of
    > >> Memory" error that can popup when printing image intensive reports.
    > >>
    > >> If you've already starting storing images in your database, and you'd
    > >> like
    > >> to export them all, see:
    > >> http://www.lebans.com/oletodisk.htm
    > >>
    > >>
    > >>
    > >> --
    > >> Doug Steele, Microsoft Access MVP
    > >> http://I.Am/DougSteele
    > >> (no private e-mails, please)
    > >>
    > >>
    > >> "Khoshravan" <khoshravan@discussions.microsoft.com> wrote in message
    > >> news:BD928306-2A7E-4748-AAEC-16F7FBD9507A@microsoft.com...
    > >> >I have a database of applicants with their photos.
    > >> > Filed name for photos is: photo.
    > >> > I have chosen OLE object as data type in table design. Is this true?
    > >> > I have the photos in jpg format.
    > >> >
    > >> > How to Input (or import) the photo?
    > >> > In table input mode, I right click in the photo field and choose:
    > >> > "Insert
    > >> > object"
    > >> > In Insert object window I click buttun: "Creat from File" and give the
    > >> > path.
    > >> > It doesn't bring the photo but writes "package" in table. But it
    > >> > doesn't
    > >> > show
    > >> > the photo when I browse my database in Report.
    > >> > What is the best and easiest way to bring the photos to Access and vire
    > >> > them
    > >> > in Report and print them out?
    > >> >
    > >> >
    > >> > --
    > >> > Rasoul Khoshravan Azar
    > >> > Civil Engineer
    > >> > Osaka, Japan
    > >>
    > >>
    > >>

    >
    >
    >
     
  2. Loading...


Share This Page