Keyboard shortcut to open an object in design view 4

[NorthNone]

CTRL-ENTER opens an Access object in design view (forms, tables, queries etc.).
I could have saved millions of keystrokes and mouse clicks over the years had I known this one! From Inside Microsoft Access Vol12 Number 4 April 2004 elementK journals. (Also CTRL /double-click for mousers)

---------------------------------------
The customer may not always be right, but the customer is always the customer.

 

[RoyVidar]

Here are some of my favourites

[tt]ALT+D [/tt]open in design view

or, if the object is alredy open in some view:
[tt]ALT+V + D [/tt]D-Design view, F-Form view, S-Datasheet view...
[tt]CTRL+W [/tt]or
[tt]CTRL+F4 [/tt]close object
[tt]F4 [/tt](in xp) or
[tt]ALT+ENTER [/tt]properties window
[tt]ALT+F4 [/tt]when properties window has focus, closes it (else closes the whole db)
[tt]CTRL+F6 [/tt]toggle between open objects/panes
[tt]ALT+F6 [/tt]toggle between some of the open objects, also properties window
[tt]ALT+F11 [/tt]toggle between Access and VBE
[tt]CTRL+G [/tt]Immidiate pane (debug)

In VBE
[tt]F7 [/tt]Code pane
[tt]CTRL+R [/tt]Project explorer
[tt]SHIFT+F2 [/tt]Go to the function/sub the cursor is on
[tt]CTRL+SHIFT+F2 [/tt] Return to last/previous cursor location
[tt]F2 [/tt]Object Browser
[tt]F5 [/tt]Run
[tt]F8 [/tt]Run line by line
[tt]SHIFT+F8 [/tt]Run sub/function on cursor without entering
[tt]F9 [/tt]Toggle breakpoint
[tt]SHIFT+F9 [/tt]Quick watch

Where to find these - try working on a laptop for a while;-) No, seriously, their'e (almost) all found thru F1 under shortcut key.

Here's also a thread in the VB 5&6 forum with a lot of goodies thread222-533524.

Roy-Vidar

 

[NorthNone]

Thanks for the handout on shortcut keys! I'll print it and refer to it often, Roy-Vidar!

---------------------------------------
The customer may not always be right, but the customer is always the customer.

 

[DougP]

Yeah baby
saves tons of time
Need another star?????

DougP, MCP, A+