Implementing CallBack functionality in Access

[SteveJR]

Help!!!

Does anyone know how to implement CallBack functionality in Access?

I want to use the VB WindowProc module to monitor OS events but the only way to set up the hook to this module is to have a call as follows:

Public Sub Hook(hWnd As Long)
lngHWnd = hWnd
lpPrevWndProc = SetWindowLong (lngHWnd, GWL_WNDPROC, AddressOf WindowProc)
End Sub

However, the AddressOf call is not allowed in Access/VBA. So what do you use instead??????

Any help would be much appreciated.

Thanks,

Steve

 

[wynoski]

Steve,

I'm having the exact same problem... did you ever find a solution? If so, would you mind sharing with a frustrated programmer?

Thanks!