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
Peter GrovesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
0
Peter GrovesAuthor Commented:
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
0
NorieVBA ExpertCommented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

NorieVBA ExpertCommented:
Pete

You mention a 'table' with buttons next to each record, is the 'table' actually a form?
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<< 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.
0
Peter GrovesAuthor Commented:
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
0
Peter GrovesAuthor Commented:
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
0
NorieVBA ExpertCommented:
Pete

I didn't find it 'documented' as such but I found people asking similar questions as yourself for various versions of Access

The answer was usually that AutoKeys still worked so I tried it myself, I'm using Access 2016/365, and it worked.

Here's one of the links I found - How to set custom shortcut keys in Access 2016.

Here's the 'documentation' that kept on popping up - Run an Access macro by using a keyboard shortcut.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Peter GrovesAuthor Commented:
Thanks  
They did a good job of hiding the info but works like a charm!  


Pete
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.