Create a running clock then kick off modules

[rjgst3]

I want to create a running clock on a form then use that clock to kick
off modules to update tables, queries, reports etc. I have all the
update modules created in VBA, all I need to do is create a running
clock with hh:mm:ss to key off of to kick off my modules. Any code
available would be great....

 

[Allen Browne]

Use the Timer event of your form.

For example set the form's TimerInterval property to 1000 (Event tab of
Properties box.)

Then in the form's Timer event:
Me.[txtTime] = Now()
where txtTime is an unbound text box on your form, with its Format property
set to Medium Time or whatever you want.

 

[Van T. Dinh]

Check Access VB Help topic "Timer Event" and "TimerInterval Property".

Sample code esixts in the Help topics.