On 30 Sep 2004 23:01:08 -0700, Hannu wrote:
Hi.
In Access 2000 VBA there is Private Sub Form_Timer()object. What can i
do with it? What's the use of it?
Hannu
Well, you could make a label blink on and off every second,or change
color, or close the form if no one has entered data for, say , 10
minutes.
Set the Timer Interval to 1000 (for 1 second).
Code the Timer event:
If [DateControl] < Date() Then
If [DateControl].BackColor = vbWhite then
[DateControl].BackColor = vbRed
Else
[DateControl].BackColor = vbWhite
End If
End If
The date control will alternate backcolors if the date is before the
current date.
Set the Timer Interval to 0 to discontinue the code in the error
event.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.