Delete records from a table using DAOs 1

[kennetha]

Hi all,

Is it possible to delete a series of records in a table by DAO by using a query...maybe SQL?
Example:
I want to delete invoice no 12 and all it's records from a table have more invoice numbers

Thanks
Kenneth Agius

 

[PHV]

Have a look at the Execute method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya kennetha . . .

Example SQL method:

[blue]   Dim SQL As String
   
   SQL = "DELETE InvoiceNo " & _
         "FROM [b][i]tablename[/i][/b] " & _
         "WHERE (ClientID=" & Me!InvoiveNo4 & ");"
   DoCmd.RunSQL SQL[/blue]

See Ya! . . . . . .

 

[kennetha]

TheAceMan1,

If the Invoice number is collected from an Edit box example txtinvoiceno who would you modify the SQL code

Thanks
Kenneth

 

[TheAceMan1]

kennetha . . .

[blue]   Dim SQL As String
   
   SQL = "DELETE InvoiceNo " & _
         "FROM tablename " & _
         "WHERE (InvoiceNo=" & [purple][b]Me!InvoiceNo[/b][/purple] & ");"
   DoCmd.RunSQL SQL[/blue]

See Ya! . . . . . .