Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

access shortcut keys conflict

Posted on 2013-06-26
9
515 Views
Last Modified: 2013-06-26
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
Comment
Question by:terpsichore
9 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 39277477
What version of Access are you using? There have been some issues with hotkeys in recent versions ...
0
 
LVL 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) earned 250 total points
ID: 39277527
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
 

Author Comment

by:terpsichore
ID: 39277564
I'm using Access 2010; some users are using 2007
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 77

Expert Comment

by:peter57r
ID: 39277575
"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
 

Author Comment

by:terpsichore
ID: 39277606
it's been working well for the last few years...
0
 

Author Comment

by:terpsichore
ID: 39277621
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
 

Author Closing Comment

by:terpsichore
ID: 39277626
see my final note - this was the root cause
0
 
LVL 75
ID: 39278771
"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
 

Author Comment

by:terpsichore
ID: 39278800
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
corrupt Databases 9 65
update query 4 25
Developing database that gets updated from Excel. Looking for best approach 5 42
SetProperty Foreground Colour 5 14
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question