Recent content by ppetrol

Re: How can I copy a record from a table to another table? succeeded, thanks everyone. Dim strSQL As String strSQL = "INSERT INTO [TblAUDIO2] ([Artiest],[Titel],[TIPHIT],[Rel_dat],[COMPONIST],[LAND],[LABEL],[HOELANG]) SELECT...

artiest Titel SRT NUMMER TRACKNO Rel_dat TIPHIT COMPONIST LAND LABEL HOELANG Toto Rosanna SIN 4384 1 24-4-1982 H NL 05:27 copy this record without SRT NUMBER TRACKNO I fill this manually because they do not match my private collection artiest Titel SRT NUMMER TRACKNO Rel_dat TIPHIT...

no sorry the record gets a new [ID] number SRT NUMBER TRACKNO thanks for your response, i hope you have a solution.

Hello grandfather congratulations, I have to copy because the vinyl record gets a different number Me.SRT = "A" Me.NUMBER = "" Me.TRACKNO = "" as in the source table to look up in my record rack. hopefully you can help me. Greetings from the Netherlands

dear Plog. in table TblAudio1 all music is ever made. to save a lot of typing I want to extract the data for my private collection. including the genre. thank you for your sugestion but it's no use to me.

How can I copy a record from a table to another table? I have 2 tables (TblAudio1 and TblAudio2) TblAudio1 is the main table with all records. TblAudio2 is an empty table that must be filled with a number of fields from TblAudio1 if I want to copy a number of fields from TblAudio1 to...

I have 2 tables (let's call them FrmAudio1 and FrmAudio2) FrmAudio1 is the main table with all neccessary files. FrmAudio2 is a new table with new audio files. If I want to add a file that exists in FrmAudio1 to FrmAudio2 (with the same structure ofcourse) how would I have to do that? The...

DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdPasteAppend Hello, Is it posible to save the record in another table?