Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Time with hundredths of second

    Hello experienced ones

    I am trying to create field in access 2000 that has a time with minutes, seconds and hundreths of a second. At the moment I can only get minutes and seconds.

    Also on entering the data I want the default to assume entry is in seconds not minutes.

    Thanks in anticipation

    Benny

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    experiment: a form with two text boxes and a button with _Click.

    Private Sub Test_Click()
    Dim isnow As Double
    Dim issex As Double
    isnow = Now()
    issex = isnow - Int(isnow)
    Text1.Value = isnow
    Text2.Value = issex
    End Sub

    ....you'll want at least 8 decimal places displayed in the textboxes.

    gotta confess i never found the need to use a database manager as a millisecond stopwatch so this doesn't take you all the way to a solution (...also i don't trust windoze to feed the time accurately).

    access dates are doubles in the format DAYS.FRACTIONALDAYS (0.00 being defined as the moment of mr. gates' conception or something similarly important)

    please post it if you crack it.


    izy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •