Code for VBA 2003 for viewing an OLE that resides in a Table Cell

[moo]

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?

[ahmorrow]

So you're trying to grab data from table on an Access database?

[moo]

The documents are embedded in a table on an Access DB. Which document I need to see depends on what is in the Names field on the Access Form.

I compare the displayed name from the form to the name in the table and then I want to select and open the document that is associated with it.

???

[moo]

Nevermind.....it can't be done that way. The solution was to embed all the documents into a Form instead of a table. The file size ends up to be ginormous but, whatever.