By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,223 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Timer won't start

P: n/a
I want a textbox in an Access97 form to countdown from 100 to 0 when a
command button is clicked. Default Value of textbox is 100.
Currently clicking the command button starts the function running but
not the counter.
What have I done wrong???
Private Sub Form_Timer()
Me.txtCounter = txtCounter - 1
End Sub

Private Sub cmdBuild_Excel_Spreadsheet_Click()
Me.TimerInterval = 1000
Call Copy_Records_to_Excel
Me.TimerInterval = 0
End Sub

Thanks for any suggestions, Rick
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 16 Oct 2004 18:15:22 -0700, rb*******@compuserve.com (Rick Brown)
wrote:

If Copy_Records_to_Excel doesn't yield to Windows, no timer event will
ever reach your Form_Timer. Remember: Timer events are low priority,
they don't force a tick every 1000 ms.

Suggestion: a well-placed DoEvents in your Copy_Records_to_Excel
function.

-Tom.

I want a textbox in an Access97 form to countdown from 100 to 0 when a
command button is clicked. Default Value of textbox is 100.
Currently clicking the command button starts the function running but
not the counter.
What have I done wrong???
Private Sub Form_Timer()
Me.txtCounter = txtCounter - 1
End Sub

Private Sub cmdBuild_Excel_Spreadsheet_Click()
Me.TimerInterval = 1000
Call Copy_Records_to_Excel
Me.TimerInterval = 0
End Sub

Thanks for any suggestions, Rick


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.