Results 1 to 4 of 4
  1. #1
    numberguy is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Oct 2010
    Posts
    15

    Sendkeys replacement

    I am new to this forum and I apologize in advance if this question has already been answered. I am trying to find an alternative to the sendkeys macro command. I am using this command to invoke the tab key (sendkeys {tab}) to move focus to the next object in a form. The template I developed worked fine in Access 2003 and 2007, but when I started using Access 2010, this command turns off the numeric locks (on a periodic basis). In reading results of Google searches, it is recommended to avoid the sendkeys command since it has known issues, but I have not found a good alternative. I use this macro in several places in several forms, so I prefer to continue to use a macro or VBA code I can refer to in the form instead of using another command that would be control specific such as the GoToControl command. Thanks for the help.

  2. #2
    slave138's Avatar
    slave138 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    WI
    Posts
    233
    Doesn't TAB move focus to the next object in the tab order by default? Is there a specific reason you are using sendkeys to replace the default functionality?

  3. #3
    slave138's Avatar
    slave138 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    WI
    Posts
    233
    Nevermind, I misunderstood what you were doing. You want to replicate a TAB without actually pressing the key, right?

  4. #4
    numberguy is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Oct 2010
    Posts
    15
    You are correct. I have the next object get focus, run a procdure and shift focus to the next object without user action.

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

Similar Threads

  1. Replacement in table with VB code
    By miziri in forum Access
    Replies: 2
    Last Post: 06-28-2010, 01:38 AM
  2. docmd.SendKeys "{F9}" in 2007
    By RickM in forum Access
    Replies: 4
    Last Post: 09-10-2009, 09:13 AM

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