473,386 Members | 1,830 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,386 software developers and data experts.

OLE information from OLE field

When I open the table directly, I can see "MS PhotoEd.3"
Sometimes when the field is selected, I see "Microsoft Photo Editor 3.0
Picture"

Is there anyway I can use VBA to get this information? I haven't had any
luck trying things on a bound control like

Me.Label5.Caption = Me.ctl_ole.OLEClass
Me.Label6.Caption = Me.ctl_ole.SourceItem

(david)

Nov 17 '05 #1
6 2301
From a quick check you can
Check the control.class property
Look in the registry under HKEY_CLASSES_ROOT to find the class property
Check the (Default) value

This should give the description you are looking for I believe.
--
Terry Kreft

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:43**********************@lon-reader.news.telstra.net...
When I open the table directly, I can see "MS PhotoEd.3"
Sometimes when the field is selected, I see "Microsoft Photo Editor 3.0
Picture"

Is there anyway I can use VBA to get this information? I haven't had any
luck trying things on a bound control like

Me.Label5.Caption = Me.ctl_ole.OLEClass
Me.Label6.Caption = Me.ctl_ole.SourceItem

(david)

Nov 18 '05 #2
David were you able to resolve this issue? I am just putting the finishing
touches on an OLE object extractor and have code to access the object's Name
and ClassName info if you need it.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:43**********************@lon-reader.news.telstra.net...
When I open the table directly, I can see "MS PhotoEd.3"
Sometimes when the field is selected, I see "Microsoft Photo Editor 3.0
Picture"

Is there anyway I can use VBA to get this information? I haven't had any
luck trying things on a bound control like

Me.Label5.Caption = Me.ctl_ole.OLEClass
Me.Label6.Caption = Me.ctl_ole.SourceItem

(david)

Nov 30 '05 #3
Yes please :~)

The users found that by setting the Screen Resolution they
could control the Printer Resolution of the bitmaps, so they
stopped looking for a fix, and I stopped trying to identify
the application which was responsible for display and print.

But if you can identify any useful information, I will definitely
use it. At minimum, I'd like to identify what they are doing,
so that we can tell other people not to do it.

(david)

"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com>
wrote in message news:Oy**********************@ursa-nb00s0.nbnet.nb.ca...
David were you able to resolve this issue? I am just putting the finishing
touches on an OLE object extractor and have code to access the object's
Name and ClassName info if you need it.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:43**********************@lon-reader.news.telstra.net...
When I open the table directly, I can see "MS PhotoEd.3"
Sometimes when the field is selected, I see "Microsoft Photo Editor 3.0
Picture"

Is there anyway I can use VBA to get this information? I haven't had any
luck trying things on a bound control like

Me.Label5.Caption = Me.ctl_ole.OLEClass
Me.Label6.Caption = Me.ctl_ole.SourceItem

(david)


Dec 12 '05 #4
Van
Hi, I am creating an access data base and need to display over 8,000
jpg images. How can I display my images from a folder in a form?

Dec 13 '05 #5
David I am hoping to post the project later tonight.
:-)
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:43***********************@lon-reader.news.telstra.net...
Yes please :~)

The users found that by setting the Screen Resolution they
could control the Printer Resolution of the bitmaps, so they
stopped looking for a fix, and I stopped trying to identify
the application which was responsible for display and print.

But if you can identify any useful information, I will definitely
use it. At minimum, I'd like to identify what they are doing,
so that we can tell other people not to do it.

(david)

"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com>
wrote in message news:Oy**********************@ursa-nb00s0.nbnet.nb.ca...
David were you able to resolve this issue? I am just putting the
finishing touches on an OLE object extractor and have code to access the
object's Name and ClassName info if you need it.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:43**********************@lon-reader.news.telstra.net...
When I open the table directly, I can see "MS PhotoEd.3"
Sometimes when the field is selected, I see "Microsoft Photo Editor 3.0
Picture"

