April, Joe:
Me Too! I recently posted the essentially same question to
"microsoft.public.access.formscoding" and
"microsoft.public.access.modulescoding" and did not receive a single reply.
Here is my original post:
-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o Start
t -o-o-o-o-o-o-o-o-o-o-o-o-o-o-o
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 those 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.
-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o End
t -o-o-o-o-o-o-o-o-o-o-o-o-o-o-o
Perhaps you will find the link to
http://www.codeguru.com/Cpp/I-N/internet/email/article.php/c3381/ useful, in
that it is a VB solution that uses VB's standard (more or less I guess)
OLEDragOver and OLEDragDrop events to handle "Normal" files and "Outlook
Email Attachments".
For poor old me I am still stuck as I can not distribute another file (a
helper DLL) to all of the desktops that need to use this app, and Access
does not have anything that even smells like VB's OLEDragOver and
OLEDragDrop events. In fact the standard Access controls do not even have a
Hwnd. Sheesh!!!
I have spent a fair amount of time researching this problem, and these two
links are all that I was able to come up with. Pretty please with a cherry
on top please post back here if you find anything else that might even
remotely be applicable to my problem.
Thanks
Ron W
