Is there any other way (i.e by Code) to open an OLE Object than double click?

Hi:  
I have a table with the name of "tblSetings" contains field with the name "HelpFile" and OLE Object type.
It contains an ms word document with the name of "TicketOrdersHelp.doc"
I need to open this word document when press on a picture  control on my form?
How come please
Notice: my form is based on another table . so I can not make this "tblSetings" as my form row source.
This table " tblSetings" is one record only contains all my constant values which is allow to the admin user to change when needed.
Mohammad Alsolaimanapplication programmerAsked:
Who is Participating?
 
als315Commented:
Yes, but may be better to create separate form with this field and open it:
http://www.dbforums.com/microsoft-access/1629613-open-ole-object-vba.html
0
 
als315Commented:
"my form is based on another table . so I can not make this "tblSetings" as my form row source"
But you can add small subform with this field.
0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
"But you can add small subform with this field."
And hide it, then call the double click of that OLE control on that hidden subform, when clicking the picture control?
Is that true?
0
 
als315Commented:
Look sample
 DBOLE.mdb
But may be better to use hyperlink if file is not embedded?
0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
wonderful response
thanks a lot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.