how to refresh form automatically after a particular interval

[Naveed Pathan]

hiiiii friends

i have done some programming that based on the querries and i get the result
when i refresh the form but some time i forget to do so . so is ther any way
to refresh the form after a particular interval such after each ten seconds
etc. if it is so it will make my life easy thankx in advance

 

[BruceM via AccessMonster.com]

You could use the timer event, with the interval set to 10,000 (milliseconds).
However, you should not, as the form will almost inevitably end up refreshing
in the midst of data entry. Better would be to add Me.Refresh to whatever
code runs the queries. Your question lacks specifics about the code you are
running ("some programming" could mean many things), so the answer is
necessarily vague.

 

[Naveed Pathan]

friend i mean to fresh the form including all the querries in the backend
thankx

 

[BruceM via AccessMonster.com]

The VBA code te refresh a form is:
Me.Refresh

However, it works only on forms. To "refresh" a query you need to run it.

friend i mean to fresh the form including all the querries in the backend
thankx

You could use the timer event, with the interval set to 10,000 (milliseconds).
However, you should not, as the form will almost inevitably end up refreshing

[quoted text clipped - 9 lines]