Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Posts
    369
    Thanks
    2
    Thanked 1 Time in 1 Post

    Keyb shortcut query design (2000 SR1a)

    I've given up searching for the answer to this one, so I hope someone here can help me before mouse induced RSI leads me to early retirement.

    Is there a keyboard shortcut to switch between query design and results (datasheet)?

    (Supplementary - is there any way to open a query directly in SQL view, even if it was last opened in design view?)

    My bones and tendons thank you in anticipation.

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Keyb shortcut query design (2000 SR1a)

    Hi Mark,

    I've never found any one keyboard shortcut to switch between Design view and Datasheet view (or Form view for that matter)...

    The best solution I have found is using Alt+V (to access the View menu), then S for datasheet, Q for SQL View, D for Design, or F for Form view.

    I suppose one could write a macro and assign an unused F-Key for a single-key solution to this problem.

    HTH <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

  3. #3
    3 Star Lounger
    Join Date
    Feb 2001
    Posts
    369
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Keyb shortcut query design (2000 SR1a)

    Well F5 takes you from form design view to form view, but not back again, but I guess your right (sigh)

    Are any of the niggling things that anyone spending more time designing databases than using them finds really annoying about Access 2k (find and replace, use of default form template outside current database, keyboard shortcuts for design view switching etc) fixed in XP?

    Thanks anyway, I'll stop looking now.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Keyb shortcut query design (2000 SR1a)

    I suspect that there aren't enough developers who find those things terribly annoying. I know they don't bother me, and I make my living at this. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Keyb shortcut query design (2000 SR1a)

    You're a lucky lady! <img src=/S/smile.gif border=0 alt=smile width=15 height=15> If I'm not careful, I end up with problems like Mark P! (But then, the number of grumpy people I've seen working away at a screen with a 60Hz refresh rate for days/weeks/months/years on end baffles me.) <img src=/S/clown.gif border=0 alt=clown width=15 height=15>
    Gre

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Keyb shortcut query design (2000 SR1a)

    Maybe it's because I started with Access 1.0 on a 16Mhz 386, the fastest machine out there at the time. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> I've been working with Access so long, I don't even notice things that might seem like inconveniences to others. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •