X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Combo Box Show Time From 12 Am To 12 Pm In 15 Min Intervals, Access 2016    
post Jan 10 2017, 03:45 PM

Posts: 1,028
Joined: 1-December 12

Currently I'm using a table to display times from 12:00 AM to 12:45 PM.
Is this the correct way to do this ?
I'm trying to make it easier for the user to select the time. Now, if the user wanted to select 3:00 pm the would enter 3 and get 3:00 AM and would then need to scroll down to
3:00PM. This is too slow. So I'm thinking of adding a AM - PM combo box that would speed things up, but, I need the right time of day to make calculations.

If anybody has a better idea I am listening, but, first I have to shovel the driveway!
Go to the top of the page
post Jan 10 2017, 03:58 PM

UtterAccess Editor
Posts: 17,436
Joined: 29-March 05
From: Wisconsin


Check out the TimePieces demo in the Code Archive - it includes a mini time picker. You can set the interval to 15 minutes, and the user can either use up/down arrows or their keyboard to enter a time. With a little work, you could also disallow times that are outside of your range of midnight to shortly after noon.

Hope this helps,


(;,;) Li'l Cthulu says: Please talk about what you're trying to do, as well as how you're doing it.
Changing your real table name to "Table1" and your real form name to "Form1" in your posts makes it more difficult to understand what's going on, not easier.
Guidelines for Posting Questions
Go to the top of the page
post Jan 12 2017, 05:15 PM

Posts: 1,028
Joined: 1-December 12

Thank you Doctor.

I found what I was looking for in Time Pieces.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    18th August 2017 - 03:55 AM