Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Sep 2008
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have setup a database with pictures stored in a folder that appear with each record. Works great. I was also able to create a report where an individual record can be printed with the picture.

    My problem is when I try to print several records in one report. I can get each record's data but the picture remains the same as the first record.

    When I print an individual record I placed the following code in the on activiate event of the report:

    Me.imgPicture.Picture = CurrentProject.Path & "\" & Me.PictureTitle & ".JPG"

    That doesn't work when the picture has to change with each new record in the report. Not sure how to approach this issue.

    Any ideas?

    Thanks.

    Paul

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='bienpaul2' post='765496' date='15-Mar-2009 20:29'][/quote]
    You should put that code in the On Format event of the Detail section of the report.
    Francois

  3. #3
    Lounger
    Join Date
    Sep 2008
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks. That fixed it.

    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •