R
Ron Weiner
I appears to me that MS Access is not a Drag Drop friendly place. I see no
intrinsic support for Drag Drop operations in Access like that found in VB6.
I am using code found here http://www.mvps.org/access/api/api0032.htm to
allow users to drag and drop files into my Access 2K application. I have
got to confess I am not enough of Win API Guru to really understand exactly
how or even why this code works.
That said, I can tell you that this code "Works Like a Champ" allowing my
users to drag and drop files from a variety of sources into the application.
The only "Snag" to date is that it refuses to accept attachments dragged
directly from Outlook email messages. Basically, the attachment when
dragged from the Outlook Email, stays a slashed circle over the target form,
indicating that a drop is not supported here. If the user Drags Drops the
attachment from the Outlook Email to the desktop and then re-drag drop it
over the target in my application all is well. I do NOT have any problems
with Outlook Express attachments. They can be dragged directly from the
Email message to my drop target without problem. I have not tested other
Email applications.
Sooo.... I am surmising that the problem is in the way Outlook handles drag
drop operations. Is anyone out there familiar with this problem? I started
Goggling and found only a couple of hits that were on target, but alas
neither of them is a VB/VBA solution.
For those of you who are interested have a look at:
http://www.devnewsgroups.net/link.aspx?url=http://codeproject.com/csharp/TestEmailDragDrop.asp
for a C# solution or:
http://www.codeguru.com/Cpp/I-N/internet/email/article.php/c3381/ for a VB
solution with a helper DLL created in C.
I am hoping that some of you RSG's (Really Smart Guys/Gals) out there have
either run into this before, and have a ready made solution, or are willing
to pick up the gauntlet and see if you can find a solution.
For now I am asking my customer to use the Double Drop method, so we are up
and working, but this solution is "just wrong". Any help you folks can
provide will be most appreciated.
Ron W
intrinsic support for Drag Drop operations in Access like that found in VB6.
I am using code found here http://www.mvps.org/access/api/api0032.htm to
allow users to drag and drop files into my Access 2K application. I have
got to confess I am not enough of Win API Guru to really understand exactly
how or even why this code works.
That said, I can tell you that this code "Works Like a Champ" allowing my
users to drag and drop files from a variety of sources into the application.
The only "Snag" to date is that it refuses to accept attachments dragged
directly from Outlook email messages. Basically, the attachment when
dragged from the Outlook Email, stays a slashed circle over the target form,
indicating that a drop is not supported here. If the user Drags Drops the
attachment from the Outlook Email to the desktop and then re-drag drop it
over the target in my application all is well. I do NOT have any problems
with Outlook Express attachments. They can be dragged directly from the
Email message to my drop target without problem. I have not tested other
Email applications.
Sooo.... I am surmising that the problem is in the way Outlook handles drag
drop operations. Is anyone out there familiar with this problem? I started
Goggling and found only a couple of hits that were on target, but alas
neither of them is a VB/VBA solution.
For those of you who are interested have a look at:
http://www.devnewsgroups.net/link.aspx?url=http://codeproject.com/csharp/TestEmailDragDrop.asp
for a C# solution or:
http://www.codeguru.com/Cpp/I-N/internet/email/article.php/c3381/ for a VB
solution with a helper DLL created in C.
I am hoping that some of you RSG's (Really Smart Guys/Gals) out there have
either run into this before, and have a ready made solution, or are willing
to pick up the gauntlet and see if you can find a solution.
For now I am asking my customer to use the Double Drop method, so we are up
and working, but this solution is "just wrong". Any help you folks can
provide will be most appreciated.
Ron W