Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Photo montage (access 2003)

    I have a form which displays a photo which is referenced in a table. I would like to create a second form with multiple pictures. The ID for these pictures would come from a second (appointments) table. For example, a query would return all appointments for today including the clientID. I would then use the generated clientIDs to populate a form with multiple images. (I can scroll through the photo form but I would like an individual and contemporaneous photo for each clientID.

    nebbia

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Photo montage (access 2003)

    Sorry, but what is the question?
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    May 2005
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Photo montage (access 2003)

    I have an appointments table. By querying the table I get a list of todays appointments; first and last name and clientID. I would like to take the clientIDs, for the days appointments, and create a montage ( a multiple image form) of each clients picture. Four appointments today=4 pictures displayed. I haven't been able to figure out how to display each client and their photo as a separate image. (It would be OK if the form had room for a fixed number of images some of which may be blank if there are not enough appointments). I hope that is somewhat clearer.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Photo montage (access 2003)

    You could create a continuous subform for the photos. The record source for the subform would be a query that contains both the appointment data and the picture info. Place the subform on the main form and link them through the appointment date.

    Also see the thread starting at <post:=282,808>post 282,808</post:>, there are several posts with sample databases attached.

  5. #5
    2 Star Lounger
    Join Date
    May 2005
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Photo montage (access 2003)

    Sorry it has taken so long to reply.
    I may be missing something. Doing it the way you suggest my subform displays 'only one' picture at a time. I would like the pictures of all appointments for the day to be displayed at the same time.

    Thanks
    nebbia

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Photo montage (access 2003)

    A continuous subform can display multiple records at once.

  7. #7
    2 Star Lounger
    Join Date
    May 2005
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Photo montage (access 2003)

    I'm still not able to find the problem. Despite being able to display all the photos individually I can not get the form to display multiple different images. I've included a sample database

    nebbia

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Photo montage (access 2003)

    Ah yes, a continuous form can only display different items in bound controls, not in unbound controls; I should have remembered that.

    The attached doesn't do quite what you want, but hopefully you can build on it. It uses unbound controls to display a series of images. It is based on the work done by Dave Willett and me in the thread I referred to higher up in this thread.

  9. #9
    2 Star Lounger
    Join Date
    May 2005
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Photo montage (access 2003)

    It is very close to what I was looking for. With some simple modifications it will work fine.

    Thanks as always

    nebbia

Posting Permissions

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