Re: About vba method

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.
>> >
>>
>>



.