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

    Inserting bound object -- image does not appear.


    When I navigate from the bound object box to the file, it returns the image icon instead of the actual image.
    Attached Thumbnails Attached Thumbnails BoundObject.GIF  

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Try picking a bitmap instead. Seems to me that a multi layer/color jpg doesn't play well with this control. A monochrome jpg might work as well.
    An image control apparently works better, but you have to update the path of the linked image for each record. It also allows you to access the image without embedding it in a table, which is something I'd avoid if at all possible.
    Last edited by Micron; 02-22-2018 at 06:20 PM. Reason: added info
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I've never had good experience with the OLEObject controls. I use Image control. Set its ControlSource property to Attachment field or external file path.
    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.

  4. #4
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    @ June7 -- Please forgive my ignorance: Attachment field or external path? Not sure where to find that. I found the control source.
    Click image for larger version. 

Name:	Capture.GIF 
Views:	20 
Size:	23.5 KB 
ID:	32802
    I tried Micron's suggestion of using a bitmap, but that was not successful. Thank you though, Micron, for responding.

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Bind Image control to the text field with the external file path.

    Why have both the path and embedded object?

    Embedding a lot of files can quickly use up Access 2GB size limit.

    An OLEObject field is not an Attachment field.
    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.

  6. #6
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    To answer your question: Path and embedded object fields were used to illustrate that I had attempted both methods and neither have worked.

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Image control referencing path in ControlSource always works for me.
    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.

  8. #8
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    As indicated in the image, I set up the path and used image control. However, the image does not display on the form. What am I doing wrong?
    Click image for larger version. 

Name:	olebound.GIF 
Views:	19 
Size:	78.0 KB 
ID:	32821

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Image shows properties of an OLEObject not an Image control.
    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.

  10. #10
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243

    Zipped file attached....... I think.....

    Thank you. Forgot to mention: See tblStudent and FrmStudent.
    Attached Files Attached Files

  11. #11
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I may have edited my earlier post after you read it. So before I download your file, did you try an Image control instead of OLEObject control? When you add an Image control, a file dialog will open, just cancel it then set ControlSource property.
    Last edited by June7; 03-02-2018 at 11:45 AM.
    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.

  12. #12
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    Quote Originally Posted by June7 View Post
    I may have edited my earlier post after you read it. So before I download your file, did you try an Image control instead of OLEObject control? When you add an Image control, a file dialog will open, just cancel it then set ControlSource property.
    1. Yes I tried image control. The field entitled IMAGES will not display in the properties box, even though I have a field named IMAGES in the tblStudent.
    2. To further complicate matters -- Please disregard the file I sent. My apologies but it's the wrong one.
    3. To further, further complicate matters; When I try to upload the correct file, named ZippedDissertation, I can never find it in the forum's Upload Manager.

  13. #13
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    All weird. Since I cannot replicate issue, really have to view your db to analyze.

    In post 8 you say you tried an Image control yet the image shows the property sheet for an OLEObject control.

    Here is a db that demonstrates the Image control.
    Attached Files Attached Files
    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. Replies: 19
    Last Post: 09-29-2016, 06:51 AM
  2. Replies: 4
    Last Post: 05-02-2016, 04:33 AM
  3. Replies: 3
    Last Post: 02-27-2012, 05:10 PM
  4. Replies: 1
    Last Post: 08-05-2010, 12:11 PM
  5. inserting bound pictures
    By inquisitive in forum Access
    Replies: 1
    Last Post: 01-09-2006, 09:59 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