Is there anyway I can use VBA to get this information? I haven't had
any
luck trying things on a bound control like

Me.Label5.Caption = Me.ctl_ole.OLEClass
Me.Label6.Caption = Me.ctl_ole.SourceItem

(david)



Dec 13 '05 #6
Published last night.
http://www.lebans.com/oletodisk.htm

NEW - Dec 14/2005 ExtractInventoryOLE.zip A2K or higher ONLY! This
version saves the entire contents of a table containing OLE Objects to disk.
Does NOT require the original application that served as the OLE server to
insert the object. Supports all MS Office documents, PDF, All images
inserted by MS Photo Editor, MS Paint, and Paint Shop Pro. Also supports
extraction of PACKAGE class including original Filename. Contains function
to produce a full Inventory of the OLE field including LINKED path and
Filenames. Uses Structured Storage API's to read the actual contents of the
field.Version BETA 1.55
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com>
wrote in message news:%2***************@TK2MSFTNGP12.phx.gbl...
David I am hoping to post the project later tonight.
:-)
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:43***********************@lon-reader.news.telstra.net...
Yes please :~)

The users found that by setting the Screen Resolution they
could control the Printer Resolution of the bitmaps, so they
stopped looking for a fix, and I stopped trying to identify
the application which was responsible for display and print.

But if you can identify any useful information, I will definitely
use it. At minimum, I'd like to identify what they are doing,
so that we can tell other people not to do it.

(david)

"Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com> wrote in
message news:Oy**********************@ursa-nb00s0.nbnet.nb.ca...
David were you able to resolve this issue? I am just putting the
finishing touches on an OLE object extractor and have code to access the
object's Name and ClassName info if you need it.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:43**********************@lon-reader.news.telstra.net...
When I open the table directly, I can see "MS PhotoEd.3"
Sometimes when the field is selected, I see "Microsoft Photo Editor 3.0
Picture"

Is there anyway I can use VBA to get this information? I haven't had
any
luck trying things on a bound control like

Me.Label5.Caption = Me.ctl_ole.OLEClass
Me.Label6.Caption = Me.ctl_ole.SourceItem

(david)




Dec 14 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: A.Kelly | last post by:
Two problems that I'm having (due to being a n00bie) are: The form I'm using is the basic form with a username, email address etc.. the two that I'm most concerned about are the Gender, and...
6
by: btopenworld | last post by:
I have an access database with lots of fields including a memo field called 'priecinfo'. Everything works well, lots of data is written, but in one particular situation, I can't get the field...
5
by: Sami | last post by:
Please bear with me, and if you answer this question, please do it step by step. I am new at Access, not at all sophisticated. I am using Office XP. This will need to be read in Access for...
3
by: Earthling | last post by:
Any help would be appreciated to solve the following simple problem that I will describe. *** There is a form called "red chocolate form". The form has a particular subform field that has a...
4
by: Omey Samaroo | last post by:
Dear Access Gurus, Can anyone provide me with some much needed assistance. I would like to combine the contents of 3 text fields into one field. Can someone provide some code or a method to do...
1
by: WillieW | last post by:
Hi folks, I have Access 97 and have set up four tables, each with a Primary Key with a file name manually entered. For example, the four tables relate to information stored in a paper file, on...
22
by: Sandman | last post by:
So, I have this content management system I've developed myself. The system has a solid community part where members can register and then participate in forums, write weblogs and a ton of other...
2
by: Kanashii | last post by:
First off - I want to thank all who respond / try to help out and even those who took a moment to read over my question. Please be patient as I am -very- new to VB in general and unfortunately...
1
by: jcocomo | last post by:
Hi there. I am quite new to MS-Access and databases in general, so please bear with me if this is a very basic question. I am trying to create a database in Access 2000 that will track patients as...
4
by: justice750 | last post by:
Hi All, I am using a FormView control. The allows me to update records in the database. However, when a database field is null I can not update the field on the form. It works fine when the field...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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?
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
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.