form timer control code not working sometimes

[trevor40]

Hi I have an issue with a text box that is set to a default of time(), on startup/open the correct date is shown, I have added an update for the text box in the form timer section - text1 = time().
the form timer is set to fire every second.

Most of the time this works fine but sometimes it just stops with no apparent reason, it could be a day or a week until it stops. the time just stops incrementing, changing the timer interval to every minute does not fix the issue.



any ideas or help is appreciated.

[Missinglinq]

...sometimes it just stops with no apparent reason, it could be a day or a week until it stops...

You're really running an Access database for days or weeks at a time? If so, I suspect that this is the source of your problem, as it is not designed to run in such a manner, and doing so has been found, over the years, to be the cause of a number of problems.

Linq ;0)>

[trevor40]

Thanks for the reply Linq, I havn't looked at this problem for over a year now as I have changed employers, too complicated to go into now but I'm much happier now!. anyway after reading your post i have realised that the system that the DB was on does get reset each day using a windows app to do this via the DB, so it's not been running for over a week at a time but only 1 day at most. I am hoping that the problem will not show up at my new job. I'll post again if the problem does persist. thanks anyway.