Timer Intervals

Question

I have timer intervals set on a form in a runtime application of Access XP. I would like each user to be able to set their own preference for how frequently this OnTimer event occurs.  I thought it would be clever to create a form where they could select the frequency. So I made a combo box [cboTimerInterval]:

5 minutes (bound column 3000000)

10 minutes (bound column 6000000)

15 minutes (bound column 9000000)

Then I tried to set the timer interval property for the OnTimer event of the related field to

=[forms]!UserPreferences]![cboTimerInterval]       

...Tried it without the equal sign, too.

Boo hoo! Access no likey! The value you've entered isn't valid for this field.

Any thoughts?

Answer 1

In addition to what  John posted, you have an extra 0 in your intervals.  5 minutes is 300 seconds or 300,000 miliseconds.

Answer 2

thanks. i'll give it a try and vote "found this helpful" if it works!

Answer 3

I think you'll need to set the timerinterval property in the AfterUpdate event of the combo box:

Private Sub cboTimerInterval_AfterUpdate()

Me.TimerInterval = Me.cboTimerInterval

End Sub

It might be necessary to use CLng(Me.cboTimerInterval).