Counting how many times a button has been pressed

[chrisbrooke]

Hello,

How do calculate how may times a button has been pressed. Ive tried setting a variable say count=0 when the form opens(event). Then simply iterate this count on the onclick (on the button in question) event. However, this dosent seem to work. Any ideas? Thanks in advance.

 

[Mile-O]

Private Sub cmdMyButton_Click()

    Static intClicked As Integer

    intClicked = intClicked + 1

    MsgBox "This button has been clicked " & _
        IIf(intClicked = 1, "time", "times") & ".", vbInformation, "Example"

End Sub

 

[namliam]

If you want to preserve it after closing the DB you will have to store it in the DB somewhere/somehow (try in a table )...

Regards