Link to home
Start Free TrialLog in
Avatar of Peter Groves
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.FollowHyperlink Task_link

Thanks

Pete
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

What worked in A2007 should work fine in A2013.

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.
Avatar of Peter Groves
Peter Groves

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.FollowHyperlink 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
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.
Pete

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.
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
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
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks  
They did a good job of hiding the info but works like a charm!  


Pete