Prev: Memo field
Next: lkùjùl
From: Ron Hinds on 7 May 2010 15:11
Access 2003. I have a macro called AutoKeys in which I have defined several
keystrokes to run commands in design view, e.g., ToggleBookmark,
NextBookmark, etc. Very useful in Code View, since MS has no predefined
shortcut keys for manipulating bookmarks. Also, I have a macro I had
assigned to a keystroke that basically stubs out and procedure with some
commonly used variables (Dim db as Database, etc.) and error handling. These
worked beautifully in previous versions of Access, but they don't work at
all in A2003, forcing me to use menu selections for bookmarks (VERY clumsy)
or to call my BuildErrorHandler function (not AS clumsy, but not as nice as
before!). How do I associate my macros with keystrokes in the Code View in
Access 2003? Thanks!



From: Douglas J. Steele on 7 May 2010 15:23
As far as I know, it's not possible.

There's no connection between the VB Editor and Access macros.

You might take a look to see whether the free MZ Tools 3.0 for VB6 and VBA
provides the functionality for which you're looking.
http://www.mztools.com/v3/mztools3.aspx


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Ron Hinds" <nospam(a)dontspamme.com> wrote in message
news:uvIhTkh7KHA.5412(a)TK2MSFTNGP06.phx.gbl...
> Access 2003. I have a macro called AutoKeys in which I have defined
> several keystrokes to run commands in design view, e.g., ToggleBookmark,
> NextBookmark, etc. Very useful in Code View, since MS has no predefined
> shortcut keys for manipulating bookmarks. Also, I have a macro I had
> assigned to a keystroke that basically stubs out and procedure with some
> commonly used variables (Dim db as Database, etc.) and error handling.
> These worked beautifully in previous versions of Access, but they don't
> work at all in A2003, forcing me to use menu selections for bookmarks
> (VERY clumsy) or to call my BuildErrorHandler function (not AS clumsy, but
> not as nice as before!). How do I associate my macros with keystrokes in
> the Code View in Access 2003? Thanks!
>
>
>


 | 
Pages: 1
Prev: Memo field
Next: lkùjùl