Ashfaque
Search Beautiful Girls from your town for night
- Local time
- Today, 19:13
- Joined
- Sep 6, 2004
- Messages
- 897
Hi,
When I enter the time in any of the field it produces above error but after few seconds it calculates correctly with no error.
I dont have any idea of Server linked tbls data. I have recently moved all Access BE tbls to SQL Server and linked in Access FE and I am trying to make the db full worked..
Also I dont want to display such kind of lengthy format of time in my Access form.
Is there any solutions for both?
Please advise
When I enter the time in any of the field it produces above error but after few seconds it calculates correctly with no error.
I dont have any idea of Server linked tbls data. I have recently moved all Access BE tbls to SQL Server and linked in Access FE and I am trying to make the db full worked..
Also I dont want to display such kind of lengthy format of time in my Access form.
Is there any solutions for both?
Code:
Private Sub OTTill_AfterUpdate()
If IsNull(OTFrm) Then
OTFrm = Nz(OTFrm, 0)
Else
Dim X, Y
X = Left(OTFrm, InStr(OTFrm, ".") - 1)
Y = Left(OTTill, InStr(OTTill, ".") - 1)
OTTotHrs = (DateDiff("n", X, Y)) / 60
MsgBox ("Total Hrs : ") & OTTotHrs
End If
End Sub
Please advise