moving recorc from one table to another

[Tuyizere]

I Need To Move a Record
from one Table in a
Database To another Table
I am using ado in vb 6.0 plz help me!

[Reverend Jim]

You didn't provide the table structures so I'll assume the tables have the same structure. I have no idea how much detail you need so I'll start with a little and you can ask for more as you need. If you have an ADODB.Connection object named con then you can move the record in two steps. Step 1 will copy the record and step 2 will delete the record from the source table. Because you have provided no details I can give only an example.

con.Execute("INSERT INTO Table2 SELECT * FROM Table1 WHERE SomeField = 'Some Value'")
con.Execute("DELETE FROM Table1 WHERE SomeField = 'Some Value'")

[Reverend Jim]

Of course, you should do error checking at each step to ensure that you don't delete the record if it fails to insert into Table2.

[Aslam Mansoor]

What I suggest is, firstly call the records from the First Table that you need to transfer on to a VB Form on to Text boxes or a ListView.Then save those records in the table you require. Then write the Deleting Codes on to the same Button Following the Saving Codes, to be executed from the previous table.

[kgariando]

Just go into Access and create a query. Make sure that it works. Then plug the result into VB6. For how to create a query