Format(Now, "HH:mm:ss:m s")

is incorrect..... for some reason the ms is not reconised by visual basic...
I've not had time to look into it, but do simple test

Code:
Private Sub Command1_Click()
MsgBox Format(Now, "HH:mm:ss:ms")
End Sub
you will see the last 3 digits are actully seconds.....
my is "3" then the current seconds digit(s)

the...