Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Time Cards - Entering Data in friendly format 1

Status
Not open for further replies.

Menglish

Programmer
Jun 22, 2001
66
This should be very simple but I have drawn a blank. I want to have a data entry form for Time Cards. They will be entered on Saturday for the previous week. I can lay out the screen but using DateTime function makes the screen far too intimidating. I would like to have a time in and a time out twice for each day. The input time needs to be in 12 hour format. I was thinking of using time() but has issues with trying to accept AM's & PM's. What was going to be a quick simple form has turned into a bugger bear. Any ideas would be greatly appreciated.
 
Neither make it hard for the users nor you to use or design that form. Per Time entry have the following:

1 Textbox for hours, Format R, Inputmask "99", check for Maxvalue 12 in Valid.
1 Textbox for Minutes, Format R, Inputmask "99", check for Maxvalue 59 in Valid
1 Combobox set to type Values with "AM,PM" as Values and Incremental Search on.

Set the first in/out to AM as default, the second in/out to PM as default.

No fiddling with more complicated masks etc, you have the atomic values at hand to create the dateteims from these, everything's good.

Bye, Olaf.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top