Hello all.
I was curious if there was a hotkey that would execute a query in access
2003, and one that would toggle back to the sql editor? I ask this because I
have a lot of testing to do and the extra clicking is becoming tedious...
Jeanette Cunningham - 07 Feb 2008 04:57 GMT
A 2003.
I can use Alt + V + Q to switch a query from design view to SQL view and Alt
+ V + S to switch it to datasheet view.
I use Alt + D to open a query in design view from the database window.
Jeanette Cunningham
> Hello all.
>
> I was curious if there was a hotkey that would execute a query in access
> 2003, and one that would toggle back to the sql editor? I ask this because
> I
> have a lot of testing to do and the extra clicking is becoming tedious...
Allen Browne - 07 Feb 2008 05:12 GMT
What happens if you press Enter when you select the query in the Database
window?
Does Ctrl+Enter open it in design view?
(Works in A2007.)

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
> Hello all.
>
> I was curious if there was a hotkey that would execute a query in access
> 2003, and one that would toggle back to the sql editor? I ask this because
> I
> have a lot of testing to do and the extra clicking is becoming tedious...