OLE information from OLE field

[david epsom dot com dot au]

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)

 

[Terry Kreft]

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.

 

[Stephen Lebans]

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]

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)

 

[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?

 

[Stephen Lebans]

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.

 

[Stephen Lebans]

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.