Results 1 to 2 of 2
  1. #1
    KevinCollins is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Posts
    6

    Multiple Attachments in different Records

    Good Evening,

    Complete newbie to this version of access programming. Its been a decade since my last foray into access.
    I am creating a database that needs to store a large number of pictures. I have a component that we're working on that needs 100 photos of specific details taken and stored.

    I have created two separate tables.
    One that includes four fields,
    ID,
    Component Number
    PhotoType
    and an attachment field.

    The second table has
    ID,
    Photo Type and in this table I've coded 100 records detailing the photos I need. This is used as a lookup field for the first table.

    What I would Like to accomplish from this point is to be able to add 100 fields onto the form for the user to click on the attachment and then save the specific photo that corresponds. How do i edit the control source of the attachment item on the form so that it is specific to one component number, and one phototype?



    I appreciate any help that can be given.

    Kevin

  2. #2
    akhmadahdiyat is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Oct 2013
    Posts
    21
    saving the photo to where? database sample maybe.

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

Similar Threads

  1. Replies: 1
    Last Post: 12-17-2012, 08:29 PM
  2. If and Multiple Email Attachments
    By beckysright in forum Programming
    Replies: 5
    Last Post: 12-13-2012, 03:25 PM
  3. attachments and adding new records
    By chiefmsb in forum Access
    Replies: 0
    Last Post: 07-06-2011, 01:22 PM
  4. Multiple Attachments To One Record
    By Dgree03 in forum Access
    Replies: 1
    Last Post: 03-23-2011, 09:45 AM
  5. Append records with attachments
    By Dawie Theron in forum Queries
    Replies: 1
    Last Post: 01-22-2010, 06:19 AM

Tags for this Thread

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