Results 1 to 5 of 5
  1. #1
    ClairH is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jul 2013
    Posts
    3

    Question Adding an attachment field newly added to table - onto already existing form

    Hi I wonder if anyone can help me please?



    I have a form linked to a
    table, and I have added an attachment field to the table and I would like to
    include it in the form.

    I go into layout or design view and click on add
    existing fields, and I can see the attachment field (with 3 extra rows of data)
    I have selected all 4 and double clicked, and they are not adding to my form, if
    I put a attachment field in (the paperclip) I have no idea how to link it to the
    attachment field in my table.

    I have searched through my user guides and
    tried various things I have found online, but I just can't get it to
    work.

    I want to be able to attach scanned documents to the
    records.

    Thank you

    Clair

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,049
    Firstly Clair have you given the field a caption in the design of the table? If not, click on the field in design view and at the bottom you'll see the option to add a caption


    After that there's no reason why you shouldn't be able to drag the image onto the form in design view

    clicking on the image (if there are more than one will allow you to move onto the next one

  3. #3
    ClairH is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jul 2013
    Posts
    3
    Fab great thank you it worked, I can now add attachments thank you :-)

    thank you SOOOOOOOOOOOOOO much
    Clair

  4. #4
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,049
    Glad to have helped.

  5. #5
    ClairH is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jul 2013
    Posts
    3
    You're a star

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

Similar Threads

  1. Newly added record Search
    By galadrwin in forum Access
    Replies: 2
    Last Post: 02-10-2015, 06:27 AM
  2. Replies: 9
    Last Post: 01-30-2015, 03:37 PM
  3. Replies: 2
    Last Post: 08-11-2014, 12:57 PM
  4. Replies: 2
    Last Post: 06-08-2014, 10:23 AM
  5. I am stumped...adding field to existing table
    By tanyalee123 in forum Queries
    Replies: 6
    Last Post: 12-09-2013, 06:04 PM

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