Here is my problem:
I am using Access and VBA 2003. I have been successful using hyperlinks to a document's original location on our O:\ drive to display it when I click a button on a Form but want to try the embedded method instead. (i.e. OLE)
I have some Word documents with which I have associated Names. I have listed these Names and embedded the documents into 2 columns in an Access Table. The Access Form has a field that displays the Name for a given embedded document. I want to be able to click on the Button for the Name Field on the Access Form and have it display the Word Doc by reading the location as the cell containing the embedded doc in the Table.
I know that sounds confusing. Forget the "why I want to do this". It is someone else's project and I am just helping him figure it out. I say just hyperlink it but, whatever.
Is there code that can let you, basically, open what is in a Table cell? I know the DoCmd.OpenForm "SomeForm" and I know DoCmd.OpenTable "SomeTable" but I essentially need equivalent code for DoCmd.OpenCell "SomeCell".
Anyone?