IE Automation Problem

[robcarr]

Hi,

i use the below coding to enter username and password into a form and it doen't submit.

With .Document.forms("oFormMain")
      .UserName.Value = "username"
      .Password.Value = "password"
      .submit
         End With

any ideas why it doesnt work, the form just resets to the username again

Hope this is of use, Rob.

 

[kjv1611]

Are you trying to update an Access Data Page, or a page from a website? If from a website, you probably would have to use SendKeys in combination with getting the windows handle for the particular IE Window you're wanting to work with. Be aware, though, SendKeys is a buggy way of getting things done - it's almost guaranteed it'll not do what you want at least one time, though it may work 99% of the time correctly.

--

"If to err is human, then I must be some kind of human!" -Me