473,883 Members | 1,605 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Is there a time picker?

Seth Schrock
2,965 Recognized Expert Specialist
I'm currently working moving a process from Excel to Access. In the existing Excel sheet, there are two fields: Completed Date and Completed Time. Completed Date works great with the Date Picker in Access. Is there a similar thing for times?
Oct 25 '12 #1
4 34130
32,584 Recognized Expert Moderator MVP
I don't think so Seth. There wouldn't be a need as far as I can see. The need for a date picker is mainly due to the non-standard nature of dates, whereas times follow strict rules quite well.

If you must have something though, a TextBox displaying a value with some small buttons around it to up and down the hours and minutes should be easy enough to set up using standard form tools.
Oct 26 '12 #2
2,322 Recognized Expert Moderator Top Contributor
Now I don't know what you are recording, but a textbox with the default set to the current time might be a good start, and then as NeoPa said buttons to increase/decrease the actual hours/minutes.
Oct 26 '12 #3
5,501 Recognized Expert Moderator Expert
There is an active-x control available in V2010 that has the ability to handle the time.
Two drawbacks:
(1) The popup portion is still just the month; however, if you tab into the control you can use the up/down arrows to step thru the date and time - not intuitive as there's nothing indicating that one can do this, I discovered it by playing with it.
(2) If the *.DLL (sorry don't remember the name) isn't installed correctly... or isn't installed as on one client pc... then the control breaks and it doesn't even let you know there's an issue... it just shows blank and the user can't do anything with the control. Took 2 days to discover that issue... I.T. fixed by a clean install of Office.

As a work around:
I've made a popup that does this trick and with the new date picker it works well as there's less coding to get the date in the correct format. Unbound form. Unbound Txtbox set to date format. two unbound cbo with the record source as list and entered the hours into one and minutes into the second and set the list length to show them all (used 24 hour clock otherwise you'll need another for am/pm) I have also done this using the spinner controls however most of my users like the cbo better.
The on open event pulls the system clock and pre-enters the current date and selects the hour and minute.
Command button to close has the event to enter the time into the related field.
In the related field I use the old docmd to open the form passing the field table and name as open arg on the double-click event.
I've also played with a custom event when I like.

Well an all day trip so I wont be able to get back this until later
Oct 26 '12 #4
Seth Schrock
2,965 Recognized Expert Specialist
I think that I will go with an Input Mask instead. I just discovered that there was an input mask for times. The users currently have to type it in so having the ":" already inserted should be enough for them. Thanks for all the input.
Oct 26 '12 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

by: john | last post by:
Can someone give me a url of a time picker? I found a lot of date/time picker but no timepicker alone. I just want a time picker. Thanks.
by: Adrian Parker | last post by:
Hi. I have a date time picker in my program which uses ADO to read from an Access database. It works perfectly, unless the database is empty (no records) when opened. When you try to open an empty database, the date time picker returns error 545. Any attempts to progmatically add new records after the empty database has been opened returns, or to use the DTP and set a new date for those added records, "Field not updateable, Bound...
by: BerkshireGuy | last post by:
Okay - shot in the dark. Is there a time picker control that lets the user's select the time by moving the hands on a clock? -B
by: TD | last post by:
This code doesn't work. Every posting I can find suggests that it should. If TypeOf controlname Is DTPicker then do something here End If I am using the Date Time Picker control and wish to use TypeOf to determine if the controlname is indeed a Date Time Picker control.
by: XmlAdoNewbie | last post by:
Hi All, I am wondering if it is possible to allow nulls or empty strings when it comes to the datetimepicker control. I have an app with a few datetimepickers on it and there are some instances when i don't want a date to show at all but the datetimepickers always have at least todays date in it so when i go to press the save button on my app there is always a date stored in the retrieved field. Is there a way to say "hey i don't want a...
by: Darhl Thomason | last post by:
I'm converting my Access 2003 VBA app. I have a number of date fields in my db that I want to use the date/time picker control with, but if there is no entry in my database, I want the date/time picker to show no date. Right now the first time it shows a blank date record, it inserts today's date. But as I move through the db and it finds a date in that field, the next time it finds a blank data record, it uses the last one as the...
by: Michel Posseth [MCP] | last post by:
I have a problem with the date time picker validate event wich i believe is a bug How to reproduce : throw on a form a date time picker control and a textbox control select the validating event of the control and add this code
by: fredloh | last post by:
i have a tab control on my form. i then have several microsoft date and time picker control on the tab control. when i select a date on any of the date and time picker control, the result of the control's value is always 12:00:00 am instead of the date i selected even though the date displays correctly on the date and time picker control. the controls are unbound. why is this? i also have another identical form where the date and...
by: Sabbuser | last post by:
Hey Guys please help me out!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I have placed a Date & Time Picker Control on a form in Windows 2000, When our Organization has upgraded all the PC's with Windows XP. Now i can't find the Date&Time Picker Control on the Form, it is showing a blank box. I have visited the Microsoft website, there i found that "Date&Time Picker Control has been eliminated in Windows XP".
by: pradeeplnarayan | last post by:
Hi Peers, I like to have a simple time picker in javascript, similar to the one that is in our windows OS (Double click the time in your windows sytem tray). It should allow users to set only time in hh:mm:ss Am/Pm format. It should not hav any popups. Any help on components/resources on this would be greatly appreciated. Regards, Pradeep.
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.