Open query based upon a table selected

[jpm]

Hi,

In Office '07, is there a way to open a query based upon the table you've
highlighted in the navigation pane? e.g. in Office 2003 you could do this:
highlight the table, Key [ALT]+, key [Q] to load a new query designer,
with the highlighted table already in the query design pane.



Also, in Office '07, is there a way use shortcut keys to flip from datasheet
view to Design or SQL view? e.g. in Office 2003 you could do this:
in Datasheet View key [ALT] + [V] + ([D] or [Q]) to get Design or SQL view.
in Access '07 I haven't seen how to set that up. Those 'on the fly'
shortcut keys might work for some folks but I'm interested in hitting a key
stroke combination that is consistently the same. . . then I can quickly
flip from one mode to the other without determining the particular key I
need to hit from one instance to the next, depending on whether the menu
options have changed/been changed.

Comments please.

Not very impressed with '07 Access thus far. . . .

JPM

 

[Jeanette Cunningham]

Hi jpm
I don't have any answer for the 1st question.

2nd question.
Select a query in the nav pane and hit Ctl + Enter to open the query in
design view.
To flip between design, sql and datasheet, use Alt + V followed by D for
design view or Q for sql view or S for datasheet view.

You can open a form in design view from the nav pane using Ctl + G.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia