Delete all records in a table?

bob646 · #1 04-25-2007, 09:38 PM

I want to place code in a click event to delete all records in a table but keep the table for new records. DELETE * FROM Employees WHERE Title = 'Trainee'; seems to have trouble with the asterisk.

gary84 · #2 05-20-2007, 09:41 PM

Dim db As dao.Database
Set db = CurrentDb()
db.Execute "Delete * From [" & TableName & "]"
Set db = Nothing

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Macro to delete all rows from a table on close	Jallen17	Access	0	08-25-2008 10:17 AM
Inserting multiple records into a table	New2Access	Programming	0	02-18-2007 09:46 PM
Creating a string from all records in a table	ocordero	Programming	2	08-07-2006 07:21 AM
Selecting and modifying records in a table	Ed H	Access	1	03-17-2006 09:04 AM
Delete query, deleting customers froma table.	keithsrobinson	Queries	2	02-14-2006 08:33 AM