By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,477 Members | 1,627 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,477 IT Pros & Developers. It's quick & easy.

Names of OLE objects

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.
Nov 12 '05 #2

P: n/a
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.

Nov 12 '05 #3

P: n/a
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.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.