SendKeys Action doesn't work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg - 16 Jul 2007 12:54 GMT

When I run a Access 2002 database on a computer running Vista, I get an
error message when using a macro (or event procedure) using SendKeys. The
same macro when running the database on a Windows XP machine runs fine.
Any ideas? Thanks for whatever help is given.
Greg in Detroit

Reply to this Message

Scott McDaniel - 16 Jul 2007 13:57 GMT

>When I run a Access 2002 database on a computer running Vista, I get an
>error message when using a macro (or event procedure) using SendKeys. The
>same macro when running the database on a Windows XP machine runs fine.
>Any ideas? Thanks for whatever help is given.

I'd suspect that Vista is not allowing SendKeys, and a quick cruise through several newsgroup postings seems to confirm
this, and some installations of Vista apparently do run SendKeys correctly (it appears to hinge on User Access Control
settings, which can be different). FWIW, SendKeys can always be replaced with API calls (and SendKeys is notorious for
being unreliable, at best).

Replacement for SendKeys:
http://www.mvps.org/access/api/api0046.htm

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

Reply to this Message