Results 1 to 7 of 7
  1. #1
    JohnOchoa is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    3

    AutoKeys macro does not work

    Teachers, good day.


    My problem is the following. In a tool in the FrontEnd I have a macro of the type AutoKeys with several submacros, within which, for example one that with {f12} opens a form. Until last week and for more than 5 months this was working perfectly but now it DOES NOT WORK. I don't remember changing anything about Access.
    But when you run the macro from EXECUTE or by double clicking YES IT WORKS.
    I have done the following (no result):
    - I built an AutoKeys macro in another access file so that with {F3} I opened a form ... It doesn't work
    - I uninstalled the Office (I have 2016) and reinstalled it ... it still doesn't work.


    In addition, I commented that I ran the tool on another PC and there IF the AutoKeys macro works


    Any idea how to fix this?


    Thank you very much teachers!

  2. #2
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Are you using a laptop? The function keys have a dual purpose which can be toggled via another key near the bottom of the KB, usually labeled FN. Mine is between the left CTRL and WINDOWS Keys.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I've been programming in Access for 20 years and NEVER needed to use sendkeys.
    if you want to open a form , use docmd.Openform
    if you want to run a macro, docmd.runmacro.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    @Ranman
    For info...
    The autokeys macro is used to assign keyboard shortcuts to selected functions using submacros.
    It has nothing to do with SendKeys (which I also never use).
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    JohnOchoa is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    3
    Profesor
    Me temo que ese no es el problema. Las teclas de función funcionan bien. Por ejemplo, cuando presiono F11, el panel de navegación se muestra u oculta. Pero hice un acceso directo con submacro con esa tecla (F11) que ejecuta un código VBA ... pero no funciona. Lo extraño es que durante más de cinco meses SÍ lo estuvo haciendo, pero de un momento a otro (seguramente por algo que hice en mi PC) dejó de funcionar.
    Si puede pensar en una solución, por favor dígame.
    Gracias

  6. #6
    JohnOchoa is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    3
    Teacher
    I'm afraid that's not the problem. The function keys work well. For example, when I press F11, the navigation pane is shown or hidden. But I have made a shortcut with submacro with that key (F11) that runs a VBA code ... but it is not working. The strange thing is that for more than five months YES he was doing it but from one moment to another (surely for something I did on my PC) it stopped working.
    If you can think of a solution, please tell me.
    Thank you

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    John
    It isn't clear which of us you are responding to in your last reply.

    Recent Access updates have caused lots of issues and your issues may be related to those events
    I suggest you change the autokeys macro keyboard shortcuts so they don't conflict with existing Access shortcuts such as F11 & F12
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Autokeys shortcut to go to design view
    By Steeeeev in forum Macros
    Replies: 1
    Last Post: 07-30-2019, 06:40 AM
  2. Macro doesn't work 100%
    By ITVader in forum Macros
    Replies: 28
    Last Post: 11-17-2016, 08:51 AM
  3. AutoKeys Macro Problem
    By MatthewR in forum Macros
    Replies: 3
    Last Post: 04-01-2016, 10:08 AM
  4. Can you use AutoKeys Macro in MS Access 2010?
    By JrMontgom in forum Access
    Replies: 14
    Last Post: 04-11-2015, 12:06 PM
  5. Autokeys
    By sergran in forum Programming
    Replies: 10
    Last Post: 10-05-2013, 10:51 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums