Access VBA: How do I delete all records in a table? Print

  • 5

=========
QUESTION
---------
How do I delete all records in a table using VBA?

=========
ANSWER
---------
Simply execute a SQL statement as follows:
DELETE * FROM NameOfTable;

=========
EXAMPLES
---------
Docmd.RunSQL "DELETE * FROM NameOfTable;"

=========
APPLIES TO / KEY WORDS
---------
Microsoft Access
VBA
SQL

=========
REF
---------
http://www.access-programmers.co.uk/forums/archive/index.php/t-81194.html

---
http://www.anysitesupport.com/access-vba-how-do-i-delete-all-records-in-a-table/
http://anySiteHosting.com


Was this answer helpful?

« Back