hundreds and tousands of seconds

[Bart Pauwels]

Hello,

I'm putting together a form to put in race-times
In excell one can set the cell-properties in cutom to mm:ss,000, but can
this also be done in Access?
Anyone an idea? I should be able to calculate within the "cells" to become
the best time, second time and so on.

THX

 

[John Vinson]

Hello,

I'm putting together a form to put in race-times
In excell one can set the cell-properties in cutom to mm:ss,000, but can
this also be done in Access?

Unfortunately, no.

Anyone an idea? I should be able to calculate within the "cells" to become
the best time, second time and so on.

If you need time to fractions of a second, I'd store it as a Double
Float number count of seconds - e.g. 11 minutes, 32.88 seconds would
be stored as 692.88. This can be formatted for display using an
expression like

[Racetime] \ 60 & Format([Racetime] - 60*([Racetime]\60), ":00.000")

 

[Bart Pauwels]

Hello,

I'm putting together a form to put in race-times
In excell one can set the cell-properties in cutom to mm:ss,000, but can
this also be done in Access?

Unfortunately, no.

Anyone an idea? I should be able to calculate within the "cells" to become
the best time, second time and so on.

If you need time to fractions of a second, I'd store it as a Double
Float number count of seconds - e.g. 11 minutes, 32.88 seconds would
be stored as 692.88. This can be formatted for display using an
expression like

[Racetime] \ 60 & Format([Racetime] - 60*([Racetime]\60), ":00.000")

So how should the time be inserted?
like 692.88?

Or is there a way to type it in in a "natural" way?

 

[John Vinson]

So how should the time be inserted?
like 692.88?

Or is there a way to type it in in a "natural" way?

You will need to use a form with two textboxes - one bound to the
double float field, and another unbound into which the user can type
(e.g.) "11:32.88". You'll then need some VBA code to parse the text
string into fractional seconds. Try http://www.mvps.org/access and
search for "time", I believe there's some sample code there.