How print pictures on a report
Posted on 2014-04-03
I have a report that uses a query as it's record source. The key field in the query is "PartN" which is a number field. The the report has a field named "txtPartN".
There are jpg picture files in a directory that reside in a folder that has the same name as the key field on the report. The path to the pictures folders is for example: C:\CompanyNameNCMRPhotos - This path is entered in a table named tblSetup in a field named "PicturesDataPath"
So for example, if PartN on the report is "9999" then there is a folder in that path named "9999" and I need to print the pictures that are in that folder on the report. In some cases there may be 1 picture. In other cases more than 1 picture.
How can I do this?