Search results

:eek: yey! its now working at last! lol the button Deletes all the 'old' records, and successfully TRANSFERRS them into my 'new' table..! 3months of searching code and getting silly error messages! i must thank you for your help, its much appreciated, you'ved saved me a LOT of time (and...

it is now! it worked for me once there now...but it wont work again??

so should it look like this? Option Compare Database Private Sub cmdDelete_Click() With DoCmd .SetWarnings False .OpenQuery "x" .OpenQuery "xx" .SetWarnings True End With End Sub Private Sub Command28_Click() End Sub this doesnt work...

oh ok thanks! lol i'll try that now!

i tried it but it keeps giving me an error msg..."Ambiguous name detected Command24_Click" whats wrong with this code.. Option Compare Database Private Sub Command24_Click() On Error GoTo Err_Command24_Click Dim stDocName As String stDocName = "x" DoCmd.OpenQuery stDocName...

thats great thanks! it works fine..! can i just ask you another question... in the same button...is it possible to MOVE the records i'm about to delete into a new DIFFERENT table...(say called 'old records') thanks again

ok ive made myself a DELETE query, that should Delete all records in a table that are 'TRUE'.... however i cant add it to a command button in my form...it wont appear in my 'command button wizard' as part of my queries, its not there... any ideas why?:confused: thanks

ok this is my code now... INSERT INTO Table2 ( [Date], Name, [Pastoral Info], Targets, Detention, Finished ) SELECT Table1.Date, Table1.Name, Table1.[Pastoral Info], Table1.Targets, Table1.Detention, Table1.Finished FROM Table1 WHERE (((Table1.Finished)="Yes")) DELETE* FROM Table1 WHERE...

The alternative is to leave the transactions in the table but filter them out with a query. i tried doing this but i could only get it to COPY the records from one table to the other - it didnt DELETE them from the original table , so i had redundant data.. any ideas how the append query...

hiya all! i need some help! i want to make a button on my "Calls" database form, to move all "Finished" calls (calls that have been declared as completed), into a "Finished Calls" table. I have half of it working - i have a button that DELETES all 'Finished' calls. However i now need them to...

ok ill give it a go! lol thanks

cool! however when i put that code in and press the button i get an error msg box saying "runtime error 3010 - Table" already exists" you know whats wrong?

thanks RuralGuy! for example....my database is called 'jkerlin', so my code should be... Dim MySql As String MySql = "SELECT * INTO Table2 " & _ "FROM Table1 " & _ "WHERE Finished='Yes';" jkerlin().Execute MySql, dbFailOnError is this ok? much appreciated!

ok thanks! is it difficult to put this under onw button? how is it done...? thanks again!

do you mean two seperate buttons on a form? like a 'MOVE' button and a 'DELETE' button.... is there NO way of putting these actions together so that they work as the ONE function? thanks

ok... this code does work: SELECT * INTO Table2 FROM Table1 WHERE Finished='Yes'; however i want to add another piece onto this code so that once the records are SELECTED FROM Table1, they are also DELETED FROM Table1. so am i able to add this code into it also?: DELETE * FROM Table1 WHERE...

ok cool.. so is this right for what i wanna do? SELECT * INTO Table2 FROM Table1 WHERE Finished='Yes' DELETE * FROM Table1 WHERE Finished='Yes'; or is this wrong? thanks!

oh ok.. could you guys write out exactly what i should be entering into my SQL PLZ..? incase i mess it up! lol id appreciate it.. thanks!

that code will only delete ALL my records from Table1 which match to YES.. however it will not paste them into Table2...which is what i want to do.. thanks anyway! (or can i put that code AFTER my original code..??)

hiya, im new to this sql scene..! i have an MS Access db containing a few tables of 'calls recorded' and 'finished calls'. (i want to move all 'Finished calls' to a seperate 'Finished Calls' table) anyway, the thing i want to do is to move records from Table1 to Table2, i am able to do this...