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