Countdown Clock (1 Viewer)

[Snowflake68]

I have a form that automatically refreshes after a set time which is set by the user. They can set the refresh rate to anything from 5 seconds to 120 seconds using a dropdown box on the same form.
This all works and I also have a text box displaying the date and time of the time the form was last refreshed. All good so far.

What I would like is another text box counting down the seconds to the next refresh but I am stuck on how to achieve this.

I have placed a subform with a clock of the current time which is working. I then tried to calculate the time that the form will next refresh by adding the current time to the refresh rate. But this is not working because adding say 10 to the current date and time are just adding 10 days and not 10 seconds.

Any ideas how to convert the current date and time into seconds so that I can just add the number of seconds and then convert it back into a date and time again.
Not sure if this work but if anyone has any other ideas I will give them a try.

Thanks

 

[isladogs]

I have a countdown timer that you can use in your app.
It includes a variety of alarm sounds when the count reaches zero but these are optional
Countdown Timer - Mendip Data Systems

 

[Snowflake68]

I have a countdown timer that you can use in your app.
It includes a variety of alarm sounds when the count reaches zero but these are optional
Countdown Timer - Mendip Data Systems

Thanks I will take a look at this later today and let you know how I get on. Much appreciated.

 

[arnelgp]

use DateAdd() function (google the syntax) to add minute, second, hour, days, month years, etc.

 

[Snowflake68]

use DateAdd() function (google the syntax) to add minute, second, hour, days, month years, etc.

I already do this to get the date in the legible format like this but I want to convert it back to total number of seconds first.

=Format(Now(),"dddd") & " " & DayString(Now()) & " " & Format(Now(),"mmmm yyyy") & "  " & Format(Now(),"hh:nn:ss")

 

[theDBguy]

I already do this to get the date in the legible format like this but I want to convert it back to total number of seconds first.

=Format(Now(),"dddd") & " " & DayString(Now()) & " " & Format(Now(),"mmmm yyyy") & "  " & Format(Now(),"hh:nn:ss")

You can store the last refresh time in a hidden Textbox.

 

[Snowflake68]

You can store the last refresh time in a hidden Textbox.

I am doing this, I dont think I am explaining well enough for people to understand me.

I need to add 10 seconds to the last refresh time but it just adds 10 days and I cannot figure out how to add just seconds to a date and time. And then I just need to count down the seconds to the next refresh.

 

[arnelgp]

is this near or far?

 

[theDBguy]

I am doing this, I dont think I am explaining well enough for people to understand me.

I need to add 10 seconds to the last refresh time but it just adds 10 days and I cannot figure out how to add just seconds to a date and time. And then I just need to count down the seconds to the next refresh.

As @arnelgp suggested, you simply use the DateAdd() function to your stored refreshed time. For example:

DateAdd("s",10,Me.HiddenTextboxName)

 

[Snowflake68]

is this near or far?

This is exactly what I am after, thank you so much. I will incorporate this inside the forms I have. Hopefully I will get it to work.

 

[The_Doc_Man]

Just as a word of warning... timers are good when you need them. But because they are "interrupt" events they can interfere with form and code operation. When you open a form, you get a sequence of events - OnOpen, OnLoad, OnActivate, OnEnter, OnCurrent - and that sequence is fixed. Until the timer comes along. A timer cannot interrupt an active event - but it can insert itself between other pending events that are part of a sequence. You were wise to limit the values to drop-downs and to make the smallest interval 5 seconds. Even so, the more you add to the timer event's list of things to do, the more interference you trigger in other events that might be deferred because the timer just clicked.

I'm not saying don't use timers. Just be careful on how much you want them to do.

 

[Snowflake68]

is this near or far?

I have got this working on my main form by making the main form refresh when the Next Refresh hits zero but I also want to be able to stop the refresh from running. So if they select 0 it stops the timer event. This isnt working and if I select 0 it just keeps refreshing in a constant loop that I cannot get out of without closing the application.

Im off to watch England v Germany now so will revisit this in the morning.

 

[arnelgp]

Im off to watch England v Germany now so will revisit this in the morning

how was the game, i hope you bet on any side, otherwise just watching is boring.