Names of OLE objects

[headware]

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

[Salad]

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.

[headware]

I agree that storing the objects themselves in the database is not a
good idea, but I have no choice in this particular matter. That's the
way they want it done.

Salad <oi*@vinegar.com> wrote in message news:<_J*****************@newsread1.news.pas.earth link.net>...

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.

[Salad]

headware wrote:

I agree that storing the objects themselves in the database is not a
good idea, but I have no choice in this particular matter. That's the
way they want it done.

I would either suggest they open the file, before appending, via a
FileOpen you provide or don't allow the saving of the record unless you
get the file name.

Also, check out google....maybe there is some code somewhere to help you
out.