Auto Keys not working

[joeKra]

Hello,
i am trying to create an Auto keys Macro, should fire by hitting CTRL + [some letter] with the submacro macro , but for some reason it is not working, nothing will happen, did Access 2010 has some limitations, ( i didn't update to sp1 due to various bugs known....)
any help is appreciated !

 

[Mr. B]

In your macro named AutoKeys add a "Submacro" and name it with the characters that represent the keys you want to use. For example: if you want to use Ctrl + the letter J then you would name the submacro ^J.

That works here for me in Access 2010.

 

[joeKra]

Thanks for reply !

this is exactly what i did but unfortunately it's not working, maybe it's a system setting...??

 

[Mr. B]

You might check your Macro Security Settings.

 

[joeKra]

where can i find the macro settings?

 

[Mr. B]

Click on File then Options. From the Options window, click on the "Trust Center" option at the bottom of the left side. From the Trust Center window, click on the "Trust Center Settings" button. Then click on the "Macro Settings" and make sure the "Enable all macros ...." options is selected.

You might also want to click on the "Trusted Location" option and sepecify the location of your database as a "trusted location".

 

[joeKra]

still not working !!

 

[Mr. B]

I assume you checked and set the Macro security.

I have very little idea as to what else to tell you, except to ask a few very basic questions:

Have you named your macro "AutoKeys"?
Have you added a submacro and named the to to the value you need: ie: if you wanted to use the Ctrl key and the letter "J" you would name the submacro: ^J

I just went through the steps above and created a new AutoKeys macro with the submacro named to use Ctrl + J and it works.

If the things that I have mentioned do not work, perhaps someone else may have some other suggestion.

One last thought or question: What are you having the submacro to do?

 

[joeKra]

i want it should open a form

 

[joeKra]

i checked with another computer and it works , i presume it's a cause of some software installed on my computer which is not on the other.... does it make sense?

 

[joeKra]

is it possible to check which software is occupying the CTRL key?

 

[Mr. B]

Try a different key combination and see if that fixes the problem.

 

[joeKra]

Nups......none of available combination are working

 

[shadow9449]

Sometimes that happens and you can re-enable Autokeys with this bit of code:

Global Const voKEY_ASSIGNMENT = "Key Assignment Macro"

Public Sub ResetAutoKeys()
  Application.SetOption voKEY_ASSIGNMENT, "Autokeys"
  
End Sub

Paste it into a module and press CTRL+G and type "ResetAutoKeys" and hit enter.

SHADOW

 

[joeKra]

YAH...... that did the trick !!!,

 

[shadow9449]

Excellent! Glad I could help.

Cheers

SHADOW

 

[joeKra]

Where can i find all setoption elements?