This last week I ran into a couple of scenarios where time is being tracked…in particular it’s employee shift times.  The client uses a 24 hr system, and needs to capture shift start and end times.  The problem is employees enter times without leading zeroes, or get confused as to how to properly enter a 24hr time setting in Access…you’d be surprised how many people try and enter time in the wrong format, even with Control Tips turned on.

A neat approach to this problem is to create two separate fields for time entering…you can either do it at the form level, or at the table level.  I would suggest using unbound fields at the form level that provide a drop down for hours, and a drop down for minutes.  Force in default settings, then give them an after update event on each field which flags AM or PM as a label to see, and then concatenates the values with appropriate masking and auto fills the actual time field in the table (invisible to the user).

Magic!  You now have a clever time picker to prevent errors for even the most IT challenged employee in your workforce.  Sometimes you have to do a lot of extra work to prevent GIGO – Garbage IN, Garbage OUT….this is one of those cases.

Jeff Shirley

Jeff Shirley

Founder & CEO
Jeff brings over 27 years of experience to the table, along with numerous awards, certifications, and real-world implementations.  His database solutions are currently running in industries including government, mining, agriculture, finance, education, science, research, non-profits, and healthcare businesses around North America and serve thousands of users day to day.  Jeff is a five-time MVP Award recipient for Microsoft Access, acknowledging contributions to community projects, evangelism, and educational outreach on Microsoft technologies.  Today there are less than 50 Access MVP’s worldwide. While Jeff focuses day to day on business management, IoT development, IT integrations and design, database architecture or other typical complex tasks, he also is a co-owner of Blue Heron Gardens, a commercial apiary running over 200 beehives.  Fresh honey is a small perk for many of our clients!

Mitch Redekopp

Mitch works with our clients day to day ensuring web development and IT projects are done to exceed customer expectations.  His background includes formal training in IT, Microsoft and CompTIA certifications, real-world business experience, and a true dedication to ensuring clients receive timely and professional support on their projects with Rivercity Technology Services.  Given the most difficult requests for IT solutions, Mitchell can assist our clients in finding a path to the best options which deliver results for our clients.  Mitchell is an avid soccer player and Manchester City fan, be sure to talk soccer with him when you can.