Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access default shortcut keys 1

Status
Not open for further replies.

StuMunro

Programmer
Mar 2, 2001
29
GB
Access has predefined short cut keys such as

Ctrl-O - open db
Ctrl-N - new db
Ctrl-S - save object
Ctrl-P - print object.

My access application is supposed hide all access functionality by using custom menu/toolbars. I have switched off all the default menus/toolbars/special access keys options in the startup dialog.

How ever the above short cuts still work even though the menus are not there. I have found a way of stopping this by creating an AutoKeys macro and for each of the above running a blank command. This stops their functionality which is what I want, but is this the correct/only way of doing this?

Stu
 
Well, you learn something new every day! I have replaced the Access menu bars and tool bars occasionally in the past, but it never occurred to me that the keyboard shortcuts might still be active! I shudder to think of the gaping hole I've left in my applications! Good catch, Stu!

The AutoKeys macro may well be the only way to discard these keystrokes. The only other thing I can think of would be to edit the menus' OnAction properties to run a dummy macro or procedure (right-click a toolbar, choose Customize, right click a menu command, choose Properties, and change the OnAction field). However, I'm not sure whether such changes would be limited to the database you're working on--they might be global to your copy of Access. Rick Sprague
 
How about trapping Ctrl O, N, S, and P with "On Key Down" property and setting the "KeyCode = 0" when any one of above 4 is pressed.

Shar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top