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/

 

[Rick Brandt]

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.

When I want concurrent process on a sql server I build an SSIS package and
then run it from an Agent job. The SSIS package can run mutliple processes
in parallel.

An alternative would be to run each script from an Agent job and have a
stored procedure that calls the Agent jobs. Then the SP would only be
launching the jobs. It wouldn't wait for a job to complete before calling
the next one.

 

[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/