Display time countdown in label caption

[aman]

Hi guys

I hope anyone can send me code for this. When I click on Close button then it should display the countdown from 10 sec to 1 sec in a label caption and then after that just close the form.

Thanks

 

[JANR]

perhaps this might interest you: http://www.access-programmers.co.uk/forums/showthread.php?t=183265&highlight=countdown

JR

 

[vbaInet]

Here's an alternative. If the label is called lblShowSeconds then your code will look like this:

Option Compare Database
Option Explicit

Private TotalTime As Integer

Private Sub Form_Timer()
    Me.lblShowSeconds.Caption = TotalTime   ' Show on label
    
    TotalTime = TotalTime - 1   ' Decrement
    
    If TotalTime = 0 Then
        Me.TimerInterval = 0    ' Turn off the form's timer if it's reached 0
    End If
End Sub

Private Sub lblShowSeconds_Click()
    TotalTime = 10      ' Set it to 10 so it decrements every second in Timer event
    Me.TimerInterval = 1000     ' Run every second
End Sub

 

[aman]

Hello vbaInet

Thanks for your response. Actually I am building an application in excel as a frontend and Access as a backend. So I think the code you sent me over would not work. Could you modify the code so that will work on Excel.

Thanks a lot.

 

[DCrake]

Why are you using Excel as your front end? You are limiting your caperbilities tremendously.

 

[aman]

Hi Dcrake

In my company almost everyone got access to Excel spreadsheet but just few have MS Access installed on their systems. And also because my Manager asked me to develop the application in Excel as a fronend and Access backend.

Any help would be much appreciated.

Thanks

 

[DCrake]

Time to spend some money and get Access on all machines. You are going to find it very difficult to deploy new versions, especially if you are using the personal.xls to store your modules, forms, etc.

 

[ghudson]

You can download the Access 2007 Runtime for free.

 

[gemma-the-husky]

tbh, if you are trying to manipulate and manage data, then access IS the tool.

Excel is not the right tool to manage a complex set of data tables