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.
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.
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
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.
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.
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.
I got it but how to make the hh:mm:ss format
I'm looking on the net and find:
Does this do it for you?Please Login or Register to view this content.
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?
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.
I have uploaded the sample file.
Thank you
Can anyone please help me on this?
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.
It's working perfect. Thank you.. you are a genius..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks