Results 1 to 3 of 3
  1. #1
    standonthefloor is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2019
    Posts
    6

    Form will not display image attachment from subform

    I'm relatively basic with Access, so I'm not sure if I've done this the right way.


    I'm creating an Emergency Contacts form that let's us look up contacts in case of emergencies. The way I have it set up is all the data gets pulled into a subform, but only their employee ID and Names are shown, this acts as a selector. The main form references the selected record in the subform and puts it in an easy to read format. Everything works perfectly, except for the attachment that contains the picture of the employee (somewhat large company, the picture acts as a way to verify you have the right person). It just shows up as a blank box. When I open the subform by itself, the picture shows up fine, but I'm not sure why it won't pull into the main form. Any help to get this working would be greatly appreciated! Also if there is a better way to do this I'm all ears!

    ThanksClick image for larger version. 

Name:	Emergency Contacts Form.jpg 
Views:	6 
Size:	90.1 KB 
ID:	37723

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    If the images is an OLE field then you can display the image on the form,
    if it is an attachment , then it must be extracted. I'd use the OLE.

  3. #3
    standonthefloor is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2019
    Posts
    6
    Hey ranman256,
    When I put the picture in as an OLE field, it only shows a generic icon in the form, not the picture.

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

Similar Threads

  1. Form will not display image attachment from subform
    By standonthefloor in forum Forms
    Replies: 2
    Last Post: 03-05-2019, 09:58 AM
  2. Replies: 10
    Last Post: 02-25-2019, 07:36 PM
  3. Display image from attachment field
    By ZachAtaiyan in forum Reports
    Replies: 4
    Last Post: 07-24-2014, 07:24 AM
  4. How to display attachment file name in a form?
    By HelpMeWithAccess in forum Access
    Replies: 6
    Last Post: 06-26-2014, 12:52 AM
  5. Form Attachment Default Image Cut Off
    By breakingme10 in forum Forms
    Replies: 2
    Last Post: 06-06-2014, 12:45 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