images in report - limit to name criteria

Davros

Registered User.
Local time
Today, 23:37
Joined
Sep 9, 2005
Messages
131
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
 

Attachments

  • screenshot 2.jpg
    screenshot 2.jpg
    50.2 KB · Views: 140
the answer to the above, which works for me, is to include the image path location within one of the 2 text/data queries [this is my link to the image query], copy the query the image box uses as a data source within the report, create a duplicate query with criteria *001.jpg and use this query in the report and not the original image query i see in form view. the coding in the page header detail section under 'on format' remains the same
this way in form view i can see all images associated with 1 record and when i print this record only the 1st image of each record will print
hope this helps someone
 

Users who are viewing this thread

Back
Top Bottom