headware wrote:
I have a form that allows the user to either drag-and-drop or
copy-and-paste OLE objects into a data view table. When they do that
the OLE Object field always appears as something like "Microsoft Word
File" or "Package". Is there any way to capture the actual name of the
file? I've seen a number of posts related to this subject but none of
them seemed to quite answer my question.
Dave
Personally I prefer creating a Hyperlink field in the table. Then I can
use the FileOpen() function found at Dev's site (under Api's) at
http://www.mvps.org. I then have the name of the file. I can store a
description to describe the action and the filename path of the object
to open. Then you simply click on the object to open/view it. See
HyperLinkPart() in help. It keeps your table size down. I see no
benefit to storing the object in the table.