Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Is there a keyboard shortcut to Run a Query?

434 views
Skip to first unread message

Garden133

unread,
Sep 6, 2007, 2:56:00 PM9/6/07
to
If I am in design view either creating a query or editing the design,
sometimes I want to test before saving. Is there a funtion key that I can
use to Run the query so that I can keep my hands on the keyboard?

Jerry Whittle

unread,
Sep 6, 2007, 3:16:01 PM9/6/07
to
Alt +v s That is hold down the Alt key and tap v then s.

Alt + v d to get back to design view.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

RoyVidar

unread,
Sep 7, 2007, 3:41:20 AM9/7/07
to

Using either

Ctrl + , (comma) or Ctrl + . (dot/period)

or

Ctrl + Left Arrow or Ctrl + Right Arrow

should switch views on most object types.

The help file says Ctrl + . (dot/period) wont work under all
circumstances, but that might be due to keyboard/language/
regional settings issues.

--
Roy-Vidar

Derek

unread,
Apr 18, 2011, 10:53:25 AM4/18/11
to
I added the run icon to the customized ribbon and then all you have to do is hit the alt key and see the number that shows by the run icon and enter that number and the query will run. Ends a lot of keyboard to mouse movement.


>> On Thursday, September 06, 2007 3:16 PM JerryWhittl wrote:

>> Alt +v s That is hold down the Alt key and tap v then s.
>>
>> Alt + v d to get back to design view.
>> --
>> Jerry Whittle, Microsoft Access MVP
>> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>>
>> "Garden133" wrote:


>>> On Friday, September 07, 2007 3:41 AM RoyVidar wrote:

0 new messages