(1) how can i turn my warnings back on after code has turned them off
(2) This is my code and it is turning off warnings and not turning them back on, can anyone see why?
Private Sub Import_Files_Click()
Dim strSQL As String
strSQL = "INSERT INTO All_Data_Static SELECT [Combined Data].* FROM [Combined Data];"
CurrentDb.Execute strSQL, dbFailOnError
MsgBox ("Files transferred to static tables")