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