Sendkeys On Form Open

[robs23]

Hi Guys,


VB Project of the database I created is password protected. This means that I have to unlock it in order to programitically add code to e.g. form. I found somewhere such a code that uses SendKeys method to provide the password so new code can be added. The "unlock" code is as follows:

Dim Password as string
Password = "xxxx"
SendKeys "%{F11}", True
SendKeys "%TE+{TAB}{RIGHT}%V{+}{TAB}", True 
SendKeys Password, True
SendKeys "~", True
SendKeys "{ESC}", True
SendKeys "%{F11}"

This code does the job well when run from e.g. form's button. Unfortunately I have to run it from form_open event. In such case this code doesn't work. It should send "ALT+F11" to display vba project window, then should send "%TE+{TAB}{RIGHT}%V{+}{TAB}" to display password prompt, send password and send enter key. It doesn't work, though, when triggered from form_open event. Why doesn't it work? How can I work around it?


PS. I know SendKeys is very unreliable method but there's no other way. This topic is not to post how unreliable it is and "why do I use it" questions...


Regards,
Robert

[pbaldy]

If I had to guess, in the open event focus doesn't move to the VBA window as expected, since the form is still opening. Would putting it in the timer event so it ran right after the form opened work?

[robs23]

Yeah I know sendKeys is evil, but I thought it was necessary evil in that case. Fortunately I was wrong. The main reason I decided to go into adding procedures during runtime was that I thought it's the only way of handling control's events from object. In other words, I didn't want to assign object method (cls.refreshResults(keyword as string)) to textbox's change event for every form where I use search object. I wanted to create the object on form's load and kill it on form's close. Of course I could assign public function to e.g. textbox.onChange = method, but it wasn't always the case. Fortunately I came across WithEvents way of doing. I must say it was the missing link for me, now I can handle form's/control's events from custom object without having to add them separately every time.


Thanks for efforts.
Robert