Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    Houston, Texas, USA
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    In/Out Log (Office 2010)

    I'm trying to create an in/out log where I can track the comings and goings of everybody in the office. If someone leaves, the receptionist clicks a button in the "OUT" column and when they come back in, she clicks a button in the "IN" column. It doesn't have to be two buttons, it can be a drop down box that says "YES" or "NO". I'm not even sure where I should create such a form. I had it in Excel 2003, but, it was a maintenance nightmare when some one new was hired or when someone left forever.

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,853
    Thanks
    4
    Thanked 259 Times in 239 Posts
    I would do this in Access so you can make the interface much quicker for the receptionist. You would get a lot more flexibility in the reporting side too.

    Try looking for a pre-made database on Microsoft's Template Download
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    Star Lounger
    Join Date
    Jan 2002
    Location
    Houston, Texas, USA
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'll give it a try! Thank you kindly!!

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Maybe add a pressure switch on their charir ... ...
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. #5
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,853
    Thanks
    4
    Thanked 259 Times in 239 Posts
    A pressure switch might just work - until the smarter ones figure out why their chairs are now plugged into the receptionist's computer


    What about a collar that gives electric shocks if the wearer leaves the office. This wouldn't be so prone to:
    - staff escaping down the fire escape after walking in past the receptionist
    - staff putting a box on their pressure switches
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Posting Permissions

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