• Image manipulation (97)

    Author
    Topic
    #363037

    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?

    Viewing 1 reply thread
    Author
    Replies
    • #552822

      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.

    • #552825

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

      • #553001

        Doh!!!
        Those subtle (??) differences between Access and VB with getcha every time. Thanks for showing the correct syntax.

      • #553084

        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.

    Viewing 1 reply thread
    Reply To: Image manipulation (97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: