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

OLE information from OLE field

P: n/a
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
Share this Question
Share on Google+
6 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.