Peter Groves
asked on
Create keyboard shortcut such as CTRL-T to open files in access 2013.
I've found ways to do it in access 2007 but not in 2013. I need to be able to have a user that's using the database be able to do CTRL-T and have an excel document pop up!
Task_link = " https://community.collaborate.xxxxxx.com/Mytasks/Mytasks.xlsm
CTRL-T = Application.FollowHyperlin k Task_link
Thanks
Pete
Task_link = " https://community.collaborate.xxxxxx.com/Mytasks/Mytasks.xlsm
CTRL-T = Application.FollowHyperlin
Thanks
Pete
ASKER
As it is now I have a table that contains all the links to document I can open, but this involves opening a separte window and choosing which document to open! I have a button beside each link that executes the Application.FollowHyperlin k Task_link code. It works fine.
But I'd like to create a keyboard shortcut to execute at any time and open one of the links without the need to open a separte window and choose! Such as hitting CTRL-T and have the excel pop up, just like it does when I click the button!
In previous versions of Access I saw where you could select a key code then assign a macro to it! But in Access 2013 I can't find where I can do that!
Pete
But I'd like to create a keyboard shortcut to execute at any time and open one of the links without the need to open a separte window and choose! Such as hitting CTRL-T and have the excel pop up, just like it does when I click the button!
In previous versions of Access I saw where you could select a key code then assign a macro to it! But in Access 2013 I can't find where I can do that!
Pete
Pete
How were you doing it in Access 2007?
Where you using an AutoKeys macro?
If so that method is still available in later versions.
How were you doing it in Access 2007?
Where you using an AutoKeys macro?
If so that method is still available in later versions.
Pete
You mention a 'table' with buttons next to each record, is the 'table' actually a form?
You mention a 'table' with buttons next to each record, is the 'table' actually a form?
<< Such as hitting CTRL-T and have the excel pop up, just like it does when I click the button! >>
If you have a button, then you have a form and there are a few ways to do this.
1. You can setup an AutoKeys macro. This is app wide.
2. You can set the forms KeyPreview property to true, and use the KeyDown event to see if the ctrl/t was pressed.
3. You can do #2 on each control as well
4. You can use an ampersand (&) in the text of the button, and then use Alt/T to "click" the button. This would be the simplest.
If you want details on 1 - 3, let me know.
Jim.
If you have a button, then you have a form and there are a few ways to do this.
1. You can setup an AutoKeys macro. This is app wide.
2. You can set the forms KeyPreview property to true, and use the KeyDown event to see if the ctrl/t was pressed.
3. You can do #2 on each control as well
4. You can use an ampersand (&) in the text of the button, and then use Alt/T to "click" the button. This would be the simplest.
If you want details on 1 - 3, let me know.
Jim.
ASKER
Yes the button to open a link is on a continuous forms form! I can choose from several links!
The object is to NOT have the links form open when I do the CTRL-T .
I don't need to choose a link but have one of those links assigned to the CTRL-T (or whatever else) Just think as if I never mentioned a form with links.
If the Autokeys macro still exists in Acess 2013 then please do tell me how I configure it!
Thanks
Pete
The object is to NOT have the links form open when I do the CTRL-T .
I don't need to choose a link but have one of those links assigned to the CTRL-T (or whatever else) Just think as if I never mentioned a form with links.
If the Autokeys macro still exists in Acess 2013 then please do tell me how I configure it!
Thanks
Pete
ASKER
Norie, you mention that autokeys is still in use on later versions but I can't find it documented anywhere!
Any hints as to where I'll find it!
Thanks
Pete
Any hints as to where I'll find it!
Thanks
Pete
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
They did a good job of hiding the info but works like a charm!
Pete
They did a good job of hiding the info but works like a charm!
Pete
But Ctrl/T is not a standard shortcut, so it must have been added. Can you give some more details...is this a new DB? is Excel installed? etc.
Jim.