Re: Shortcut keys for switching between query design/datasheet - Appy

On Mar 28, 11:14 am, Taylor wrote:
> I have searched many shortcut key lists foraccessin hopes of finding
> what I have just stumbled upon by accident (of course, now that I know
> what to search for, I ~can~ find references to it).
>
> What I was always frustrated by, is I could not find a keyboard
> shortcut to switch between query views, which meant dragging the mouse
> over to the corner anytime I wanted to see the results of the query I
> just built. But as I was laying on my back noodling around in bed at
> an awkward angle, I discovered that:
>
> Ctrl-period will take you down the list of views for the current
> object (Design-Form-Datasheet-PivotTable, etc.)
>
> Ctrl-comma will take you back up the list. (PivotChart-PivotTable-
> Datasheet-Form, etc)
>
> The post that I copied the above from says this should work for any
> object (reports, tables, forms). For me, it will me most useful in
> queries.
>
> As a half-arsed challenge, I'd love it if someone could point out
> where this is documented by microsoft. Update: Challenge retracted, I
> found it. But I think it is awfully crappy to hide it under "General
> Shortcut Keys">"Miscellaneous." Aaaargh! I can't believe it only took
> me 6 years to figure this out!

After 11 years I never knew of these.
Good find.

But I won't use them anyway as they cycle thru views I don't need.
So I recommend the AutoKeys I've used for years:
^D = Design view
^E = Datasheet view
And of course F5 is built-in shortcut for Form view

-- David Stelle, Access App Developer