Inputting time values

N

Nathan Wolfe

I have a field where users put times in for the event. It's a text box and
they simply type in the value. Does anyone know of a clock control (like the
calendar control) that I could put in the form for them to enter a time
value? Thanks.
 
W

Wayne-I-M

Hi Nathan

To create a "clock" in access is quite simple but not sure if this is what
you are looking for. Are you looking simply a method to input "now" (time)
or dropdown's with hours and minutes that update a control. etc etc.

To create a "clock"
Create an unbound text box
Set the format to hh:mm:ss AMPM
Use the Timer like this textbox=Now()
Set the form's timer interval to 1000 (to give you seconds)

One method of updateing a control to some time
Create 2 combo boxes
Source Type for both is Value List
1 = 1;2;3;4;5;6; up to 24
2 = 1;2;3;4;5;6; up to 60
Set the AfterUpdate to update your times control

Also have a look at this excelent site suggested by Bill Mosca
http://vb-helper.com/index_multimedia.html
Search the page for "clock" and you will find loads of different samples.

Good luck
 
N

Nathan Wolfe

I want the user to be able to input a time they select off a clock, not just
now, since they'll be entering time values for events that have happened in
the past. The link will help. Thanks for answering.
 
M

Mr. B

Hi Nathan

To create a "clock" in access is quite simple but not sure if this is what
you are looking for. Are you looking simply a method to input "now" (time)
or dropdown's with hours and minutes that update a control. etc etc.

To create a "clock"
Create an unbound text box
Set the format to hh:mm:ss AMPM
Use the Timer like this textbox=Now()
Set the form's timer interval to 1000 (to give you seconds)

One method of updateing a control to some time
Create 2 combo boxes
Source Type for both is Value List
1 = 1;2;3;4;5;6; up to 24
2 = 1;2;3;4;5;6; up to 60
Set the AfterUpdate to update your times control

Also have a look at this excelent site suggested by Bill Moscahttp://vb-helper.com/index_multimedia.html
Search the page for "clock" and you will find loads of different samples.

Good luck

--
Wayne
Manchester, England.





- Show quoted text -
Click to expand...

Nathan,

I have a copy of a database that I got from someone else that has a
form in it that will allow users to specify time by making selections
form groups of radio buttons. If I could find the URL where I got if
from, I would be happy to share it with you and the group, but I just
cannot find it.

The only thing that I did find was an email address for the developer:

I do not know if it is still good: compugeeks at hotmail dot com

If you are interested and are not able to contact the developer, post
back here and perhaps we can find a way to share the file.

HTH

Mr B
 
Top