ACCESS FEED: Re: Bls: Bls: [MS_AccessPros] List of Class Property of OLE Object Control

Senin, 29 Oktober 2012

Re: Bls: Bls: [MS_AccessPros] List of Class Property of OLE Object Control

Thanks for sharing, Hendra.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: Agestha Hendra <agesthahendra@ymail.com>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Monday, October 29, 2012 12:19 AM
To: "MS_Access_Professionals@yahoogroups.com"
<MS_Access_Professionals@yahoogroups.com>
Subject: Bls: Bls: [MS_AccessPros] List of Class Property of OLE Object
Control

Thank you John,..
I have found a good solution, here is the codes to update the contains of
OLE Object, maybe usefull for everyone here,
Unbound/Bound object control is really good to use.. :)

With Me![OLEUnbound0]
' Specify what kind of object can appear in the field.
.OLETypeAllowed = acOLELinked
' Class statement--optional for Excel worksheet.
.Class = "Word.Document.8"
' Specify the file to be linked.
' Type the correct path name.
.SourceDoc = "d:\Pro_Unpro_All_She.doc"
' Range statement--optional for Excel worksheet.
'.SourceItem = "R1C1:R7C4"
' Create the linked object.
.Action = acOLECreateLink
' Optional size adjustment.
.SizeMode = acOLESizeZoom

i use it on form's event "on open", it's similiar to "refresh" if form's
source is from a query,...

Regards
Hendra

________________________________
Dari: John Viescas <JohnV@msn.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Senin, 29 Oktober 2012 1:29
Judul: Re: Bls: [MS_AccessPros] List of Class Property of OLE Object
Control

Hendra-

If you're changing an OLE Object, I think you have to first save the
record to see the new file.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: Agestha Hendra <agesthahendra@ymail.com>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Sunday, October 28, 2012 5:22 PM
To: "MS_Access_Professionals@yahoogroups.com"
<MS_Access_Professionals@yahoogroups.com>
Subject: Bls: [MS_AccessPros] List of Class Property of OLE Object Control

Thank you John,...

I have another problem,... i am trying to use wizard to specified the file
that i want to display on a form, the steps are :
Insert --- Object --- Create From File --- Browse to the file --- and chek
the "link"., it works fine but why the OLE object contains on the form
are not changed although i have made some changing into the linked
source file..? i thought if i chek the "link" is the same as using image
control (linked), so
everytime we change the image the image control on the form change
too...please direct me...Thank you

Regards
Hendra

________________________________
Dari: John Viescas <JohnV@msn.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Minggu, 28 Oktober 2012 22:58
Judul: Re: [MS_AccessPros] List of Class Property of OLE Object Control

Hendra-

This might be useful:

http://access.mvps.org/access/api/api0013.htm

You would need to open the "native" app for the file type with the file
open in it, then run the code to discover the name.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: "agesthahendra@ymail.com" <agesthahendra@ymail.com>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Sunday, October 28, 2012 4:49 PM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] List of Class Property of OLE Object Control

Hi All....

I am experiencing OLE Object Controls to display several files, it's
success with .xls and .doc file that using "Excel.Sheet" and
"Word.Document.8" for the class properties in vba codes. I need the list
of class properties to work with others files (images : png, JPEG, JPG,
Pdf, and all file type of MS Office 2007 (.xlsk, docx..).
Any helps would be appreciated...thank you

Regards
Hendra

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links