By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,028 Members | 1,825 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,028 IT Pros & Developers. It's quick & easy.

OLE problem with A2002

P: n/a
I posted this (with a different subjetc line) in the ms.public.access.forms
newsgroup a few days ago, but haven't had a single response there. I'm
hoping maybe someone here can help.

Using Access 2002:
I have downloaded a tutorial database, which has a form containing a bound
object frame to display a picture. The picture field in the underlying
table has an OLE Object datatype, and when a picture is inserted (either
directly into the table, or via the form), the table entry contains the term
"Package". The pictures which are available to be inserted into the
database (as steps in the tutorial) are .bmp files. My problem is that the
form displays both the picture (in what appears to be a thumbnail format)
and its filename (only the filename - the path is not included) in the bound
object frame. I've never seen this behaviour before (I've got several
databases which display pictures, via several different methods), and I
can't find any obvious property which is causing this behaviour.

Any suggestions? BTW, the supplied .bmp files contain only a picture - the
text is not part of the image!

TIA,

Rob
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Oops, forgot to add some other stuff I've discovered since original post to
other NG:

The database was originally in A97 format, which I converted to A2000 format
(that's what I had set in my Options|Advanced tab - I'd done that some time
ago since I needed A2000 format for stuff I was doing at both work and
home), in A2002 SP3 on a Windows XP Home system (without SP2 - trying to
install that was a disaster!).

Running the original A97 database (on two different machines which both have
A97 installed, one with Win2000 and another with WinME) has the image
displaying correctly in the bound object frame.

Converting the original database to A2000 format, on the system with Win2000
and A2000, also displayed the image correctly.

Converting the original database to A2002 format on the WinXP/A2002 system
gives the same problem I originally asked about. Well, almost identical -
the thumbnail and filename were displayed slightly differently,
left-justified in the bound object frame, and the text font was different.
Note: the bound object frame has no properties to set these formatting
options.

My conclusion is that the problem arises in either WinXP Home of Access 2002
(aka Access XP), rather than in the actual format of the database. Is this
a known problem?

Once again, any help or comments would be greatly appreciated.

Rob

"Rob Parker" <robpparker AT optusnet.com.au> wrote in message
news:42**********************@news.optusnet.com.au ...
I posted this (with a different subjetc line) in the ms.public.access.forms newsgroup a few days ago, but haven't had a single response there. I'm
hoping maybe someone here can help.

Using Access 2002:
I have downloaded a tutorial database, which has a form containing a bound
object frame to display a picture. The picture field in the underlying
table has an OLE Object datatype, and when a picture is inserted (either
directly into the table, or via the form), the table entry contains the term "Package". The pictures which are available to be inserted into the
database (as steps in the tutorial) are .bmp files. My problem is that the form displays both the picture (in what appears to be a thumbnail format)
and its filename (only the filename - the path is not included) in the bound object frame. I've never seen this behaviour before (I've got several
databases which display pictures, via several different methods), and I
can't find any obvious property which is causing this behaviour.

Any suggestions? BTW, the supplied .bmp files contain only a picture - the text is not part of the image!

TIA,

Rob

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.