Form Refresh

[crann]

Hi

I have a form which I use as a task manager, my tables are linked to Sharepoint so other members in my office have live data in my database.

All working ok the only thing is when we complete a task we select a tick box which then displays a giant green tick to confirm task has been completed, is there anyway I can set the task manager form to refresh every 10 seconds when its open so memebers can see immediately when a task has been completed oppose to having to hit refresh ot open and close form?


Thanks

 

[VaYooper]

Have you tried setting the Timer Interval in the form properties?? You would have to set it to 300000 for 5 minutes since it is in milliseconds.

You can also add an On Timer Event, so it would say "Refreshing.." or "Updating" when the interval fires. Just put msgbox("WhateverYouWant")

 

[crann]

Hi

Would this constantly automatically refresh the form?

I basically need the form to just refresh every 10 seconds, over and over for as long as the form is open?

I am bit of a beginner so dont really know how to write the code

thanks

 

[VaYooper]

Yup... In Design View on the form in question you should see the property sheet on the right of the screen. Under the event tab, look for Timer Interval, set it to 10000(which is 10 seconds in milliseconds)

 

[crann]

ok

so found the timer interval etc.

If I put 10000 in the timer interval nothing seems to happen. If i create an on timer event with a meesage box to say "whatever" yup every 10 seconds a box pops up with the message and ok then just loops round but no data is changing so its not refreshing the form so to speak as soon as I hit F5 for refresh the data changes some im trying to automate that.

Sorry such basic question takes me a while to understand the answers

 

[VaYooper]

Slap this into the On Timer Event. Edit your form name in

Forms("MainFormName").SubformControlName.Form.Requery

 

[VaYooper]

If that doesn't work try putting this into the On Timer event:

me.requery

 

[crann]

Super worked perfectly

Thanks very much