=========
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
Clear
=========
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