+ Reply to Thread
Results 1 to 13 of 13

Access Timer

  1. #1
    Registered User
    Join Date
    07-15-2014
    Location
    Mumbai
    MS-Off Ver
    2003
    Posts
    35

    Access Timer

    I want to have a timer on access form which will start with a command button and the start format will be 00:00:00.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Access Timer

    Look here for tutorial on timer

    https://www.youtube.com/watch?v=_Zr2Ud2l20o
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Access Timer

    Hi talkvinith,

    See this YouTube video:

    https://www.youtube.com/watch?v=_Zr2Ud2l20o
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    07-15-2014
    Location
    Mumbai
    MS-Off Ver
    2003
    Posts
    35

    Re: Access Timer

    Thank you for your reply. In this tutorial is showing as count down timer where I want the timer starts from zero in the format hh:mm:ss with a command button.

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Access Timer

    Hi,

    Instead of a "-1" you should put a "+1" to count up instead of down. Instead of starting at m_IntTimer = 10, you should start at zero.

    We were thinking that you would look at the video and study it well enough to make these changes.

  6. #6
    Registered User
    Join Date
    07-15-2014
    Location
    Mumbai
    MS-Off Ver
    2003
    Posts
    35

    Re: Access Timer

    I got it but how to make the hh:mm:ss format

  7. #7
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Access Timer

    I'm looking on the net and find:

    Please Login or Register  to view this content.
    Does this do it for you?

  8. #8
    Registered User
    Join Date
    07-15-2014
    Location
    Mumbai
    MS-Off Ver
    2003
    Posts
    35

    Re: Access Timer

    I tried with this where I am able to get the required format but the timer is not running,it stands as 0:00:00. Could you please help me?

  9. #9
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Access Timer

    Hi talkvinith,

    It is so much easier to help if you attach a sample file of what you already have. I'd expect this file to have a userform in it with a textbox where you have put most of the code shown in the YouTube video. We are certainly here to help but not do your problem for you. The better you data, explaining what you have and your expected result; the better our answer will be.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  10. #10
    Registered User
    Join Date
    07-15-2014
    Location
    Mumbai
    MS-Off Ver
    2003
    Posts
    35

    Re: Access Timer

    I have uploaded the sample file.

    Thank you
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    07-15-2014
    Location
    Mumbai
    MS-Off Ver
    2003
    Posts
    35

    Re: Access Timer

    Can anyone please help me on this?

  12. #12
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Access Timer

    Hi,

    The Form_Timer code should be something like this
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  13. #13
    Registered User
    Join Date
    07-15-2014
    Location
    Mumbai
    MS-Off Ver
    2003
    Posts
    35

    Re: Access Timer

    It's working perfect. Thank you.. you are a genius..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Running an access append query with parameters from Excel. Access version 2010
    By anthony1312002 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2017, 04:48 PM
  2. Double Handling within working code Write to access and fire access macro
    By robtuby in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-11-2015, 12:19 PM
  3. Access form works with access Viewer but not full version of Access?
    By Shanyn in forum Access Tables & Databases
    Replies: 1
    Last Post: 10-22-2014, 01:14 PM
  4. timer for 30 minutes and timer based events
    By mohak12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2014, 06:20 PM
  5. Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  6. [SOLVED] Stopping a Timer / Running a timer simultaneously on Excel
    By Paul23 in forum Excel General
    Replies: 1
    Last Post: 03-10-2006, 08:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1