I've adopted legacy code (yech!) that requires a lot of debugging & enhancement. This is an MS Access "application" so I'm using VBA to do all this. I thought it'd be great if I could have users click a control, form, whatever, with the right mouse button and have a bug-report form pop up allowing him/her to enter data about the item in question. I accomplished this by using GetAsyncKeyState(VB_RBUTTON) in a timer sub. Works great. EXCEPT for one thing, and you probably already know what that is. Because GetAsyncKeyState is an API, my pop-up dialog will show itself when the right button is clicked NO MATTER WHAT APPLICATION the user has active. So if he/she has my app running, then goes to Internet Explorer and right clicks, well, you know. Obviously this is NOT what I want to happen. I do not want bug reports for Internet Explorer. I only want my bug form to show up if my app has focus. I tried the Screen object to determine what has focus, but this doesn't work because at the time I query this object, Access will always be the active app, since this is when the code is executing from. Variations on GetKeyState don't help either. Suggestions, please? At least a point in the right direction? Thanks. I'm gonna go call Hair Club now....
|