Time format problem

[Bdowns]

We have a machine that automatically pulls a time code off a video. Unfortunately, in addition to the time, it pulls the frame as well so that the format is as follows:

hh:mm:ss:ff



We have tried creating a custom time format but have had zero success. We could enter it as a text field, but if at all possible would prefer it to be a time field.

Is there any way to get access to recognize the above format as a time code or to automatically cut off the frames (since we don't really care about them)?

Thanks

[June7]

The parts will always be two characters each? Is it 24-hour clock time? How are you getting the value into Access table? This will drop the frame code and convert to AM/PM:
CDate(Left(x, 8))

[Bdowns]

It is 24 hour clock-time, which is how we would like it to be. We input the time value into access using a time code wedge which is a device that reads the time encoded in an audio signal from video. When you press the Time Code button, it enters hh:nn:ss:ff; where ff is the frame (the video records 30 fps). Ultimately, we would like access to keep the 24-hour clock, but cut off the frame. Suggestions? Thanks

[June7]

The Time Code button is where - an Access form? Can you program the code behind it to use Left(x, 8)?

[Bdowns]

The Time code button is on this device: http://www.pro-sound.com/Merchant2/m...ry_Code=horita. The device reads an audio signal with an embedded time code. We use it for logging the time at which an organism was recorded by a camera on our remotely operated vehicle.

[June7]

Where is the code that says 'save this time value to this field in this Access table in this Access file'? What controls the communication between the device and Access file? If Access has control, how does it know to 'grab' this time code? Do you position cursor into textbox on form and then click the Time Code button on the device? I have no experience with data input devices other than mouse and keyboard but I think that is how a barcode scanner works.

I suspect will have to use code in some event (textbox AfterUpdate, form Close) that will correct the captured time value.

Doesn't matter if you enter value as AM/PM or 24-hour, Access will display as AM/PM in a Date/Time datatype field unless you apply a format to the field to display differently. Format setting does not change the value.