[AccessD] Timer Control

Hi Julie:

Why not use the timer control on one of your forms:

In the event tab you first set the 'Timer Interval' to something like 10000
is equivalent to 10 seconds. Setting the value to zero turns off the  On
Timer event.

In the 'On Timer' event is where you add your code and it will run once
every time interval. Note: Putting a very short interval and adding a
complex piece of code into the event can drastically affect performance.
Here is a simple piece cut and pasted.

<code>

Private Sub Form_Timer()
 If Err.Number = 0 Then
  ' turn the process off during form opening/loading
  If bolLoadingFlag = False Then
   'toggle some value
   Me.MyToggle.Value = (Me.MyToggle = False)
  Else
   Me.TimerInterval = 0 'dynamically turn it off
   'You can turn it on through code like:
   'Me.TimerInterval = 10000
  End If
 End if
End Sub

</code>

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Julie
Reardon-Taylor
Sent: Tuesday, December 30, 2003 10:43 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Timer Control


Stuart, or anyone else who can answer,

Thank you for the link.  I can't seem to find where to get the Timer
control.  The only place that google came up with is the FMS Inc. site, and
the price for all of their components is $199.  Is the timer control
packaged with Access 2002, or is it a third party add-in?  I don't see it on
the ActiveX controls list in the software.





Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
www.pro-soft.net

_________________________________________________________________
Take advantage of our limited-time introductory offer for dial-up Internet
access. http://join.msn.com/?page=dept/dialup

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com