How do you delete all records within a table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I want to place a command button on my page view, to delete all the
records from a table, how would I do this? I want the table to remain in the
database.
 
sa said:
If I want to place a command button on my page view, to delete all the
records from a table, how would I do this? I want the table to remain
in the database.
Click to expand...

CurrentDB.Execute "DELETE * FROM TableName", dbFailOnError
 
Back
Top