Automatic Refreshing

[RichMH]

I need to be able to refresh a control without the user having to activate it. I managed to do this using a timer interval, but having this constantly running slowed the other applications down too much. Does anyone know a better solution?

 

[RichMH]

OR is it possible to display an Access table in a VB application, and will it display records as they are added by other users?

 

[w1sh3]

Hope this helps :<br>
After the user adds a record, you could 'refresh'..or you could refresh on almost any event...<br>
<br>
Private Sub cmdRefresh_Click()<br>
'This is only needed for multi user apps<br>
On Error GoTo RefreshErr<br>
adoPrimaryRS.Requery<br>
Exit Sub<br>
RefreshErr:<br>
MsgBox Err.Description<br>
End Sub<br>
----<br>
or<br>
----<br>
Private Sub cmdRefresh_Click()<br>
'This is only needed for multi user apps<br>
On Error GoTo RefreshErr<br>
datPrimaryRS.Refresh<br>
Exit Sub<br>
RefreshErr:<br>
MsgBox Err.Description<br>
End Sub<br>
<br>

 

[w1sh3]

You could use the 'data form wizard' to connect to access db or ODBC...I find the wizard extremely helpful in generating snippets,etc.