Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Shortcuts for VBA procedures in Modules of MS Access
298 views
Skip to first unread message
Thomas Wiedmann
Apr 7, 2012, 11:35:47 AM4/7/12
to
Hello,
is there a way to assign shortcuts for VBA procedures in Modules of MS
Access; if yes, how?
Thomas Wiedmann
is there a way to assign shortcuts for VBA procedures in Modules of MS
Access; if yes, how?
Thomas Wiedmann
Access Developer
Apr 7, 2012, 2:37:53 PM4/7/12
to
Do you mean "keyboard shortcuts", such as "Fn" plus a Function Key like
"F6"?
Keyboard actions trigger events which fire an event, events can execute
Macros or VBA functions in the Form's (Object) Module-- if you want to
execute VBA procedures that are located in a General Module from either of
these type event, you can do so via a macro or VBA code. Events associated
with keyboard actions include: On Key Down, On Key Up, and On Key Press.
--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
"Thomas Wiedmann" <th...@gmx.de> wrote in message
news:jlpmsh$oj8$1...@online.de...
"F6"?
Keyboard actions trigger events which fire an event, events can execute
Macros or VBA functions in the Form's (Object) Module-- if you want to
execute VBA procedures that are located in a General Module from either of
these type event, you can do so via a macro or VBA code. Events associated
with keyboard actions include: On Key Down, On Key Up, and On Key Press.
--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
"Thomas Wiedmann" <th...@gmx.de> wrote in message
news:jlpmsh$oj8$1...@online.de...
Thomas Wiedmann
Apr 8, 2012, 9:24:05 AM4/8/12
to
> Do you mean "keyboard shortcuts", such as "Fn" plus a Function Key like
> "F6"?
Yes (whereas [Fn] usually is a key on notebooks only AFAIK)
> "F6"?
> Keyboard actions trigger events which fire an event, events can execute
> Macros or VBA functions in the Form's (Object) Module-- if you want to
> execute VBA procedures that are located in a General Module from either of
> these type event, you can do so via a macro or VBA code.
macro, e. g. [Ctrl] + T for a procudure 'Sub Test'?
Thomas Wiedmann
Access Developer
Apr 8, 2012, 3:47:32 PM4/8/12
to
To my mind, reassigning keycode actions tends to be a bit "quirky", so I
avoid it. What are you trying to accomplish with the code you'd execute, and
what are the circumstances in which you'd want to do it -- perhaps someone
can offer a useful alternative, or perhaps someone else uses reassigned
keycode actions and can give you an example.
--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
"Thomas Wiedmann" <th...@gmx.de> wrote in message
news:jls3hi$ufi$1...@online.de...
avoid it. What are you trying to accomplish with the code you'd execute, and
what are the circumstances in which you'd want to do it -- perhaps someone
can offer a useful alternative, or perhaps someone else uses reassigned
keycode actions and can give you an example.
--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
"Thomas Wiedmann" <th...@gmx.de> wrote in message
Access Developer
Apr 8, 2012, 4:18:17 PM4/8/12
to
Oh, yes... I apologize that, given how little I use macros, I simply
overlooked that I should have mentioned the AutoKeys macro. For details, see
http://www.dataschenk.com/newsletters/Tips/Access-Autokeys.htm. It may be
just what you need.
--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
"Thomas Wiedmann" <th...@gmx.de> wrote in message
news:jls3hi$ufi$1...@online.de...
overlooked that I should have mentioned the AutoKeys macro. For details, see
http://www.dataschenk.com/newsletters/Tips/Access-Autokeys.htm. It may be
just what you need.
--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
"Thomas Wiedmann" <th...@gmx.de> wrote in message
Thomas Wiedmann
Apr 14, 2012, 12:46:50 PM4/14/12
to
> For details, see
> http://www.dataschenk.com/newsletters/Tips/Access-Autokeys.htm. It may be
> just what you need.
... yes, that was it, I've looked for - thanks a lot.
> http://www.dataschenk.com/newsletters/Tips/Access-Autokeys.htm. It may be
> just what you need.
Thomas Wiedmann
0 new messages