Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Controlling Windows (Access 2003)

    Is there a way to send instructions to Windows that would "unlock" the computer?
    I have a program that is set on a scheduler. The last step is for several emails to be
    sent. My issue is, the emails are not being sent until I log back in the next morning.
    They are being created, but are waiting for the CTL-ATL-DEL / Password to take place before
    they are actually being sent.

    Can I use an API or other means to send this from Access, let the program finish, then
    resend to relock the computer.

    Hope I am making sense.


    Thanks
    Richard

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Controlling Windows (Access 2003)

    Are you using a scheduled task in Windows? If so, you can specify that it runs under a specific account, and provide a password.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Controlling Windows (Access 2003)

    We are doing that, but the problem is the "SendKeys". To get around some Outlook security, we are
    creating the email, then using the SendKey to "press the sned key" so the email will be sent.

    With the computer locked, the focus is not on the email, but the login window, so the send key
    is not sending the email until a user logs in the next morning.
    Richard

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Controlling Windows (Access 2003)

    See <post#=317048>post 317048</post#> for some ways to deal with the Outlook security warning that is displayed when you send e-mails using code. The free utility ClickYes is the simplest to use.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •