2 comments

• Ben Sacheri commented  ·  April 22, 2016 11:06  ·  Flag as inappropriateFlag as inappropriate  ·  Edit…  ·  Delete…

  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.

  Save Submitting...
• Anonymous commented  ·  April 08, 2016 04:21  ·  Flag as inappropriateFlag as inappropriate  ·  Edit…  ·  Delete…

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

  Save Submitting...