• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• These are queries that are Add a New Record, Update and Existing Record and to Delete a Specific re

These are queries that are Add a New Record, Update and Existing Record and to Delete a Specific re

These are queries that are Add a New Record, Update and Existing Record and to Delete a Specific record

Rate These are queries that are Add a New Record, Update and Existing Record and to Delete a Specific re

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

Set Rs = Db.Execute("Insert into Company (Cname,Loc) values ('" & Text1 & "','"& Text2 &"')")

'To Delete a Specific Record
Set Rs=Db.Execute("Delete from Company where Cname='"& Text1 &"'")

'To Update a Record
Set Rs = Conn.Execute("Update Company set  Cname='" & TxtCode & "',Loc='" & TxtName & "' where Cname = '" & Text1 & "'")