Send Keys

When I run a macro, screen gets populated and asks for UserID and Password,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10394-send-keys.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10394
dut ot ODBC?
How Can I use the send keys Action in this macro to enter my user id, tab,
enter my password and then press enter to continue.

I aslo tried to use the SourceConnectStr property in the query design veiw;
I put this code: ODBC;DSN=MyDSN;UID=MyUserID;PWD=MyPassword;DATABAS E=NameofDB;

But it gives me this error [ODBC--Connection to 'MyDSN' failed]

Please help


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

It's not really a good idea to multi-post the same question with different
headings ?


Private Sub Button_Click()
On Error GoTo Button_Click_Err

Forms!Form1!UserID = "MyID"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10394
Forms!Form1!Password = "MyPassword"
DoCmd.GoToControl "NextBox"


Button_Click_Exit:
Exit Sub

Button_Click_Err:
MsgBox Error$
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10394
Resume Button_Click_Exit

End Sub



Add this to an event ( On Load, On Activate, or some other event). Change
the "MyID" and "MyPassword" text to whatever you use. As you can see I have
shown the event as the On Click event of a buttton called "Button". All my
objects are in a form called "Form1".

--
Wayne




"Max" wrote:

> When I run a macro, screen gets populated and asks for UserID and Password,
> dut ot ODBC?
> How Can I use the send keys Action in this macro to enter my user id, tab,
> enter my password and then press enter to continue.
>
> I aslo tried to use the SourceConnectStr property in the query design veiw;
> I put this code: ODBC;DSN=MyDSN;UID=MyUserID;PWD=MyPassword;DATABAS E=NameofDB;
>
> But it gives me this error [ODBC--Connection to 'MyDSN' failed]
>
> Please help
>