AdrianK
07-29-2011, 08:56 AM
Hello All,
I've just made the move from Office 2003 to 2010 and am struggling with the fact that they've removed the ability to alt-tab between active objects (Shift-F6 seems so completely bizarre and un-egronomic way to switch).
I mainly code in Excel, so don't really know where to start, but I was wondering if there is a way to assign macros to a shortcut key combination like there is in excel, and also is there any way to shift focus between active objects via code (without explicitely naming them)?
My aim is to set up some shortcut key combination to cycle through the objects that doesn't interupt my flow as much as having to use F6! (e.g. Shift-Q or something).
As I say I have written barely any code within Access so any help on a starting point would be most appreciated.
Many thanks,
Adrian
I've just made the move from Office 2003 to 2010 and am struggling with the fact that they've removed the ability to alt-tab between active objects (Shift-F6 seems so completely bizarre and un-egronomic way to switch).
I mainly code in Excel, so don't really know where to start, but I was wondering if there is a way to assign macros to a shortcut key combination like there is in excel, and also is there any way to shift focus between active objects via code (without explicitely naming them)?
My aim is to set up some shortcut key combination to cycle through the objects that doesn't interupt my flow as much as having to use F6! (e.g. Shift-Q or something).
As I say I have written barely any code within Access so any help on a starting point would be most appreciated.
Many thanks,
Adrian