time problems

[Spelthorne1]

I am having problems with one computer using the front end of our database. This happens all the time and the coding on this computer and the others are all the same.

At 12pm, 3pm and 5pm we want the database to update itself.

If Time = "15:00:00" Then
    DoCmd.OpenForm "Timeupdateinfo", acNormal
        [Forms]![Timeupdateinfo].lbltime.Caption = Time
        [Forms]![Timeupdateinfo].lblaction.Caption = "Autoupdate commencing in 3 seconds."
                
DoCmd.SetWarnings False
DoCmd.OpenQuery "UserDailyDCUpdate", acViewNormal, acReadOnly
 DoCmd.SetWarnings True
End If

At 3 the form Timeupdateinfo appears with the current time and action - this form has a timer event of 5 seconds then it closes. The query is then hopefully actioned.

Unfortunatly, on this certain computer, the time comes and go's without anything happening.
We're completely confused over why this happens.

 

[DES]

Have you checked to make sure the regional settings in the control panel is the same on the computer that it will not work on as it is on the others?

 

[namliam]

This shouldnt work at all.... Time is really a double, not a string...

Try Format(time(),"HH:MM:SS") = "15:00:00"
or Time = 15/24 (15 hours out of 24)
or time = #15:00:00# (probably best)

Best regards