SendKeys and/or Macro Failure (1 Viewer)

MarkK · Jul 26, 2007

- I have this code in a standard module. I used to hit keys <Alt> <T> <M> <Enter> in any module, which ran this as if it was a macro and produced instant dated boxes to offset blocks of related routines.
- This has now stopped working in all my Access files. I can set a breakpoint and step through this code in a debugger. Everything appears to execute normally, but the keys are not sent to the active code window.
- Does anyone know how I can get this working again?
- Thanks in advance. Mark

Code:

Sub AA_SectionHeader()
   Dim i As Integer
   SendKeys _
"'******************************************************************** " & Chr(13) & _
"'*                                                                                                   " & Format(Date, "mmm d yyyy") & Chr(13) & _
"'*       >" & Chr(13) & _
"'*" & Chr(13) & _
"'********************************************************************" & Chr(13)
   For i = 1 To 3
      SendKeys "{UP}"
   Next i
   For i = 1 To 9
      SendKeys "{Right}"
   Next i
End Sub

Guus2005 · Jul 27, 2007

Code:

'********************************************************************
'*                                                         jun 27 2007
'*      X>
'*
'********************************************************************

I tried your code and the cursor blinks at the X.
Seems to work fine here.

MarkK · Jul 27, 2007

I know, I know. I know what it's supposed to do.

My SendKeys is still dead.
Thanks for trying it out.
Mark

Moniker · Jul 28, 2007

Have you tried DoEvents after the SendKeys?

MarkK · Jul 28, 2007

Tried it. No go. Weirdest thing.
Why do you think DoEvents?

MarkK · Jul 28, 2007

Solved. Rebooted.

Which is what I tell other people to try first when strange problems happen to them.
Cheers,
Mark

SendKeys and/or Macro Failure (1 Viewer)

MarkK

bit cruncher

Guus2005

AWF VIP

MarkK

bit cruncher

Moniker

VBA Pro

MarkK

bit cruncher

MarkK

bit cruncher

Similar threads

Users who are viewing this thread