1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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:
    770
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    You can store the image itself into access database
    use the datatype as OLE Object for that column
     

Share This Page