Results 1 to 6 of 6
  1. #1
    live2ride is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2012
    Posts
    70

    how to check if computer is locked


    i have start time and end time for tracking how much time was spent working on specific record. when a user clicks start time, time is being recorded even though the user have gone to lunch or somewhere else. i would like to check computer state to see if the computer is locked so the timer can be stopped or started if computer is unlocked. thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,954
    You want to check if Windows has timed out and acivated the password accessibility for the user's computer?

    What events could be triggered in Access when Windows times out and when the user returns and logs back in?

    Why the need to restart time? User has the record locked regardless of whether or not they are still sitting in front of the computer.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    live2ride is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2012
    Posts
    70
    all records are user specific so we dont have any issues of records being locked. users are using access as well as other programs, so i need to check the state of the computer itself to see if computer is locked, and if computer is locked i want to pause the timer as user is obviously not working during that time.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,954
    Google: Access vba idle
    Review http://support.microsoft.com/kb/210297
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    live2ride is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2012
    Posts
    70
    unfortunately that site shows how to detect if user was idle in access, i need to find out a way if user is idle on computer and not in access as the users might be working on other stuff and not touching access for a while

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,954
    Google: VBA is computer idle

    Maybe this one has solution: http://stackoverflow.com/questions/2...s-xp-using-vba
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-25-2012, 10:36 AM
  2. Check if file is locked
    By AKQTS in forum Programming
    Replies: 4
    Last Post: 08-10-2011, 03:23 PM
  3. I've somehow locked myself out
    By Rapunzel in forum Security
    Replies: 2
    Last Post: 07-25-2011, 02:10 PM
  4. Locked for editing
    By Ted C in forum Security
    Replies: 19
    Last Post: 10-12-2010, 08:32 PM
  5. Replies: 1
    Last Post: 02-12-2010, 01:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums