How display Auto-refreshing counter ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to display on a form the number of records in some other table. The
count needs to autorefresh on a timed basis.
The table will be continually updated (with both Inserts and Deletes) by
other users and other processes. This is a multi-user split database in
Access 2003.

Thanks.
 
Use the Form Timer event.
Set the Timer Interval to the value necessary to refresh as you want it.
The value is in milliseconds, so 1000 is 1 second.

Then in the timer event, execute a DCount function.

Me.txtRecordsInTable = DCount("*","TheTableName")
 
Back
Top