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

Posted on 2011-10-21
Last Modified: 2012-05-12
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.
Question by:M_SOLAIMAN
    LVL 39

    Expert Comment

    "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.

    Author Comment

    "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?
    LVL 39

    Accepted Solution

    Yes, but may be better to create separate form with this field and open it:
    LVL 39

    Expert Comment

    Look sample
    But may be better to use hyperlink if file is not embedded?

    Author Closing Comment

    wonderful response
    thanks a lot

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now