J JimMiller Registered User. Local time Today, 01:02 Joined Oct 22, 2001 Messages 18 Jan 16, 2002 #1 Does any one know how to code the action of the ESC Key in VBA? The specific action I am looking for is when a record that is being updated is canceled out of.
Does any one know how to code the action of the ESC Key in VBA? The specific action I am looking for is when a record that is being updated is canceled out of.
J JimMiller Registered User. Local time Today, 01:02 Joined Oct 22, 2001 Messages 18 Jan 16, 2002 #3 Rich..thank you for your reply! When I use Me.undo I get the following: Run-time error '3020', Update or CancelUpdate without AddNew or Edit Does this mean I must have a record inserted before I undo it...
Rich..thank you for your reply! When I use Me.undo I get the following: Run-time error '3020', Update or CancelUpdate without AddNew or Edit Does this mean I must have a record inserted before I undo it...
J JimMiller Registered User. Local time Today, 01:02 Joined Oct 22, 2001 Messages 18 Jan 16, 2002 #4 I relize that me.undo is more reliable, but do you know the VBA code for the ESC key?
R Rich Guest Jan 16, 2002 #5 You can only Undo newly added/edited records, the same applies to ESC. Please explain what your trying to achieve.
You can only Undo newly added/edited records, the same applies to ESC. Please explain what your trying to achieve.
J JimMiller Registered User. Local time Today, 01:02 Joined Oct 22, 2001 Messages 18 Jan 16, 2002 #6 Rich...thanks for all your help! I figured it out.
S suy Guest Jan 16, 2002 #7 If you use the SendKeys instruction with {esc}it also works - although I don't think this is "professional" coding.
If you use the SendKeys instruction with {esc}it also works - although I don't think this is "professional" coding.
