473,397 Members | 1,969 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Embedded image as an OLE Object in table doesn't display in form. Why?

176 100+
Hello all.

I created an Image field in a table. I set it to be an OLE Object data type. Later I viewed the table in datasheet view and insereted an image to each row of the Image field. Then I created a form based on that table, with a Bound Object Frame control to display [Image]. However, when I view the form it only displays a white box with the image file name.

Why is it so. How can I display it properly, using the OLE Object data type?


Please help,
Michael.
Apr 29 '08 #1
3 14296
nico5038
3,080 Expert 2GB
It's best to store images as so-called BLOB's and not as OLE-objects as they consume extra space and have some nasty side effects.

Checkout:
http://www26.brinkster.com/alzowze/home.asp (See samples on lefthand side)
http://www.jamiessoftware.tk/article...ingimages.html

Nic;o)
May 1 '08 #2
puppydogbuddy
1,923 Expert 1GB
Hello all.

I created an Image field in a table. I set it to be an OLE Object data type. Later I viewed the table in datasheet view and insereted an image to each row of the Image field. Then I created a form based on that table, with a Bound Object Frame control to display [Image]. However, when I view the form it only displays a white box with the image file name.

Why is it so. How can I display it properly, using the OLE Object data type?


Please help,
Michael.
You can go to the Employees form in the Northwind Sample DB that comes with Access and compare the setup with yours. The property settings for the bound object frame should look something like the following. Am assuming that the ole field name is Photo for purposes of illustration:

Name = Photo
Control Source = Photo
Display type = Content
OLE Type Allowed = Either
Visible = Yes
Enabled = Yes
Locked = No
May 1 '08 #3
FishVal
2,653 Expert 2GB
It's best to store images as so-called BLOB's and not as OLE-objects as they consume extra space and have some nasty side effects.
....
Just one more link:
The BLOB (not the movie!)
May 1 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

10
by: Peter Pfannenschmid | last post by:
Hi folks, it's me again... since I have learned many things with the help of you, I have put together an example which is compliant to XHTML 1.0 strict and to CSS 2, but isn't shown at all in...
2
by: chaitatp | last post by:
Hi guys, I have posted a similar question before but this post has some different. The similar link is: ...
8
by: Smartin | last post by:
I have a form in Access97 which facilitates a query against a production Access database. Users will enter some search terms and see a datasheet view of the results in a subform. The prod table is...
7
by: Robert W. | last post by:
I think I'm going insane, but thought I'd check with you all first before I get myself commited! Here's a method I've built to retrieve an image: public static Image GetImage(string...
1
by: Joe | last post by:
I created a user control that I need to use in a web page but the control doesn't display. I added it to my page using: <object id="testcontrol"...
0
by: Deepak C.G via .NET 247 | last post by:
I want to dispose the image object in my child form, unless I won't dispose this object i can't delete the image file in my folder. I get this error in MDIparent form "An unhandled exception...
4
by: rszebras | last post by:
I inherited a database (as a novice at Access) and need to modify it to make it more efficient, i.e., the assignment form needs to autopopulate with the client's name, address, phone number, etc.,...
0
by: norseman | last post by:
Daniel de Sousa Barros wrote: ================================================ Click Start/settings/control panel/system/advanced/settings(in \ performance area)/advanced/change set System...
7
by: Vikki McCormick | last post by:
I have an old database which was developed over time and contains forms with a variety of formats, and the owners would like the user interface updated to a new design. I had a lot of forms and...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.