Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 540
  • Last Modified:

access shortcut keys conflict

Dear experts -
I have a form where I want to add shortcut keys to a few buttons - e.g., "&M" "&E" etc.
What is happening is that when I press ALT+the designated letter, it is invoking an Access menu (and prompting me to add another letter to choose the option).
Is this a setting I need to change somewhere?
Thanks!
0
terpsichore
Asked:
terpsichore
2 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What version of Access are you using? There have been some issues with hotkeys in recent versions ...
0
 
Dale FyeCommented:
You could also write your own "Hot Key" process for a particular form by setting the Forms KeyPreview property to Yes.

Then use the KeyDown event to trap for specific key combinations.  If one of your specified combinations is found, then set the KeyCode value to 0 and then call the function or subroutine you want to use.
0
 
terpsichoreAuthor Commented:
I'm using Access 2010; some users are using 2007
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
peter57rCommented:
"I'm using Access 2010; some users are using 2007 "

You won't get far with that arrangement.  You need to be developing in A2007 if you have A2007 users.
0
 
terpsichoreAuthor Commented:
it's been working well for the last few years...
0
 
terpsichoreAuthor Commented:
Found the answer - you need to unselect "default shortcut menus" in the options for current database... (unfortunately, we like to use these, so I will have to find out which key combinations do not conflict)...
0
 
terpsichoreAuthor Commented:
see my final note - this was the root cause
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"I'm using Access 2010; "
Well, what LSM said is still correct. I can guarantee you that Access Hot Key behavior has been negatively affected by the Ribbon - for sure.

There is a long standing bug report on a specific instance that Microsoft is well aware of ... and apparently - quote: "the chance of this getting fixed is zero" :-(

I has to do with using hot keys on controls (like a button) where the button is on a Tab Control. ALT+<HotKey) does nothing, zero. :-(

So, you are stuck doing what fyed suggested. Extremely annoying.
0
 
terpsichoreAuthor Commented:
many thanks to all - in fact - I did find another solution, which a friend suggested and was the last thing I would have considered - you need to HOLD DOWN the alt key - I was releasing it too soon and it was invoking the Access menus! if you hold down the alt key and then the shortcut, it works fine...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now