pbaldy. force open file with access. The extension is incorrect but the file contents are there. Access should recognize the file. Im not too sure how the attached file is relavent at all. but these were my findings.
code i found, operates a clock.
Code:
Private Sub Detail_Click()
End Sub
Private Sub Form_Close()
DoCmd.RunCommand acCmdExit
End Sub
Private Sub Form_Load()
DoCmd.MoveSize , 2500
Me.TimerInterval = 1
start = 1
End Sub
Private Sub Form_Timer()
Dim hv As Integer
Dim adh As Integer
Me.DClock = Time
Me.Ahours = Format(Time, "hh")
Me.Amin = Format(Time, "nn")
Me.Asec = Format(Time, "ss")
If Me.Amin >= 12 And Me.Amin <= 23 Then
adh = 1
ElseIf Me.Amin >= 24 And Me.Amin <= 35 Then
adh = 2
ElseIf Me.Amin >= 36 And Me.Amin <= 47 Then
adh = 3
ElseIf Me.Amin >= 48 And Me.Amin <= 59 Then
adh = 4
End If
hv = IIf(Me.Ahours = 12, 0, IIf(Me.Ahours > 12, Me.Ahours - 12, Me.Ahours)) * 5 + adh
Dim ctrl2 As Control
For Each ctrl2 In Controls
If Left(ctrl2.Name, 1) = "h" Then
If Right(ctrl2.Name, 2) = hv Then
Me(ctrl2.Name).Visible = True
Else
Me(ctrl2.Name).Visible = False
End If
End If
Next
Dim ctrl As Control
For Each ctrl In Controls
If Left(ctrl.Name, 1) = "s" Then
If Right(ctrl.Name, 2) = Me.Asec Then
Me(ctrl.Name).Visible = True
Else
Me(ctrl.Name).Visible = False
End If
End If
Next
Dim ctrl3 As Control
For Each ctrl3 In Controls
If Left(ctrl3.Name, 1) = "m" Then
If Right(ctrl3.Name, 2) = Me.Amin Then
Me(ctrl3.Name).Visible = True
Else
Me(ctrl3.Name).Visible = False
End If
End If
Next
If start = 1 Then
Me.Clock.SetFocus
start = 2
End If
End Sub