Send Keys

ExpandCollapse

Guest

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;DATABASE=NameofDB;

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;DATABASE=NameofDB;
>
> But it gives me this error [ODBC--Connection to 'MyDSN' failed]
>
> Please help
>

Share This Page

On Sunday night I was taking a flight back from San Francisco to Toronto and was stopped by security at San Francisco Airport and ordered into additional screening. Now this is nothing new to me, as I'm a brown dude who flies quite often and these types of extra screening and searchings are...

About Us

Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Like us on Facebook

Support SPN

The management works very hard to make sure the community is running the best software, best designs, and all the other bells and whistles. We'd really appreciate your support!