AutoKeys macro stopped working on conversion

[CJones]

I recently bit the bullet and converted an Access 97
database app to Access 2000. My AutoKeys macro appeared to
convert correctly, and returns no errors when I run it.
however, the commands I place there don't seem to work.
Example, I have {F12} set to SendKeys ^{tab}, no waiting. ^
{tab} works on its own, but when I press F12 nothing
happens. Ideas?

 

[CJones]

added thru search window and posted to wrong discussion.
Reposted in Macros.

 

[Bruce M. Thompson]

I recently bit the bullet and converted an Access 97

database app to Access 2000. My AutoKeys macro appeared to
convert correctly, and returns no errors when I run it.
however, the commands I place there don't seem to work.
Example, I have {F12} set to SendKeys ^{tab}, no waiting. ^
{tab} works on its own, but when I press F12 nothing
happens. Ideas?

Recreating the macro seems to work here, so you might want to simply do the
same.

 

[CJones]

Thanks Bruce... but I tried this as well, with no success.
I've even tried just creating a generic macro with other
SendKeys actions (and run them. None of them work, and no
error messages. Any other suggestions?

 

[Bruce M. Thompson]

Thanks Bruce... but I tried this as well, with no success.

I've even tried just creating a generic macro with other
SendKeys actions (and run them. None of them work, and no
error messages. Any other suggestions?

Try setting the "Wait" argument to "Yes". See the following KB article relative
to this issue:

ACC2000: SendKeys Macro Does Not Run
http://support.microsoft.com/default.aspx?kbid=209624

 

[CJones]

Setting Wait to 'yes' didn't appear to work, either.
however, I did note that now, the first time I press a key
defined in Autokeys, a message appears at the bottom of
the app window stating 'loading wizards'. The progress bar
moves slightly but never completes (I let it go for almost
2 minutes). If I press another key, the message goes away.
however, it may still be trying to load the wizard, as the
one thing I cannot do is close Access. Is there a wizard
associated with SendKeys or AutoKeys?? I didn't think
there was, but I could (obviously) be mistaken.

Thanks again for the assistance.

 

[CJones]

Setting Wait to 'yes' didn't appear to work, either.
however, I did note that now, the first time I press a key
defined in Autokeys, a message appears at the bottom of
the app window stating 'loading wizards'. The progress bar
moves slightly but never completes (I let it go for almost
2 minutes). If I press another key, the message goes away.
however, it may still be trying to load the wizard, as the
one thing I cannot do is close Access. Is there a wizard
associated with SendKeys or AutoKeys?? I didn't think
there was, but I could (obviously) be mistaken.

(Sorry--- don't do much discussion group posting...
hopefully you/everyone can follow)

 

[Bruce M. Thompson]

Setting Wait to 'yes' didn't appear to work, either.

however, I did note that now, the first time I press a key
defined in Autokeys, a message appears at the bottom of
the app window stating 'loading wizards'. The progress bar
moves slightly but never completes (I let it go for almost
2 minutes). If I press another key, the message goes away.
however, it may still be trying to load the wizard, as the
one thing I cannot do is close Access. Is there a wizard
associated with SendKeys or AutoKeys?? I didn't think
there was, but I could (obviously) be mistaken.

Make *sure* there is no error in your Sendkeys string. If there is no error, you
should consider using code instead of macros (*lose* "SendKeys" and implement a
more direct method of performing the task). With code you have the ability to
trap errors where in macros you don't.