HELP with AddrOf function for Drag-n-Drop

[Barmaley]

I was trying to implement drag-n-drop functionality in my database.
Reading from article http://www.mvps.org/access/api/api0032.htm it
referenced dependent function found here
http://www.trigeminal.com/lang/1033/codes.asp?ItemID=19#19
actual Excel file with sample code here
http://www.trigeminal.com/code/CallBacks.zip

When I try to run it I get "File not found VBA322.dll". Upon some research I
found that it belong to Office 97.
My system has VBAR322.dll which code doesn't accept.

If anybody made it work or knows how, please let me know how.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Running:
Win 2000 SP4
Office 2000 SP3
(if this is not enough, please tell me what I am missing)

AvP

 

[Michel Walsh]

Hi,

AddressOf is part of VBA6. If you have Access 2000, you should have
AddressOf natively available.


Hoping it may help,
Vanderghast, Access MVP

 

[GrahamT]

Dear AvP, have a look at the following posting

http://www.access-programmers.co.uk/forums/showthread.php?t=7277

Here it states

. . . in 2000 there is no need to use the AddressOf module becaus

AddressOf is common language. Simply replac

Code
Call EnumChildWindows(hWndParent, AddrOf("EnumChildClipProc") &H0)wit
Code
Call EnumChildWindows(hWndParent, AddressOf(EnumChildClipProc)

&H0). The AddressOf module is now redundant and you can remov
it
The Whole posting has lots of good info, so happy reading!

Cheers

GrahamT.[color=darkred:3c45cd7470][/color:3c45cd7470][color=darkred:3c45cd7470][/color:3c45cd7470

 

[Barmaley]

Thanks Graham,

You are right it was good reading
But that thread finished with no working db for Access 2000

I alredy spent too much time trying to make it work, but so far I wasn't
successful.
Digging Internet didn't bring much to chew on.
I couldn't even make MS examples work
(http://support.microsoft.com/?kbid=209898)

It seems that it takes more and more of my time, so I'll leave it for now
and come back later with fresher mind

AvP

Dear AvP, have a look at the following posting:

http://www.access-programmers.co.uk/forums/showthread.php?t=72775

Here it states:

. . . in 2000 there is no need to use the AddressOf module because

AddressOf is common language. Simply replace

Code:
Call EnumChildWindows(hWndParent, AddrOf("EnumChildClipProc"), &H0)with
Code:
Call EnumChildWindows(hWndParent, AddressOf(EnumChildClipProc),

&H0). The AddressOf module is now redundant and you can remove
it.
The Whole posting has lots of good info, so happy reading!!

Cheers,

GrahamT.[color=darkred:3c45cd7470][/color:3c45cd7470][color=darkred:3c45cd74
70][/color:3c45cd7470]