DoCmd bypassing Error

[bretdunalp]

Works fine but when I update a table in error with duplicate data, I gat a warning with a yes no help on it I just want warning that to go away. I tried DoCmd warning and it bypasses the error and the first mesage box appears. I'm trying to limit user interaction (Microsoft Access was unable to append all data to the table).

Private Sub Command0_Click()
   
On Error GoTo Err_1234


DoCmd.RunSavedImportExport "Import-Successful"
  
MsgBox "It's finished"


Exit Sub


Err_1234:
    
MsgBox "you have done this before"


End Sub

[Micron]

Sounds like what you want to do is DoCmd.SetWarnings False before the update or transfer. Be sure to turn them on again before you Exit and in the error handler since you do not return to any point before that after an error.