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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Program function keys (F1-F12) to go to forms

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I have a request from one of my users to update their application so that instead of using the mouse to navigate their application, they would prefer to use the function keys (F1-F12).
 
I'm guessing from your message title you want F1 to open Form1, F2 to open Form2, etc. You can't do this very well with code, because Access' use of those keys takes precedence to a KeyDown, KeyUp, or KeyPress event. However, you can use an AutoKeys macro group to grab them before Access has the chance. Look up AutoKeys in the Help file.

One warning: When choosing keys, consider whether you can really afford to lose the normal Access functions. For example, if you "steal" F1, the user can't get help that way any more. Rick Sprague
 
Why not just number ( or letter ) the option in a menu and then assign the use of the Alt key by prefixing the caption with the &.

Thus,
&1. Open form 1
&2. Open form 2
&3. Open form 3

look like :

1. Open form 1
2. Open form 2
3. Open form 3

And to open each for is just Alt+1, Alt+2 etc.



Bill Paton
william.paton@ubsw.com

Check out
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top