OK, I've got a script created to update addresses in Oracle from a list on an Excel spreadsheet. The problem is that Oracle won't let me plug in city, state, and zip before trying to validate one of those values. What happens is if you put one value in and tab off of it, it will bring up a modal window where you select the correct zip/city etc.
SO... What I've done is created a MsgBox that pops up to ask the user to select the correct city and state after pasting in the zip code and tabbing off. I've set it to always on top so the user doesn't have to alt-tab back to it in order to resume the script. The problem is that it pops up directly over the window where you choose the address... Is there a way to make the MsgBox pop 200 or 300 pixels higher or lower?
Code:
Send, %Zip%{TAB}
MsgBox, 4097, Commit Record?, Press OK when you are ready to commit record.`nYou have to select %City%`, %State% from an Oracle window BEFORE PRESSING OK.
IfMsgBox Cancel
{
Blah Blah Bail out of update and send ERROR to spreadsheet
}
Else
{
Blah Blah commit record and send OK to spreadsheet
}
Login
Register
FAQ
Search
