Results 1 to 4 of 4

Thread: Microsoft Access 2003 - Dynamic Time?

  1. #1
    Cable Guy Jonny M's Avatar
    Join Date
    Jul 2003
    Location
    Loughborough Uni
    Posts
    4,263
    Thanks
    0
    Thanked
    4 times in 1 post

    Microsoft Access 2003 - Dynamic Time?

    I can insert the time and date into a form using Insert > Date and Time on the menu, but is there a way to make it show the correct time, instead of just when the form loads? I was thinking something along the lines of updating it every second, but I'm not sure how to go about it.

    Thanks

  2. #2
    Senior Member Shad's Avatar
    Join Date
    Jul 2003
    Location
    In front
    Posts
    2,773
    Thanks
    22
    Thanked
    40 times in 24 posts
    Can you not insert the time when you save the record rather than when you load the form?
    Simon


  3. #3
    Senior Member
    Join Date
    Feb 2004
    Location
    Lost in Cyberspace
    Posts
    374
    Thanks
    0
    Thanked
    0 times in 0 posts
    Hi

    Am i right in assuming you want to add a real time clock to a form? If so hes how to do it.

    If not, ignore the rest of my post

    1. Open form in design view
    2. Create a textbox where you want your "clock" to be.
    3. Delete the label
    4. Select the text box properties and and click the other tab and set the format to "long time"
    5. With the properties still open click the "form selector", click the event tab and set the timer interval to 1000.
    6. click the three dots next to the "On Timer" option and choose "code Builder"
    7. Edit the code so it shows

    Private Sub Form_Timer()
    [Timer1]=now
    End Sub
    8. Close the Vb edititor and go to view, your clock SHOULD now work.

    Falcon

    Edit: This will take the time from the system clock, so this time has to be correct for thsi function to work.

  4. #4
    Cable Guy Jonny M's Avatar
    Join Date
    Jul 2003
    Location
    Loughborough Uni
    Posts
    4,263
    Thanks
    0
    Thanked
    4 times in 1 post
    Cheers Falcon, that was it

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Microsoft Access Question...
    By TomWilko in forum Software
    Replies: 2
    Last Post: 24-08-2003, 12:53 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
  •