Replication activated by Button on Form

[GriffG]

I am trying to find a way to put a button onto an Access Form and have that activate the replication prosess. how would one do that?

 

[ZmrAbdulla]

This code can be used to create a replica.. You must have the db closed to create a replica.

Private Sub cmdCreateReplica_Click()
On Error GoTo cmdCreateReplica_Click_Error
   [b] DoCmd.RunCommand acCmdCreateReplica
[/b]Exit_cmdCreateReplica_Click:
    Exit Sub
cmdCreateReplica_Click_Error:
    Select Case Err.Number
    Case 0
    Case 2046 Or 2501
        Resume Next
    Case Else
        MsgBox Err.Number & ": " & Err.Description
    End Select
        Resume Exit_cmdCreateReplica_Click
End Sub

Zameer Abdulla
[sub]Jack of Visual Basic Programming, Master in Dining & Sleeping[/sub]
Visit Me

 

[GriffG]

The process of creating the replicas to start with is no problem. I am able to do that from the menu before I lock the Database.

what I am wanting is code to be able to do the syncronisation process from a button on the form.