F5 Key Behavior

[dBjason]

Hello, and hope I'm not posting in the wrong place!

I have a legacy VB6 app that runs against a SQL Server 2008 database. Nothing too complex.

I also have two monitors. I like to keep the VB6 IDE maximized in one monitor, while having SSMS maximized in the other. This way I can troubleshoot the app and be able to see what's going on with the back end at the same time.

Of course, it's all great until I factor in the behavior of the F5 key.

F5 runs the VB6 application in one window, but it can also execute any SQL I have in SSMS. Whatever window has the focus, gets executed.

This is not good if disorganized me forgets which window has the focus. Happens frequently.

So I'm wondering -- Is there any way to change the F5 key to, say the F9 key in VB6? Or perhaps SQL?

Thanks in advance for any/all help!

Best Regards,
Jason

 

[gmmastros]

Might I suggest that you try to get yourself in to the habit of running VB6 in "Full Compile" mode. Instead of F5 to run VB6, use CTRL-F5 instead.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[dBjason]

...But I would have to more than double my key-pushing efforts.

Thanks for the idea, I may not have any other option. Lazy me!