ODB SQL Server login from a sendkeys macro

[Andy Cooke]

OK, I know macros are no good and I should use VBA code but does anyone have
any ideas about this problem I have with the "sendkeys" action in a macro :

I have a macro which :

1. Opens a table which simply contains todays date
2. Send keys for copy
3. opens a report in design mode
4. sends keys "ALT FP{ENTER}" (to print) with wait set to NO
5. Sends keys "C:\directory\CTRLVreportlocation.pdf" (My default printer is
pdf writer) with WAIT set to yes
6. send keys "password"

Stages 1 - 5 work fine : the report starts to run and asks for the path name
of the pdf file being created. This gets entered OK into the dialogue box
(step 5).

Stage 6 however does not work! I have tried lots of combinations of Wait
set to yes or No for the 3 send keys statements without any success.

Does anyone know how I can populate the SQL Server login box with the
password without any complicated code?

Thanks in advance.
--
Andy Cooke
Please remove *no spam* before trying to email

[Leszek Szamocki]

Hi !
When You connect to SQLServer Tables via ODBC connection, You can specify
login name and password for connection, also You can select check box
"remember password" (or some like it...)

greetings

--
------------------------------------------------------
Leszek Szamocki
szam...@hotmail.com

Uzytkownik "Andy Cooke" <acooke@*no spam*halesowen.ac.uk> napisal w
wiadomosci news:9dgagk$8...@ccuh.wlv.ac.uk...