By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,556 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Debug window: How to change keys that open it

P: n/a
Hello all,

I'm using A97 and W2k.

We have a little problem here. Sometimes (often?), users (all
co-workers) are hitting <ctrl>-G by mistake and are stucked in the
debug window. I would like to change the keys (<shift><ctrl>-G or
something like that) that open this window. And I really want to be
able to open it when I (the programmer) want it.

Anybody has a solution for me to do that?

Thanks for your time.

Yannick

May 11 '06 #1
Share this Question
Share on Google+
11 Replies


P: n/a
On 11 May 2006 06:45:56 -0700, "Yannick Turgeon"
<ve********@gmail.com> wrote:

You can intercept Ctrl+G or any other keystroke with an AutoKeys
macro. Just don't put any action for that keystroke.
Then the programmer can still use Alt+F11 to get to the code window.

-Tom.

Hello all,

I'm using A97 and W2k.

We have a little problem here. Sometimes (often?), users (all
co-workers) are hitting <ctrl>-G by mistake and are stucked in the
debug window. I would like to change the keys (<shift><ctrl>-G or
something like that) that open this window. And I really want to be
able to open it when I (the programmer) want it.

Anybody has a solution for me to do that?

Thanks for your time.

Yannick


May 11 '06 #2

P: n/a
Hello Tom,

Thanks to reply.

Your suggestion would be just perfect for my problem, but it seems that
Alt+F11 do not work to bring the debug window. Do I have to do
something special to make it work? Any other Idea? How I could, through
AutoKeys marco, settup a key sequence to bring the debug window. I
looked to the different actions and I didn't find something to do this.

Yannick

May 11 '06 #3

P: n/a
Alt-F11 takes you to the VBIDE you can then press Ctrl-G to get ino the
immediate window.

--

Terry Kreft
"Yannick Turgeon" <ve********@gmail.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
Hello Tom,

Thanks to reply.

Your suggestion would be just perfect for my problem, but it seems that
Alt+F11 do not work to bring the debug window. Do I have to do
something special to make it work? Any other Idea? How I could, through
AutoKeys marco, settup a key sequence to bring the debug window. I
looked to the different actions and I didn't find something to do this.

Yannick

May 11 '06 #4

P: n/a
Maybe it's doing that in A2K ? My version is A97 and Alt-F11 do
strictly nothing here.

Am I missing something evident here?!

Yannick

May 11 '06 #5

P: n/a
Hmm, can't check it on A97 until I get into the office on Monday. Any body
els help?

--

Terry Kreft
"Yannick Turgeon" <ve********@gmail.com> wrote in message
news:11*********************@j33g2000cwa.googlegro ups.com...
Maybe it's doing that in A2K ? My version is A97 and Alt-F11 do
strictly nothing here.

Am I missing something evident here?!

Yannick

May 11 '06 #6

P: n/a
"Terry Kreft" <te*********@mps.co.uk> wrote in
news:eh********************@karoo.co.uk:
Hmm, can't check it on A97 until I get into the office on
Monday. Any body els help?

Capture {Alt}F11 and remap it to {ctrl}G.

--
Bob Quintal

PA is y I've altered my email address.
May 11 '06 #7

P: n/a
On Thu, 11 May 2006 22:09:16 +0100, "Terry Kreft"
<te*********@mps.co.uk> wrote:

This worked for me in A97:
Create AutoKeys macro with MacroName=^G, Action=RunCode,
FunctionName=DebugWindowIfDeveloper()

In a module:
Public Function DebugWindowIfDeveloper()
If GetLoggedInUserName() = "Tom" Then RunCommand acCmdDebugWindow
End Function

GetLoggedInUserName calls a Windows API function to get the name of
the logged in user.

-Tom.

Hmm, can't check it on A97 until I get into the office on Monday. Any body
els help?


May 12 '06 #8

P: n/a
"Terry Kreft" <te*********@mps.co.uk> wrote in
news:Jd********************@karoo.co.uk:
Alt-F11 takes you to the VBIDE you can then press Ctrl-G to get
ino the immediate window.


No need for the Alt-F11 -- Ctrl-G takes you directly to it from the
Access window.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 12 '06 #9

P: n/a
"Yannick Turgeon" <ve********@gmail.com> wrote in
news:11*********************@j33g2000cwa.googlegro ups.com:
Maybe it's doing that in A2K ? My version is A97 and Alt-F11 do
strictly nothing here.

Am I missing something evident here?!


There is no VBE window in A97, so there's no need for the Alt-F11 --
just hit Ctrl-G.

Indeed, there's no need for the Alt-F11 in A2K (can't test it on any
later versions, since I don't have them installed on this machine),
either -- all that's required in the Access window is Ctrl-G.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 12 '06 #10

P: n/a
Hello Tom,

Your solution does just what I wanted. Thanks a lot!

Yannick

May 12 '06 #11

P: n/a
"David W. Fenton" <XX*******@dfenton.com.invalid> wrote in
news:Xn**********************************@127.0.0. 1:
"Terry Kreft" <te*********@mps.co.uk> wrote in
news:Jd********************@karoo.co.uk:
Alt-F11 takes you to the VBIDE you can then press Ctrl-G to
get ino the immediate window.


No need for the Alt-F11 -- Ctrl-G takes you directly to it
from the Access window.


David, the original poster's statement was
We have a little problem here. Sometimes (often?), users (all
co-workers) are hitting <ctrl>-G by mistake and are stucked in
the
debug window. I would like to change the keys...Anybody has a
solution for me to do that?

So everybody already knows about CTRG-G.

What would you suggest about remapping or otherwise protecting
the casual user, while allowing developer accessability?

--
Bob Quintal

PA is y I've altered my email address.
May 12 '06 #12

This discussion thread is closed

Replies have been disabled for this discussion.