Feedback by UserVoice

I suggest you ...

← Access (Desktop Application)

Switch between objects with Ctrl + Tab

In previous versions of Access it was possible to switch between objects with Ctrl + Tab. Please reactivate this feature. Strg + F6 is not an ergonomic shortcut.

134 votes
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
André Minhorst shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Ben Sacheri commented  ·   ·  Flag as inappropriate

    Wow. I'm surprised how many votes this simple feature has received. I personally didn't know about this hotkey when I was using older versions of Access, but I do like hotkeys. When I recently discovered there was a hotkey for changing tabs I thought CTRL+F6 was really inconvenient so I made my own shortcut using AutoHotkey, which turns out to be exactly what you're looking for. If you're not familiar with it, AutoHotkey is a free, open-source custom scripting language for Windows. It's portable so you don't need to have admin rights to use it. Here's how you can set it up to solve this problem in Access:

    1) Download and install AutoHotkey
    https://autohotkey.com/download/

    2) Save the following script in a text file with a .ahk file extension:

    ;=== In Microsoft Access, if you want to cycle between tabbed documents you can press CTRL+F6 or SHIFT+CTRL+F6
    ;=== This hotkey will make it easier to press with one hand. CTRL+Tab or SHIFT+CTRL+Tab.
    ;=== This will override the ability to cycle through tabs on a tab control on a form, which I never do anyway.
    #IfWinActive ahk_class OMain ; Access
    ^Tab::
    {
    Send ^{F6} ; CTRL+F6
    ;SoundBeep 423, 150 ; Let me know the ahk script is working. You can uncomment this for testing.
    }
    Return
    +^Tab::
    {
    Send +^{F6} ; SHIFT+CTRL+F6
    ;SoundBeep 300, 150 ; Let me know the ahk script is working.
    }
    Return
    #IfWinActive

    3) Double-click the file to launch it with AutoHotkey. You can also right-click on it to turn it into an exe.

    I have made some other AutoHotkey scripts:

    a) I like to press CTRL+W to close an MDI child window. Unfortunately it doesn't work everywhere that CTRL+F4 does, so I made a script to enable it in SSMS, Alpha Anywhere, and Excel.
    b) I like Notepad++'s CTRL+D feature to duplicate a line without losing what is in the clipboard. I created a script to replicate this in the VBA IDE, SSMS, and OneNote.
    c) CTRL+V to paste directly to the command prompt.
    d) WINDOWSKEY+SPACE to pin the current active window to remain on top of other windows.

    If you decide to implement my CTRL+TAB script, you can remove your votes from this topic and apply them to another one.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Also reactivate CTRL + Left Mouse key for opening an object in design mode in the navigation pane

Access (Desktop Application)

Categories

Feedback and Knowledge Base

(thinking…)