Autokeys Glitches in form

[djugene188]

First off, I want to thank the forum(s) -- this place has been a tremendous help with my project by searching for the answers.
Here's something I can't find though....

I have a main form in Access 2000 that I have set to yes for Key Preview. The On Key Press event is set to autokeys. The autokeys macro is ^+s which is set to open a search form.

The autokeys combination works -- but so does hitting the {TAB} key, or any other letter in the combination (like SHIFT + INSERT + G, or SHIFT + INSERT + T) will bring up the search form. I would like for only the assigned combinations to work.

Has anyone ever experienced this? Any suggestions would be much appreciated.

Thanks
DJ

 

[TheAceMan1]

How are ya djugene69 . . .

Be aware: [blue]Autokeys[/blue] has a higher precedence than forms (aka key presses pass thru autokeys first)! Without any form open, you should be able to open the search form with your keys [blue]^+s[/blue]

Since autokeys has the higher precedence, you don't need any form key events prescribing those keys which already reside in autokeys.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[djugene188]

Thanks for the reply, TheAceMan1 ----

Unfortunately, Autokeys doesn't work for some reason unless I turn on the Key Preview and select the autokeys in the On Key Press event. (And then I also get all of the un-wanted keys). I can activate the Macro from the Objects listing page but not from inside the form...

I've started to look into the KeyAscii as Integer on the key press event and that is kind of working, but I don't know how to code the CTRL + (Ascii)keys

I can get a select case to work with single Ascii key and a message box, but not a combination yet.

For instance :

Select Case KeyAscii
Case 106
KeyAscii = 0
MsgBox "U Pressed the j"
End Select

will work, but I can't seem to get the CTRL to be part of it.

Thanks for your input.
Dj