Switching between SQL view and Datasheet view

  • Thread starter Thread starter Marc R. Bertrand
  • Start date Start date
M

Marc R. Bertrand

Hello,

In Access Help, we can find "Assign an action or set of actions to a
key".
I tried the trick, and it worked great just as expected. From SQL
view, after writing my SQL and executing my Ctrl+r, my SQL was run and
the result was displayed in Datasheet view. Great.

But I like to keep my hands on the keyboard when trying out SQL
statements and I like to go back and forth between SQL view and
Datasheet view. Now that my first short-cut is working, I find it
quite annoying to have to grab the mouse to go from Datasheet view
back to SQL view.

So, how can I execute another macro, similar to the Ctrl+r macro,
without namint it "AutoKeys" and using Ctrl+v?

Perhaps there is a built-in short-cut I don't know about.

Thanks a lot for your time.

Marc R. Bertrand
(e-mail address removed)
www.goalseek.net
 
Well, you only need this feature while developing the sql in the query
builder (your users will never see that view).

I have always used the alt-v then q for sql view. I then alt-v, s for
datasheet...

All windows works this way...and not just ms-access. Alt key will activate
the menu...
 
Back
Top