Timer auto update a form each 15 minute

[Jalisco]

This is the first time I have ask any question. I can work Access very well but when it come to Access VB I'm lost, I'm good at using other people Code but can't seem to write my own. If you can direct me to a good source I would be glad to get the book or file. Here my question
I have a form that is getting data from different querys and forms I can update all figure with the Shift-F9, but would like to have this automatically update each 15 minute this data is display on the wall during our semi-annual inventory for all to see are status on inventory completion.
Thank
Jalisco.

 

[Oldsoftboss]

In the form properties select All, then right down the bottom there are 2 events. On Timer and Timer Interval.

In the On Timer box type [eventprocedure]. A little button will become visible on the RHS. Clicking this button will take you to the VB Editor.
Type:

Me.Requery

The Timer Interval box on the form properties is in 1/1000ths of a second. So entering 1000 will update the form every second. So you will need to update 1000 x 60 x 15 = 900000

HTH

Dave

 

[Jalisco]

Dave

Thank you for the answer, I really injoy working with Access

take care

Jalisco