If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to refresh form automatically after a particular interval
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 |
#2
|
|||
|
|||
how to refresh form automatically after a particular interval
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 wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 |
#3
|
|||
|
|||
how to refresh form automatically after a particular interval
friend i mean to fresh the form including all the querries in the backend
thankx "BruceM via AccessMonster.com" wrote: 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 wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 . |
#4
|
|||
|
|||
how to refresh form automatically after a particular interval
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. Naveed Pathan wrote: 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] 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 -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|