Hi guys!
Simple code that successfully controlls the form on another Access file, on the same PC is:
Code to trigger this function is:
I would need the same event to be triggered from PC1 to be applied on the PC2, on another access file. Both access files are located on the PC1.
I would like to avoid using the timer as it makes the application glitchy, but also would like to learn a new trick.
Simple code that successfully controlls the form on another Access file, on the same PC is:
Code:
Funcion RefreshAnotherForm(strDbPath As String, strFormName AS String)
Dim objAcc As Access.Application
Set objAcc = GetObject
objAcc.Docmd.OpenForm strFormName
objAcc.Forms(strFormName).Form.formField = "Message..."
objAcc.DoCmd.Requery
End Function
Code to trigger this function is:
Code:
Private Sub bttRefresh_Click()
RefreshAnotherForm "C:\MyDocuments\dbName.accdb", frmCustomers
End Sub
I would need the same event to be triggered from PC1 to be applied on the PC2, on another access file. Both access files are located on the PC1.
I would like to avoid using the timer as it makes the application glitchy, but also would like to learn a new trick.