Programming Alt Commands for your Access Application (Not Access Itself)?

[IncidentalProgrammer]

I'm working on database for my department, and in our meeting yesterday, my boss asked if there was any way that I could make Alt commands in it; she likes to use the mouse as little as possible, and would like to be able to Alt-key the buttons and such. I've tried googling, but all I can find is information about the Alt commands for Access itself, and not how to set your own for your application. Is this something that can be done? Or would it interfere with Access since Access already has its own commands?

[ItsMe]

I use SendKeys as a last resort. It may work for you but I always try to develop my apps to work using Tab, Enter, and the Arrows. There is little need for the mouse. For instance, set the tab order of your form's controls so the focus of the cursor cycles through fields and ends on a series of Command Buttons. A commond button can execute code. It could launch a message box for user input or simply execute without a prompt.

If you want to try SendKeys, here is some reference
http://msdn.microsoft.com/en-us/libr...code-snippet-1

Here is some code I use to simulate the Enter key being pressed.

Dim MyEnterKey As String
MyEnterKey = "~"

SendKeys MyEnterKey

[June7]

Shortcut for buttons can be set by inserting & character in the button (or its associated label) caption. This will underscore the following character and that character in combination with Alt will be a shortcut to the button click. If there are no data entry controls on form to take focus (such as menu form with only buttons), pressing the Alt won't be necessary.

[ItsMe]

Shortcut for buttons can be set by inserting & character in the button (or its associated label) caption.

That is a cool trick that I did not know about.

[June7]

This means if you want to show an actual & character in the caption, it must be doubled.

[IncidentalProgrammer]

That's awesome! Thanks so much!