?
Solved

Textbox with Clock?

Posted on 2011-05-12
8
Medium Priority
?
414 Views
Last Modified: 2012-05-11
I'm using Access 2010.  Is there a way to have a textbox that defaults to a 24 hour clock control (similar to how a textbox can have a calendar control pop up)?

0
Comment
Question by:gcgcit
  • 4
  • 2
  • 2
8 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35747287
Meaning that you want to select a date from the calendar control and have it appear in the textbox in the 24 hour format?

If so, then set the format property of the textbox to: hh:nn:ss

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35747350
Sorry, I mis-read your post.

You can certainly build your own combobox to select Times in the 24hr format

But you need to tell us how you are dealing with the "Date" component.
You really cannot really have a time without a Date component.

You also need to specify the minimum time "Interval" you need.
Every second, Every minute, every 5 minutes, every 15 minutes, ...etc
0
 
LVL 21
ID: 35747556
The short answer is: No. There is not built in clock dialog like the Calendar.

Check out these links:
http://www.accessmvp.com/JConrad/accessjunkie/calendars.html

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 21
ID: 35747575
While most are calendars, some do have time pickers. Check out #30 in the list.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 35747677
Give this a try.

As I stated (and if I am understanding your request), you need to select the date, then the time

JeffCoachman
Access-EEQ27034256PickSelectDate.accdb
untitled.JPG
0
 

Author Comment

by:gcgcit
ID: 35748257
boag2000 - it works exactly like your screenshot - i was just hoping to not show the seconds - just hour and minutes - i turned "short time" format on the textbox itself and it worked - for some reason having it on the table itself wasn't enough
0
 

Author Closing Comment

by:gcgcit
ID: 35748260
screenshots are always helpful thanks
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35748828
...Yes if you create the form from the table it inherits the properties that the table had at that time.
So if you later change the table, the format will not update in the form.

Glad it helped and glad you got it working the way you wanted...


;-)

Jeff
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question