Hi all
Oh...I found that Right click "Form", then go to "Event", I can set the Timer and timer interval!!
But the problem is how to coding for them...
Example:
Each form is refer to the record(from the table) need to change every few seconds.
It must be the timer Event!! (I think)
Is that I have to put this
DoCmd.GoToRecord , , acNext
inside the code??
But how it knows if it EOF then go back to the first record
DoCmd.GoToRecord , , acFirst
and make a loop??
Please help EVEY ONE!!
Oh...I found that Right click "Form", then go to "Event", I can set the Timer and timer interval!!
But the problem is how to coding for them...
Example:
Each form is refer to the record(from the table) need to change every few seconds.
It must be the timer Event!! (I think)
Is that I have to put this
DoCmd.GoToRecord , , acNext
inside the code??
But how it knows if it EOF then go back to the first record
DoCmd.GoToRecord , , acFirst
and make a loop??
Please help EVEY ONE!!