How to Delete all records in a table using ADO 1

[gohym]

Hi,

I have a table, "Temp", that contains some temporary information; it has only 1 field called "CSIID" . The CSIID is shown on a form and I want all the table's records to be deleted, once the form closes... preferably not using DAO...

Can someone please provide some guidance... time is pretty tight... need all the help I can get... Thanks!!

 

[mgolla]

On Close of form run this code:

Dim stQuery As String

stQuery = "DELETE * FROM Temp"

DoCmd.SetWarnings False
DoCmd.RunSQL stQuery
DoCmd.SetWarnings True

HTH
Mike

 

[gohym]

Hi Mike,

Let me give it a try and get back to you... Thanks!

 

[gohym]

It's working!!

Thanks!