Results 1 to 5 of 5
  1. #1
    MFDinBR is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2012
    Posts
    3

    SendKeys equivalent in Access 2010 (or a workaround)

    I'm redesigning an Access 97 database in 2010. I have a series of yes or no questions. If any of them are answered No, an explanation is required. If the user clicked No, I had a macro that took the user to the explanation field (memo fieldtype), then I used SendKeys {F2}{End} to move the cursor to the end of the field so that the user won't accidentally type over a previous explanation.



    I cannot use VBA code because this will eventually be used on a Sharepoint site and Sharepoint sites do not support VBA

    Any suggestions? (I'm still on the uphill part of the A2010 learning curve, so even obvious answers are welcomed.)

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    MFDinBR is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2012
    Posts
    3
    Hmmm ... It looks like it should be available. Why might it not show up in the Macro Actions pane or dropdown list of actions?



  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Don't know, I don't use macros, only VBA.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    MFDinBR is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2012
    Posts
    3
    I did not find the answer to the question, but I did find a workaround. Thanks for the help.

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

Similar Threads

  1. Replies: 6
    Last Post: 08-27-2011, 03:47 PM
  2. Keydown and SendKeys
    By Remster in forum Programming
    Replies: 10
    Last Post: 08-10-2011, 10:39 AM
  3. Sendkeys replacement
    By numberguy in forum Programming
    Replies: 6
    Last Post: 07-14-2011, 08:29 AM
  4. Sendkeys replacement
    By numberguy in forum Forms
    Replies: 3
    Last Post: 10-29-2010, 07:20 AM
  5. Replies: 3
    Last Post: 01-05-2010, 10:07 PM

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