how to delete the records?

[itoxic07]

how to delete the records ?

i am having problem deleting the records including the duplicate records from access database.
I inserted a textbox on a form ,the name written in a textbox must be deleted
including duplicate names from database

[hariharanmca]

how to delete the records ?

i am having problem deleting the records including the duplicate records from access database.
I inserted a textbox on a form ,the name written in a textbox must be deleted
including duplicate names from database

just exeecute the query

strsql = "Delete * from tblTableName Where txtFieldname like '" & trim(txtDeleteN ame.Text) & "'"

[slapshock]

dim rs as new adodb.recordset
rs.open "Delete * from tblTableName Where txtFieldname like '" & trim(txtDeleteN ame.Text) & "'"

try this code, hope it will help

happy coding

[fplesco]

dim rs as new adodb.recordset
rs.open "Delete * from tblTableName Where txtFieldname like '" & trim(txtDeleteN ame.Text) & "'"

try this code, hope it will help

happy coding

Hey guys -

What are you trying to do with txtFieldname? It must a textbox object right? Not a field name. Are you trying to pass a FIELD/ COLUMN name into this query?

It should look like this.

"Delete * from tblTableName Where " & txtFieldname & " like '" & trim(txtDeleteName.Text) & "'"

Or just a specific fieldname like

"Delete * from tblTableName Where Lastname like '" & trim(txtDeleteName.Text) & "'"

Note: In MS SQL Server backend, DELETE command DOES NOT NEED an *. For example: DELETE FROM <table name> WHERE <field/column name> [= / LIKE] <value>