Re: About vba method

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,
unfortunately - there is no OLEDragDrop event in access textbox, so you can;t use this code in access control. But you can try to build a VBA UserForm, and then show in in access
see http://vb123.com/toolshed/03_map/userforms.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


"yael" <yael@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:7AE342CD-34D5-4828-A505-162CDE5855F5@xxxxxxxxxxxxxxxx
http://vbadud.blogspot.com/2007/05/drag-drop-files-to-text-box.html
Hi,
I'm using vba and access.
How can I get this method in vba?(as in this link)

Code SnippetPrivate Sub TextBox1_OLEDragDrop(Data As DataObject, Effect As
Long, Button As Integer, Shift As Integer, X As Single, Y As Single)

I don't care if it will be for TextBox1 object or hyperlink or ole.
My goal is to get Data.GetFormat!
One more quetion:
Why ole object don't know to get a virtual files like outlook email attached
files?
I need this code in vba
http://www.codeproject.com/vb/net/ExpTreeDragDrop.asp#xx1228231xx
Thanking you in anticipation,
Yael.


.

Quantcast