Replacing Sendkeys (at Last)

[jaydwest]

I got a new computer with Vista. Now the commands using Sendkeys no longer work. I have replaced most already but I'm hung up on

SendKeys "{Enter}"

I used this after overriding a not in list event and forcing Upper Case to save a value entered that was not in the list. You don't need to worry about the code I used in the event, just need to know how to save a field value without SendKeys "{Enter}"or SendKeys{Tab}".

THanks for your help

 

[boblarson]

DoCmd.RunCommand acCmdSaveRecord

 

[jaydwest]

Bob,

This is a real tricky bit of code. I really want to commit the field but not the record at the time of this code. Moving to the next field is supposed to commit the field but in this particular situation it doesn't.

Aside from this issue, have you seen a list of commands that replace sendkey commands, for example, what replaces

sendkeys "{F2}"
sendkeys "{Enter}"
sendkeys "{Tab}"

Thanks,

 

[boblarson]

Since I have done 99.99% of my stuff without sendkeys (the only time I have is to use them for starting a compact/repair from the menu) I am not sure. I just have never found the need to do so since I've always found a way to use other methods to do what I needed.

You might look into the DoCmd.RunCommand stuff (just type that out and hit a space and you'll get the list of all that's available to you; which is almost all of the menu commands).