Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

The title really covers it all - when manually typing a query in SQL View with Access 2010, is there a keyboard shortcut to run the query, like Ctrl + E in SQL Server Management Studio?

If not, it's almost as annoying as not being able to use Ctrl + A to select all text in the query window...

share|improve this question

2 Answers 2

up vote 1 down vote accepted

The fastest way I found was using the keyboard navigation.

F10, J, Q, X

share|improve this answer
    
This was funny - I came here to answer my own question since I just now figured out how to do this, only to see it was answered today. Thanks. –  John Straka Sep 6 '12 at 16:50

If you're in design view then try Ctrl+ . (full stop). To switch back use Ctrl+ , (comma).

From SQL view things work the other way round - Ctrl+ comma to switch to datasheet view and then Ctrl+ . to switch back to SQL view.

Think these are really meant as a way to toggle through all possible views. Should also work when designing forms as well

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.