Use Sendkeys with Screensaver on

[Billy Rogers]

Is there a way to use SendKeys while the computer screen is locked.

I have an automated process that works fine when i'm sitting in from of my
desk, but I need it to run when I'm not at my desk and it doesn't work when
the screensaver is on or the computer is locked. Is there anyway around
this?

Can this be done in VB or C# instead?
--
"Just because you don''t know how to do something doesn''t mean it can''t be
done"

Billy Rogers

Currently Using SQL Server 2000, Office 2000 and Office 2003

http://thedataguru.blogspot.com/

 

[Rick Brandt]

Is there a way to use SendKeys while the computer screen is locked.

I have an automated process that works fine when i'm sitting in from
of my desk, but I need it to run when I'm not at my desk and it
doesn't work when the screensaver is on or the computer is locked.
Is there anyway around this?

Can this be done in VB or C# instead?

It is never a good idea to use SendKeys and it is almost always possible to
accomplish the same goal without using it.

What is it you are trying to do?

 

[Billy Rogers]

I have an access database with a form with some buttons. When a button is
clicked 10 instances of query analyzer are opened with ouput to file and the
output file location is entered into the dialogue box and the the scripts are
loaded with the output saved in excel files in a folder.

This process is kicked of when an email with a certain subject line hits my
outlook inbox. I want this run when i'm away from my computer. Tell me
how to do this without sendkeys.


--
"Just because you don''t know how to do something doesn''t mean it can''t be
done"

Billy Rogers

Currently Using SQL Server 2000, Office 2000 and Office 2003

http://thedataguru.blogspot.com/

 

[Rick Brandt]

I have an access database with a form with some buttons. When a
button is clicked 10 instances of query analyzer are opened with
ouput to file and the output file location is entered into the
dialogue box and the the scripts are loaded with the output saved in
excel files in a folder.

This process is kicked of when an email with a certain subject line
hits my outlook inbox. I want this run when i'm away from my
computer. Tell me how to do this without sendkeys.

Why use Query Analyzer? Why not just send the output of queries in Access
to Excel? Then you supply all of the arguments in your code (no dialog
boxes required).

 

[Billy Rogers]

It would take several hours to run them sequentially. Access doesn't allow
multi-threading as far as I know. I need the scripts for each table to run
concurrently to save time.

they are long scripts with multiple queries used to qa data that is loaded
into 10 different tables in sql server and we also need to be able to read
the print statements.
--
"Just because you don''t know how to do something doesn''t mean it can''t be
done"

Billy Rogers

Currently Using SQL Server 2000, Office 2000 and Office 2003

http://thedataguru.blogspot.com/

 

[Rick Brandt]

It would take several hours to run them sequentially. Access doesn't
allow multi-threading as far as I know. I need the scripts for each
table to run concurrently to save time.

they are long scripts with multiple queries used to qa data that is
loaded into 10 different tables in sql server and we also need to be
able to read the print statements.

Could you put them in a stored procedure on the server and have Access call
the stored procedure?

Can QA be automated from code like Word, Outlook, Excel, etc.?

 

[Billy Rogers]

Yes, but then the scripts would run sequentially (and would take several
hours).....I want all ten to be running at the same time.

Plus stored procs can have only one batch and these scripts have several
batches so it would be a lot of stored procs to run.......but the main
problem is that they need to run concurrently in order to save a lot of time.
--
"Just because you don''t know how to do something doesn''t mean it can''t be
done"

Billy Rogers

Currently Using SQL Server 2000, Office 2000 and Office 2003

http://thedataguru.blogspot.com/

 

[Billy Rogers]

We use SQL Server 2000 so we have DTS not SSIS. I've thought about using
it , but it's awful. There's alwasy something that it lacks that keep me
from getting it to do exactly what i want. With VBA i have much more
control.
--
"Just because you don''t know how to do something doesn''t mean it can''t be
done"

Billy Rogers

Currently Using SQL Server 2000, Office 2000 and Office 2003

http://thedataguru.blogspot.com/