Discussion Locked

MS ACCESS 2000 Countdown Timer

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'd like to display a coundown timer for a form in ACCESS 2000 and have the form perform another action when the timer is complete. I can time the form but can't find a way to display the time left before the action (another form) takes place. Maybe I'm just brain dead these days. I'd also like to know how to have a progress meter show up during a query or search which would be user helpful in a large database.

Thanks in advance

5 replies

by seagull data services

Countdown timer:
In the form timer event you'll need two parts
Something like this
static nextoccurrence 'time of...
DoEvents

select case now >= nextoccurrence
case true
'do whatever
'set time of next occurrence

case else
'display time remaining
lblCountdown.caption = _
format(nextoccurrence - now, _
"hh:mm:ss")

end select

Progress meter. I seem to remember from Access 2 that SysCmd has the ability to initialise, update and clear a progress meter in the task bar. However this has to be controlled in code and can't be updated while running a query.

by maxwell edison

One option is a third-party solution: Trigeminal Software has created the TSI Synchronizer, which provides a method to expose the synchronization progress.

Trigeminal Software?s website at http://www.trigeminal.com contains many replication resources. Trigeminal provides several free Jet replication tools and utilities, including the TSI Access 2000 Un-Replicator, the TSI Synchronizer, and TSO System Fields Removal Utility. Many of these utilities exist in Jet 4.0 and Jet 3.5 versions.

Maxwell

This discussion is closed to new replies.