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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Delete forms record and subforms record 2
Deleting records problem 14
How to export table from outlook into ms access table? 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Delete Multiple records 2
DELETE FROM a table WHERE... 1
delete records from one table if not in another 9

Back
Top