DLL help..

[JT]

I'm calling the "sleep" function in VB script in Access.
I've declared the library as the following:

Declare Sub sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)

And then called sleep from a function:

Sleep(1000)

I get a run-time error 453 - Can't find DLL entry point...

I guess it can't find the sleep procedure in kernel32.dll..But where would it be? Any help would be appreciated thanks.

[Iain17]

Try declaring it like so...

Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long)

[Joacim Andersson]

No it exist in the Kernel32 library. The thing is that all API declarations are case sensitive. Make sure you declare it exactly like this:

Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

That is change sleep into Sleep with a capital S.

Good luck!

[JT]

You know what? It's working thanks. Funny thing. I did add the alias at first, but it automatically dissappeared everytime I added it. Now it stayed.

I also tried it with the S, not s. Thanks. i didn't realize it's case sensitive.

[Joacim Andersson]

VB always automatically takes away the alias if the alias is spelled exactly like the sub or function name. So in this case it would remove it:

Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long)

But in this way it would remain:

Public Declare Sub sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long)

Again it's because the declaration (on Win32) is case sensitive.