Re: About vba method

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have the same problem but in access 2003:
http://groups.google.co.il/group/microsoft.public.access.formscoding/browse_thread/thread/a6b865db35dc5c86/beb6c1678286cc23?lnk=st&q=Drag+and+Drop+file+vba+ms+access&rnum=7&hl=iw#beb6c1678286cc23

What do you think about this link?? is this a solution???
http://groups.google.co.il/group/microsoft.public.access.modulesdaovba/browse_thread/thread/354c9d4b0e5c9ea7/d1350a17ea31bf5e?lnk=st&q=Drag+and+Drop++file+ms+access&rnum=9&hl=iw#d1350a17ea31bf5e


"Alex Dybenko" wrote:

then you don't need code for AddressOf Operator, it should work in Access
2003

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


"yael" <yael@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:08238930-7278-4945-AEB4-EB03B1A2A43C@xxxxxxxxxxxxxxxx
Thank you sooo
I'm using in ms access 2003,
So I don't need to use user form?
This link needs addressOf......................


"Alex Dybenko" wrote:

Hi,
looks like http://www.mvps.org/access/api/api0032.htm is what you need,
but
AddressOf code you found - is for Access 97. Which access version you
using?


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

"yael" <yael@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3328608D-DCAB-4D75-905B-24E833B264C3@xxxxxxxxxxxxxxxx
Thank's for your replay Alex,
1) In tring to to create user form as in youy link, I don't found this
in
my
access dtabase:
Choose the Shortmenu’s titled (Misc ~ Project Window ~ Insert)

2) About the Ole:
Why ole object don't know to get by drag-and-drop a virtual files like
outlook email attached files from the clipboard?

3)Am I need this example or userform for my goal? my goal is the user
could
drag-and-drop all files into the form as full path text or something
lige
that.
As in this ** vb ** example but:
http://reliableanswers.com/vb/samples.asp
OLEDragDrop.zip
When I'm running this Drag and Drop from Explorer in ms access 2003.
http://www.mvps.org/access/api/api0032.htm
I added this code because of " In order to test the code in this
article,
you will need the AddressOf code as well."
http://www.vbmonster.com/Uwe/Forum.aspx/vb-winapi/2508/Addressof-and-VBA
When I'm running I get RT error "file not found: vba332.dll"
Thank's alottttt!
Yael




"Alex Dybenko" wrote:

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