Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete all records in table during run time

Status
Not open for further replies.
Frank72

Frank72

Technical User
Nov 13, 2001
57
IE
Hows it going

Is there a method or command that will delete all records in one go or would I have to use the .delete method in a loop?

many thanks

Frank
 
Sort by date Sort by votes
Ummmm......

How about CurrentDB.Execute "DELETE * FROM YourTable"?

Craig
 
Upvote 0 Downvote
or if it's an Excel table:
'*****************************************************************

Rows(Cells(2, 1).Row & ":" & Selection.SpecialCells(xlLastCell).Row).Delete Shift:=xlUp
Cells(2, 1).Select

ide
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EliseFreedman
  • Locked
  • Question
booking tool - all day time slots
Replies
3
Views
254
Andrzejek
Andrzejek
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
548
remeng
remeng
remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
246
remeng
remeng
morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
565
morechocolate
morechocolate
MattGreer
  • Locked
  • Question
Delete a Table Row in a Filtered Table 2
Replies
11
Views
418
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top