How can we create Autokey?
For example , " F1 " open an special form or "F2" run a query
How can we create Autokey?
For example , " F1 " open an special form or "F2" run a query
DO you mean a HotKey?
I'm NOT sure you can do it... at least not with VBA
Here is a list of all the HotKeys set for Access
All hotkeys - Microsoft Access Hotkeys - Keyboard Shortcuts
You best bet would be to create a form with buttons, and set the hotkeys for the buttons
Example
Create a button with the Text R&un Query
(yes the & was on purpose)
Now to trigger the Button you would hit ALT U
Hope this helps.
You can do this by assigning a macro to a function key. You can also assign macros to special key combinations.
And yes this is called hotkeys. Read up on macros in Access help for details on how to do this.
Macros! <Shudder>
I blocked those out of my head.. lol.. I hate them
But, good thinking. That will work
My sentiments exactly, but this is one place where macros have a place. If you want to use keyboard shortcuts to trigger code execution.
All times are GMT -7. The time now is 09:02 PM. |