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!



    Thanks,
    Pierce
    Attached Thumbnails Attached Thumbnails Emergency Contacts Form.jpg  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,527
    put photos in an OLE field.
    you cannot show ATTACHEMENTS directly. They must be extracted before viewing.

  3. #3
    standonthefloor is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2019
    Posts
    6
    Quote Originally Posted by ranman256 View Post
    put photos in an OLE field.
    you cannot show ATTACHEMENTS directly. They must be extracted before viewing.
    Hey, thanks for the quick reply, when I try this, I get a box that just shows the icon, and does not display the picture, do I need to change any settings to get this to work? Also when I have it as an attachment, the picture does display on the subform.

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

Similar Threads

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