Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Trying to get subreport to print all pictures in a specified folder

I have the following code in an onformat event of a subreport which works fine to print the primary picture file as defined in the record table in an existing report.   But if the specified folder has more than one picture file in it I want the report to print all of the pictures in the subreport for a new report.

Here is the code which is working fine for the current report.  What do I have to do to it to make the new subreport print all of the pictures?

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    
    Dim strClientFolderName As String
    Dim strPropertyAssetFolderName As String
    Dim strPropertyFolderName As String

    strClientFolderName = TempVars!strPicturesDataPath & "\" & Trim(Me.txtClientTableID) & "\"
    strPropertyFolderName = strClientFolderName & Trim(Me.txtPropertyTableID) & "\"
    strPropertyAssetFolderName = strPropertyFolderName & Trim(Me.txtManualAssetN)

    Me.AssetImage.Picture = strPropertyAssetFolderName & "\" & Me.PrimaryPictureFile

End Sub

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial