Other keyboard shortcut for switching tabs/windows??

[Grant I]

Is there any way to define a different keyboard shortcut than ctrl + F6 to
switch between tabs / windows in Access 2007? Using ctrl + tab is so much
quicker b/c you can do it with one hand. From my research around the web it
sounds like this isn't possible without a custom macro in every DB but
thought I'd throw it out there.

Thanks!
Grant

 

[Arvin Meyer [MVP]]

Is there any way to define a different keyboard shortcut than ctrl + F6 to
switch between tabs / windows in Access 2007? Using ctrl + tab is so much
quicker b/c you can do it with one hand. From my research around the web
it
sounds like this isn't possible without a custom macro in every DB but
thought I'd throw it out there.

A custom AutoKeys value is exactly what you need. You only have to do it
once in each database, and you can either put it in a template, or import
it, so it only takes a few seconds to do.

 

[Grant I]

Thanks Arvin! Never used those before, but seems pretty straightforward.
One question though - which command would I use to switch between windows?
Or am I able to run VBA to do it? Thanks again for your help!

 

[Arvin Meyer [MVP]]

If by windows you mean Access forms and reports, you use VBA to either open
or set focus to one that's already open.

DoCmd.OpenForm "FormName"

Forms!FormName!ControlName.SetFocus
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com