Sendkeys statements

M

mscertified

Converting Access 97 to 2000, I'm coming across many SENDKEYS ststements
which the MS Conversion white paper warns about.
How do I convert:
Sendkeys "{TAB}"
Sendkeys "{ESC 2}"

Are these safe to leave in?
I have no idea what the second statement above does but its executed when
canceling an update of a table.
 
A

Allen Browne

Tab moves to the next field. SetFocus to the desired control, e.g.:
Me.[Text99].SetFocus

Esc twice undoes the changes to the record. Replace with:
If Me.Dirty Then Me.Undo
 
M

mscertified

Fair Dinkum, Thanks a lot

Allen Browne said:
Tab moves to the next field. SetFocus to the desired control, e.g.:
Me.[Text99].SetFocus

Esc twice undoes the changes to the record. Replace with:
If Me.Dirty Then Me.Undo

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

mscertified said:
Converting Access 97 to 2000, I'm coming across many SENDKEYS ststements
which the MS Conversion white paper warns about.
How do I convert:
Sendkeys "{TAB}"
Sendkeys "{ESC 2}"

Are these safe to leave in?
I have no idea what the second statement above does but its executed when
canceling an update of a table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top