Merging unique images into an Access Report.
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.
Re: Merging unique images into an Access Report.
You can store the image itself into access database
use the datatype as OLE Object for that column
|All times are GMT +5.5. The time now is 04:40.|