[Resolvido]passar esses registros de uma tabela para outra (pass those records from one table to another)

passar esses registros de uma tabela para outra, a idéia é reciclar garde bin eu apaguei registros no lixo antes de retirar completamente. em seguida, passar alguns campos câmaras para outra mesa ou forma como o trabalho cego em formas, e se eu quiser restaurá-lo de volta para passar a mesa era. obrigado antecipadamente.

Hi Zeus

The translation was not good. Write in English that will be easier to understand.

ok if I have two tables and I think everyone forms but one I will serve as papeliria recycling, as step one record to another table then if I want. it happened again where it was in the original table in advance many thanks

no se si me entiendan pero traduci lo que dije creo que tampoco van a enterner talvez en español si, que es algo igual al portugues, tengo dos tablas con sus dos formularios
uno me servira como papeleria de reciclaje , como hago para pasar los registro a la otra tabla , y cuando quiera regreso ese mismo registro a donde pertenecia ? mil gracias

Hi Miguel! Well, Spanish is not so similar to Portuguese. I am Brazilian and I find it more easier to understand English than Spanish.

You want to transfer data from one table to another, right? You may use the object "Recordset". Let´s suppose the two tables are named tbl1 and tbl2 respectively. Let´s suppose both them have the same field names. In my example I will name them fld1, fld2 and fld3. Because of you have two tables, let´s use two "Recordsets":

Código:

Dim myTable1 As Recordset, myTable2 As Recordset

Set myTable1 = CurrentDb.OpenRecordset("SELECT * FROM tbl1 WHERE IDField=" & Me.IDField & "")
Set myTable2 = CurrentDb.OpenRecordset("tbl2")

tbl2.AddNew

tbl2!fld1 = tbl1!fld1
tbl2!fld2 = tbl1!fld2
tbl2!fld3 = tbl1!fld3

tbl2.Update

tbl2.Close
Set tbl2 = Nothing

tbl1.Close
Set tbl1 = Nothing

In this case, I am supposing you have a field in a form where you would enter the ID of the record you want to transfer. Once I don´t know how you modelled your database, I can´t be more specific but I think the block of code above may help you anyway.

if I want to move the record in the table 1 to table 2, since the two tables have the same one that is empty which is Table 2, and this is the table that I serve as recycling stationery like windows when want to restore the back, so that whenever in Table 2 retake this same record to table1, but too much to ask can I make file example. Thanks for your attention to my problem

thanks for code but I have a doubt field1, field2 field3, is declared or the number of fields and field names in this select
SELECT [Project]. [Id], [Project]. [Id], [Project]. [Nompro] FROM Projects ORDER BY [Project]. [Id];
see if you give me a little example of an Access file I'd appreciate it thanks

sorry but if I worked buenisimo copying code from table 1 to table2 buenisimo, now I wonder when copying unregister the table1, because I have it copied to table2, then serve me again step the same record that is copied in the table1 table2 but here's one thing that will be no problem to pass the table1 again because it is a primary key will not create duplicate numbers? , Put this code to make clear the log that was left in the table1 but I only ejeucta not delete the code you gave me to copy and again thank you for your attention

On Error GoTo Err_BtnBorrar_Click
Exit_BtnBorrar_Click:
Exit Sub

Err_BtnBorrar_Click:
MsgBox Err.Description
Resume Exit_BtnBorrar_Click

You may do the same. Just inverse myTable1 and myTable2 or you may have two combobox named cboOrigin and cboTarget for example. These two combobox may be filled with the names of the tables so you choose the "from path" and the "to path". Or you may have two radio buttons labeled "From table 1 to table 2" and "From table 2 to table 1". Many ways for the same goal.

Hi all;

See this sample, transfer from table1 to table2;

http://dl.dropbox.com/u/771097/ListBox_Table1_to_Table2.rar

ok thanks to all this is how I stay, someone interested in a recycling bin made ​​in access, give them their pincelasos yet but that is a matter whoever wants, but the function is already done, is I thank you once again my respects teachers always learning more with you.


Nota:first eliminate empleoados records recycling then go to the registry will be there disposed of employees, if employees want restaurlo close button and recycling recycling, recycling close, and employees view your record again this restored
Tema resuelto [center]

Thanks for the feedback.

Many thanks