J
JP SIngh
Hi All
I am writing an ASP application that deals with the TV tapes and two of the
fields is what I am having issues with
I need to store the duration of the program i.e. DURATION field only to
accept Numerical entries in the form 000:00:00 (min:secs:frames)
I also need to store the TIMECODE field only to accept Numerical entries in
the form 00:00:00:00 (hours:mins: secs:frames)
Does anyone know
1. What datatype should I be using in my Access 2000/ 2003 database.
2. How can I validate this field when allowing users to add the correct
data.
Thanks in advance for your help.
I am writing an ASP application that deals with the TV tapes and two of the
fields is what I am having issues with
I need to store the duration of the program i.e. DURATION field only to
accept Numerical entries in the form 000:00:00 (min:secs:frames)
I also need to store the TIMECODE field only to accept Numerical entries in
the form 00:00:00:00 (hours:mins: secs:frames)
Does anyone know
1. What datatype should I be using in my Access 2000/ 2003 database.
2. How can I validate this field when allowing users to add the correct
data.
Thanks in advance for your help.