Results 1 to 6 of 6
  1. #1
    rd.prasanna is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    25

    VBA to Capture Windows lock and Un-lock timings in Access 2010

    Dear All,

    I am working on the Productivity management tool.


    where the user will login and update his/her daily activity.

    here i am thinking of logic where system will automatically mark employee on break if the system is locked.

    As per the company IT policies system will automatically lock itself, If system is idle more that 5min.


    Application should capture this system lock and unlock timing.

    Kindly assist me in this regard.

    Thanks in Advance.
    Regards,
    Prasanna RD

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    What exactly is your set up? What are you measuring? Do you have a description of what you are trying to support with this database?

    I found the following on Google:

    What is productivity in manufacturing?


    To remain competitive, most companies need to use methodologies such as Lean Manufacturing to reduce waste and Six Sigma to increase quality, in order to improve manufacturing productivity. ... Improving manufacturing productivity involves collecting and analyzing data and making effective decisions.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You want a db to detect the time stamps when Windows starts and ends the idle period? This would require API calls and is probably something you could find code for but you may not be able to grasp it well enough to maintain it. Why not just detect db idle time? Or are you trying to create a db to monitor uptime of the system itself rather than the uptime of db use?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    rd.prasanna is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    25
    Hi Micron,

    Yes Exactly, I want a db to detect the time stamps when Windows starts and ends the idle period.
    Trying to create a db to monitor Up-time of the system itself rather than the Up-time of db use.

    Regards,
    Prasanna

  5. #5
    rd.prasanna is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    25
    Hi Orange,

    Application is designed to measure In-time and Out-time and Breaks.
    I want this Breaks should be auto captured if system is Locked.


    Regards,
    Prasanna

  6. #6
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    What you want is out of my league. I don't even know if the time stamps for initiating and cancelling the Windows screen locks are stored anywhere or not. This smacks of a registry or system services sort of thing. I took a look at about every API library listed here and found items for terminating or enumerating users, but found nothing specific to your goal although the ADVAPI list is perhaps the closest. You should check with your IT guys to see if the time stamps are obtainable via the start and stop of some system service, or if they are in fact stored. It might provide a clue as to how you'd retrieve them. I know the uptime of a pc is easy enough to discover, but that's not what you're after.

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

Similar Threads

  1. Replies: 5
    Last Post: 03-15-2014, 05:27 PM
  2. time lock in access
    By hedonistclub in forum Access
    Replies: 7
    Last Post: 02-05-2013, 08:31 AM
  3. Record lock issues - Access 2010
    By JTM39000 in forum Access
    Replies: 1
    Last Post: 01-11-2012, 07:58 PM
  4. Replies: 11
    Last Post: 07-17-2011, 08:56 PM
  5. Access DB Lock Out
    By ETCallHome in forum Programming
    Replies: 3
    Last Post: 06-13-2011, 08:22 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