Creating a Form Button to Clear Table Data

[wojosh6]

Can someone please help me with the code that will enable me to clear all of the data within a table (leaving the column headers) by clicking a form button. I'm ok with setting up the button, just need the code now.

Thanks!
Josh

[pbaldy]

CurrentDb.Execute "DELETE * FROM TableName"

[wojosh6]

Hey Paul - thanks for the quick reply. I'm using the code below & the Table opens, but the data doesn't delete. Any idea what I'm doing wrong?



Private Sub ClearElementTables_Click()


'Clear Element Tables


DoCmd.SetWarnings False


CurrentDb.Execute "DELETE * FROM Comm_Loan_Data"


DoCmd.SetWarnings True
End Sub

Thanks!
Josh

[pbaldy]

That shouldn't open the table, just delete all its records. Is the table already open?

[June7]

SetWarnings not needed with Execute method.

The * wildcard is also not need but should not hurt. Fields do not need to be referenced because the entire record is deleted.

[DrGUI]

Try:

CurrentDb.Execute "DELETE FROM Comm_Loan_Data"