PLEASE HELP!!!!!!!!!!

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Hi there

I need to add a timer to my form. I am working on a
database in access and want the time to continually
update. Can someone help me to show me how to add the
timer to your form and to link it to access.

PLEEEEEEEAAAAAAAAAAASSSSSSSS.

Craig
 
Craig,

Chris has already told you how to do this:

Chris wrote:
---------------------------
use the forms timer:-

Set the Timer Interval property to say 1000 (this equals 1 second)

Then add code to the On Timer event that updates the form
display. For example, the following code sets the caption
of a label to display the time:-

Private Sub Form_Timer()
Me.lblTime.Caption = Format(Now(), "hh:nn:ss")
End Sub
---------------------------

In design view for the form that you want to display the time, if you double
click on the square in the top left corner (where the 2 rulers meet), the
forms properties will be displayed. You will find the forms On Timer event
under the Events tab. If you place a label onto the form and resize it, you
then need to set the name of the label to lblTime in order for the code
above to work. To get to the code window (where you would place the code
above), you can click on the command button by the side of the On Timer
event and Clicking on Code Builder from the menu that pops up.

HTH,

Neil.
 
Back
Top