-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
Access also has SendKeys. From Access Help article "SendKeys
Statement": Syntax: string[, wait]
string Required. String expression specifying the keystrokes to send.
wait Optional. Boolean value specifying the wait mode. If False
(default), control is returned to the procedure immediately after the
keys are sent. If True, keystrokes must be processed before control is
returned to the procedure.
Read the help article for more info.
You don't say where you want this "macro" to run from. If from a form,
see the help article on "KeyPress Event" which describes how to capture
the key combinations.
HTH,
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP2eZnYechKqOuFEgEQKabwCfQwVrP1TCGgJ7vXd4nNcEmP 1Ax9gAoOfY
x4veXWJAygDbHT3OdKY0kSFW
=DQi0
-----END PGP SIGNATURE-----
"Marc R. Bertrand" wrote:
Hello,
In Excel VBA, using SendKeys in a Sub procedure with a shortcut
running the Sub/macro, I can replace a users's fingers and press keys
for him. How can I do this in Access?
I would like to assign a shortcut key combination, such as Ctrl+e to
the key sequence F10+V+Q.
How do I do that?
Cheers.
Marc R. Bertrand
mr*@goalseek.net
www.goalseek.net