When I navigate from the bound object box to the file, it returns the image icon instead of the actual image.
When I navigate from the bound object box to the file, it returns the image icon instead of the actual image.
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.
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.
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.
To answer your question: Path and embedded object fields were used to illustrate that I had attempted both methods and neither have worked.
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.
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.
Thank you. Forgot to mention: See tblStudent and FrmStudent.
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.
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.
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.
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.