Private Sub Commande5_Click() On Error GoTo Err_Commande5_Click Dim SQL As String Dim SQL4 As String SQL = "create table `" & txtbox1.Value & "` (`" & txtbox2.Value & "` char(20))" SQL4 = "INSERT INTO NomTables VALUES ( `" & txtbox1.Value & "` )" DoCmd.RunSQL SQL4 DoCmd.RunSQL SQL MsgBox ("La table a été créé") Exit_Commande5_Click: Exit Sub Err_Commande5_Click: MsgBox Err.Description Resume Exit_Commande5_Click End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question