Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Location
    Plymouth, UK
    Posts
    59

    Angry Unanswered: Clock in Access Forms??

    I am building a database with about five different Menu forms, I want a consistant view on all of these forms including the current date and time, however the time part only shows the time the form was opened, is their anyway I can have a constantly updating clock??

    I am not brilliant with SQL, however Macros etc I am good with, any help would be most appreciated!!

    Ta very much!!

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Use the timer event on a 1 sec interval and update a label on the form ...

  3. #3
    Join Date
    Nov 2003
    Location
    Plymouth, UK
    Posts
    59
    Sorry could you explain how to, as currently have a txt box showing the time and date?? is it in the propertys part??

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    The timer event is at the form level. When you have set an interval you will have a method called Form_Timer() that you can use to update your textbox/label ...

  5. #5
    Join Date
    Dec 2003
    Posts
    1
    try this code on the on timer event of the main form.

    Set the timer interval to 1000

    '***************** Code Start ***************
    Private Sub Form_Timer()
    Me!lblClock.Caption = Format(Now, "dddd, mmm d yyyy, hh:mm:ss AMPM")
    End Sub

  6. #6
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465

    Re: Clock in Access Forms??

    Originally posted by Davekingwcp
    I am building a database with about five different Menu forms, I want a consistant view on all of these forms including the current date and time, however the time part only shows the time the form was opened, is their anyway I can have a constantly updating clock??

    I am not brilliant with SQL, however Macros etc I am good with, any help would be most appreciated!!

    Ta very much!!
    I send for you an Sample Base in Access 97 with a Clock Form, you can use then in your form or use the code for do do the same
    Attached Files Attached Files
    Saludos
    Norberto

Posting Permissions

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