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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Clearing an Access table from Visual Basic 1
- Thread starter JasonV
- Start date
Here is one way I have used to clear an Access table:<br>
With [variable name of table here]<br>
If Not (.EOF And .BOF) Then .MoveFirst<br>
Do Until .EOF<br>
.Delete<br>
.MoveNext<br>
Loop<br>
End With<br>
<br>
Hope that helps!<br>
kleo<br>
<br>
kleo9@hotmail.com<br>
With [variable name of table here]<br>
If Not (.EOF And .BOF) Then .MoveFirst<br>
Do Until .EOF<br>
.Delete<br>
.MoveNext<br>
Loop<br>
End With<br>
<br>
Hope that helps!<br>
kleo<br>
<br>
kleo9@hotmail.com<br>
-
1
- #3
you could also do this with an sql statement:<br>
<br>
<br>
myDB.execute ("delete * from mytable;")<br>
<br>
where myDB has been properly opened using<br>
<br>
set myDB = dbengine.workspaces(0).opendatabase("c:\mydata.mdb") substitute your own path<br>
<br>
quick easy and fast<br>
<br>
<br>
<br>
<br>
myDB.execute ("delete * from mytable;")<br>
<br>
where myDB has been properly opened using<br>
<br>
set myDB = dbengine.workspaces(0).opendatabase("c:\mydata.mdb") substitute your own path<br>
<br>
quick easy and fast<br>
<br>
<br>
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
