hi
i have created a form bringing together 3 queries. one of the queries contains images the other 2 queries are text/data information.
i am now creating a report to print out the queries. each query is made into a report and then combined with a main report [2 of the queries are subreports]. the code i have used to link the images so that i get a unique image with every record is
me.[cempic2].picture = me![combined_mage_path]
however when i print the report if the record contains more then 1 image i get the following [screenshot 2].
what i need to do is to limit the image print out for each record to the first image only. the only common naming criteria for all my images is 001.jpg, 002. jpg and so on
what i need to do is to show only the image for each record that ends with the criteria *001.jpg. how would i do this in VB?
thanks
i have created a form bringing together 3 queries. one of the queries contains images the other 2 queries are text/data information.
i am now creating a report to print out the queries. each query is made into a report and then combined with a main report [2 of the queries are subreports]. the code i have used to link the images so that i get a unique image with every record is
me.[cempic2].picture = me![combined_mage_path]
however when i print the report if the record contains more then 1 image i get the following [screenshot 2].
what i need to do is to limit the image print out for each record to the first image only. the only common naming criteria for all my images is 001.jpg, 002. jpg and so on
what i need to do is to show only the image for each record that ends with the criteria *001.jpg. how would i do this in VB?
thanks