Using the SendKeys action in a Macro

[john134]

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?

[June7]

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.

[Missinglinq]

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)>

[john134]

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

[john134]

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.

[June7]

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?