Good morning all....You can say I'm a novice access user. My background is VBA coding, Access and Visual Basic programming, but that is well over 12 years ago now. Different career paths led me to desktop and network administration.
I have been asked create an application in access to pull data from a number of different tables, and when editing records managers want to be able to approve the changes before updates to the main tables. This means I have a number of append and update queries running to do this work.
On the main form, if data is updated the records refresh automatically as follows
Private Sub Form_Open(Cancel As Integer)
Me.TimerInterval = 30000
End Sub
Private Sub Form_Timer()
Me.Refresh
End Sub
This works fine. However I've noticed a glitch. On the same form There is a command button that the user clicks, it launches a simple select query and the user can locate a record based on the criteria they enter.
This works fine also....however once the query is initiaited, it launches itself every 30 seconds as set in the coding above.
I've tried setting the focus to a field after the query is run, but I' have not had any luck so far.
Any ideas?
Many thanks
Larry B
I have been asked create an application in access to pull data from a number of different tables, and when editing records managers want to be able to approve the changes before updates to the main tables. This means I have a number of append and update queries running to do this work.
On the main form, if data is updated the records refresh automatically as follows
Private Sub Form_Open(Cancel As Integer)
Me.TimerInterval = 30000
End Sub
Private Sub Form_Timer()
Me.Refresh
End Sub
This works fine. However I've noticed a glitch. On the same form There is a command button that the user clicks, it launches a simple select query and the user can locate a record based on the criteria they enter.
This works fine also....however once the query is initiaited, it launches itself every 30 seconds as set in the coding above.
I've tried setting the focus to a field after the query is run, but I' have not had any luck so far.
Any ideas?
Many thanks
Larry B
