Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2009
    Location
    Tucson, AZ, USA
    Posts
    185
    Thanks
    3
    Thanked 3 Times in 3 Posts

    Image manipulation (97)

    I need to have images (student photos) printed in a report (as ID cards). I cannot find a clear, definitive discussion on how to manipulate images in access. I have 2K at home, 97 at work.

    When I use directions from KB Q158941 to load OLE objects from a folder into a table, the resulting images all show up as miniatures in the Bound Object Frame and have the file name beneath each. I cannot change the size using stretch.

    Northwind has images of their employees but their table OLE Object item field contains the words "Bitmapped Image." My table Bitmapped Object field contains the word "package." I have a reference to the image file, they do not.

    It would seem to me that SOMEBODY has written a guide to using Access to store images or pointers to image files so that digital photos can be stored in personnel files and used for things like ID cards printed on the ubiquitous color printers.

    Where can I read about this?
    Dan Lynch
    The stonecherub

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Image manipulation (97)

    I've just spent some time doing exactly the same thing, but using VBA and VB6. The solution in that environment is to use an image control, and then use this syntax:

    image1.picture = loadpicture(sTxtFileName)

    So... I tried that in Access 97, using the OnCurrent event. Abject failure. Rats....

    sorry. Thought I could be more help. I would be interested to know the correct solution, too.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Image manipulation (97)

    i use an image frame instead of a bound or unbound object frame
    the code to change the picture is
    image1.picture=[field name]

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Image manipulation (97)

    Doh!!!
    Those subtle (??) differences between Access and VB with getcha every time. Thanks for showing the correct syntax.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  5. #5
    2 Star Lounger
    Join Date
    Feb 2009
    Location
    Tucson, AZ, USA
    Posts
    185
    Thanks
    3
    Thanked 3 Times in 3 Posts

    Re: Image manipulation (97)

    Thanks, that does work with a form but I am trying to print ID cards on a color printer using data and images from an Access data base. Changing a record on a form re-queries the recordset and refreshes the caption property of the image control. A report is a one-shot and I need a way to convey the contents of the file name field for each student.

    I despair.
    Dan Lynch
    The stonecherub

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Image manipulation (97)

    Does <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=65495&page=&view =&sb=&o=&vc=1>this thread</A> contain anything you can use?
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •