Results 1 to 2 of 2
  1. #1
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243

    Placing multiple images in a form?

    Click image for larger version. 
<br /><script async src=
    Name: PhotoTab.jpg  Views: 13  Size: 38.3 KB  ID: 12163" class="thumbnail" style="float:CONFIG" />

    Is it possible to display a number of photos (unique to each record) under the photo tab for this form I designed? Right now I’m storing the photos in a table designed just for attachments. But, I would like to be able to display the photos in the form.

    Some people will have several photos. Others will have none. However, each record will have two fields for images: bio photo and research photos. But again, not everyone submits photos. The design is each person will have one bio photo, but can have 1 or multiple research images, if in fact they do submit graphics. Most do not. But when someone DOES submit research photos, they tend to be numerous.

    Problem, is I’m stumped as to how to design the table in cases where one person has multiple photos. Is it possible or is the attachment table my only option for storing multiple images for each record?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Options:

    1. Attachment field for each image or set of images. A single Image control can display multiple images from one attachment field. The control will have a move forward/back bar, at least I have seen this.

    2. A child table with a record for each image. This means the images will display vertically.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Placing query data on the form
    By snowboarder234 in forum Forms
    Replies: 7
    Last Post: 11-07-2012, 11:30 AM
  2. Replies: 1
    Last Post: 09-27-2011, 08:55 PM
  3. Saving Multiple Images to Form using a filepath
    By Jinxedcookie in forum Forms
    Replies: 3
    Last Post: 09-26-2011, 12:41 PM
  4. Replies: 17
    Last Post: 08-26-2009, 11:27 AM
  5. Placing images quickly
    By marcello.dolcini in forum Import/Export Data
    Replies: 1
    Last Post: 10-20-2008, 06:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums