Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2010

    Unanswered: time field does not work

    i've got a form that i placed a field called "timer" and set its default value to

    when i enter the form the field shows the time that i entered the form and it stops there.

    anybody knows why the time doesn't change?

    thanks in advance

  2. #2
    Join Date
    Aug 2009
    Up Nort' Wi
    Unless you are using the Form_Timer() event to refresh the field, it's going to be a static field. So it'll show the "Now" of when that field was populated. I would also avoid naming the field "timer" as I'm not sure it'll play nice with the Timer events.

    Sam, hth
    Good, fast, cheap...Pick 2.

  3. #3
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Here's what Sam is talking about:

    You'll need a textbox called txtOmega and you'll maybe want to add some cosmetics to it, like a frame around it.

    Go to your form's Properties and under the Event Tab find Timer Interval and enter 1000.

      Private Sub Form_Open(Cancel As Integer)
      'Displays while waiting for timer to crank up    
         Me.txtOmega = Now() 
      End Sub
      Private Sub Form_Timer()
         Me.txtOmega = Now() 'Display time
     End Sub
    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts