Coding for faster data entry (1 Viewer)

J-F

Registered User.
Local time
Today, 16:12
Joined
Nov 14, 2001
Messages
41
I have a database with a time field (hh:mm:ss) amongst others. There will be hundreds of entries to be made. The times entered will be the times taken to do an event and will never be more than 1 hour long.

To simplify the data entry, I want to have a minutes textbox and a seconds texbox only for this field so that you can just tab from one to the other.

My question is, how can I translate the minutes and seconds enetered in these 2 textboxes into a hh:mm:ss formatted database field?
 

LittleJonny

New member
Local time
Today, 16:12
Joined
Nov 13, 2001
Messages
7
You can use the Format(timestring, "HH:MM:SS") to get any format that you want.

Hope this helps
LJ
 

Users who are viewing this thread

Top Bottom