|
||||||
|
15-Minute Increments By Richard Rost 4 years ago Force 15-Minute Increments in a Time Card Learn how to force your users to input values in 15-minute increments (or whole minutes, or whole hours, or whatever restrictions you want to set) by using a Validation Rule in Microsoft Access. Sharon from Puyallup, WA (an Access Expert student) asks: I'm creating a time card in Microsoft Access. How do I restrict time entry to 15-minute increments? I was hoping to enter a validation rule that warns them they must enter time in 15-minute increments and let the user fix it, instead of automatically rounding. I don't know how to structure the validation test. MembersI'll show you how to round the start time down to the nearest 15-minute interval, and round the end time up to the next interval. This is great for billing customers! LOL. We'll use the AfterUpdate event and the TimeSerial function along with some good old VBA coding.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today! LinksValidation Rules: https://599cd.com/ValidationRule
|
||||||||||||||||||||
| |||
Keywords: TechHelp Access timecard, time card, timesheet, time sheet, increments, intervals, 15-minute, 15 minutes, minute function, validation rule, validation text, timeserial PermaLink 15-Minute Increments in Microsoft Access |