Results 1 to 3 of 3
  1. #1
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402

    form timer control code not working sometimes

    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.

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Quote Originally Posted by trevor40 View Post
    ...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)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-17-2015, 05:18 PM
  2. Replies: 7
    Last Post: 01-28-2014, 04:52 PM
  3. Timer Event Code Stops After First Run
    By burrina in forum Forms
    Replies: 3
    Last Post: 02-19-2013, 09:46 AM
  4. Replies: 4
    Last Post: 02-09-2013, 09:26 AM
  5. Code not working with tab control
    By pg13Reader in forum Programming
    Replies: 4
    Last Post: 12-13-2011, 06:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums