VB MS Access - How to delete all RS in tbl

"DELETE FROM TABLE"

No fields / '*' required.

Chris.


"Jezebel" <dwarves.DeleteThis@heaven.com.kr> wrote in message news:OadAbd2REHA.2976@TK2MSFTNGP10.phx.gbl...
Use an SQL statement: DELETE * FROM MyTable;


"mt" <tsaim.DeleteThis@mft.com> wrote in message
news:%23ZmdoL2REHA.1312@TK2MSFTNGP12.phx.gbl...
 > What command syntax to use to delete all the data in a table ?
 > Not delete the table itself.
 >
 > The only way I know of is to loop thru the entire table RS count
 > and do RS.DELETE in each of the loop.
 >
 > What is a better way to do that ?
 >
 > Thanks in advance.
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: VB MS Access - How to delete all RS in tbl 

mt wrote:

 >What command syntax to use to delete all the data in a table ?
 >Not delete the table itself.
 >
 >The only way I know of is to loop thru the entire table RS count
 >and do RS.DELETE in each of the loop.
 >
 >What is a better way to do that ?
 >
 >Thanks in advance.
 >
 >
 >
 >


Dim dbs As Database

Set dbs = CurrentDb
dbs.Execute "DELETE * FROM SomeTable;"

Ron

--
Ronald W. Roberts
Roberts Communication
rwr_at_robcom_dot_com.RemoveThis@robcom.com
To reply remove "_at_robcom_dot_com"<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: VB MS Access - How to delete all RS in tbl