SendKeys Action doesn't work

[Greg]

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

 

[Scott McDaniel]

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