Results 1 to 6 of 6
  1. #1
    john134 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2014
    Posts
    42

    Question Using the SendKeys action in a Macro

    I am trying to use the SendKeys action in a Macro. However, when I do so I receive the following message:
    "The SendKeys action requires the Microsoft Office Access Utility Add-in to be loaded. Rerun Microsoft Office Access or Microsoft
    Office Setup to reinstall Microsoft Office Access and the Microsoft Office Access Utility Add-in."
    I have Windows Office Professional 2007 running on Windows 7. When I rerun the setup from the disk, I get a choice of Adding or Removing
    features. After I check that box it configures Access and then it is finished. No other instructions are given. But, after checking my


    macro in my Access database program I continue to get the same message as above.

    Does anyone know how to get this Access Utility Add-in loaded?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    No idea. Never had to do that. I use SendKeys in VBA. I don't use macros. SendKeys are not supposed to be good practice and I used them as a last resort. If I could figure out how to do what I want without them I would.
    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
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    From Allen Browne's article 'The Good, the Bad and the Buggy,' listing problems with v2007 and forward:
    Unless previous versions of Access are also installed, macros that use Sendkeys may fail with the message:
    The SendKeys action requires the Microsoft Office Access Utility Add-in to be loaded.


    And his site reports no fix has been made. Everything else aside, SendKeys should always be a tool of last resort, as June7 said.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    john134 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2014
    Posts
    42
    Thank you for the reply. I tried using VBA code and it worked. FYI, I was trying to add a date to a Note field at the end of any text in that field. I used a command button called butAddNotes. The code I used was:

    Private Sub butAddNotes_Click()
    DoCmd.GoToControl "Notes"
    End Sub


    Private Sub Notes_GotFocus()
    Me.Notes.SelStart = Len(Me.Notes)
    SendKeys "{ENTER}^(+{+}: ", Yes
    End Sub

  5. #5
    john134 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2014
    Posts
    42
    The code in the line for SendKeys is not a smiley face it is a semi colon followed by a right parenthesis. I don't know how it was transmitted as an emoticon.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    At bottom of the Advanced post editor, can set option to not convert to emoticons for the message.

    Instead of the SendKeys, could maybe set focus to another control.

    Why isn't the date in its own field?
    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.

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

Similar Threads

  1. Help: Create Macro: Echo Action
    By dododo in forum Macros
    Replies: 3
    Last Post: 07-23-2013, 11:41 AM
  2. SetValue Macro action
    By rkalapura in forum Programming
    Replies: 3
    Last Post: 12-19-2011, 11:54 AM
  3. PrintOut Macro Action
    By EHittner in forum Access
    Replies: 1
    Last Post: 09-22-2011, 01:27 AM
  4. Macro Action
    By Bakar in forum Forms
    Replies: 1
    Last Post: 01-05-2011, 12:38 PM
  5. conditional macro action
    By frcastro in forum Programming
    Replies: 4
    Last Post: 06-27-2010, 10:59 PM

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