Link to home
Create AccountLog in
Avatar of dougf1r
dougf1r

asked on

MS ACCESS 2003 - Delete all records in a table

Hello Experts,
I'm working with a simple data entry form.  Please describe how you would create a button or provide code for an "On Click" enabled subroutine to delete all records from the form's source table.  Perhaps a looping delete record VBA code or a button that would delete all records from a specific table.....
Thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of jlindler
jlindler

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Shanmuga Sundaram D
do you mean to delete all records from a table or multiple tables. if it is to delete all records from a specific table then try using

DELETE * from tablename
sorry. change

delete * from tablename

to

delete from tablename
Avatar of dougf1r
dougf1r

ASKER

sorry. change

delete * from tablename

to

delete from tablename

Where should this piece of code be placed?