Merging unique images into an Access Report.

Discussion in 'MS Access' started by IDHEE, Sep 9, 2009.

  1. IDHEE

    IDHEE New Member

    Joined:
    Sep 9, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    We are using Access to hold membership data, from which we merge to various multiple documents.
    Our latest project is to merge the relevant data on to a letter that includes a peel-off membership card. The card has a window for a passport style photo of the member, which they have to sandwich between the two parts of the card. As the photo needs to be of the correct dimensions we would like to print the photo at the correct size, for the member to cut out from the bottom of the letter (report).
    If it can be done, how do we link to the picture related to a specific record.
    I have thought of using a data field that contains the file address of the relevant photo, but can find reference of how to do it in any MS Access books.
    Is it possible? If so, how would be great.
    Thanks,
    IDHEE
     
  2. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    769
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    http://techiethakkar.blogspot.com
    You can store the image itself into access database
    use the datatype as OLE Object for that column
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice