Search results

Brian I have done this but it is still having the same problems. If you view the attachment i uploaded previously and use the advice you have given me it is still not working

dude try moving record one its moves the date installed into the first name field. something from the location table into the title field and it misses out the last name field totally??!?!? Also the view history doesnt work any more

hmm i did indeed. and it didnt seem to work for me? is there more stuff that i need to do within your example to get it working?

Dude This doesnt work.... It doesnt move any of the data from the location of the employee tables. it only moves data from the date installed thingy And then when it does that the view history link doesnt work?!?!!? I have noramlised the database. It's working fine.. apart from this one...

Right Here is an example of the db Open up assetmainfiltered form Click the move to history button Notice how record 1 moves fine and does exactly what i need it to do apart from a few error messages which dont do anything anyway and are just annoying. Try moving records 2 and 3 Notice...

Dude I sorta get it but not sure it is doing what i need it to do I have a table called assetmain table called location table called employee and a table called asset history I have a form for assetmain which has subforms for location and employee I need code so i can press a button and it...

Example would great if at all possible

dude the problem is not sorted ive been able to do that all allong. what i need is to be able to just copy some of the fields of a record into another table and then delete the same ones from the original table and keep some of them at the same time. for example copy of the id number and...

Cheers for that dude I need mine to be able to copy and move the first and last name fields but keep the ID number in there. Is is possible to specify fields to move and not actual records so you can keep some of the data for that record. Basically Copy certain fields into a new table...

duder here is the vb from the onclick event on the button which runs the macro which first runs the append query then the update query Its comes up with a compile error in the debugger Private Sub Command68_Click() On Error GoTo Err_Command68_Click Dim i As Integer Dim rsOld As...

Its just done with queries, Will look into the code. Are you talking the sql code for the queries or the vb code on the form?

Can you upload it ? I'll take a look at it for you

Dude I will try that out However I decided to get rid of the delete query and use an update query As i didnt want to delete the entire record just some of the fields So i run an append query to copy the fields i need over into the assethistory table Then run a update query which blanks the...

Hey Same thing i was trying to do Have an asset current table Want to move data from the current table into a history table via a form Have created an append query to move the data over Then an update query to delete the data in the original table It doesnt appear to be working though...

Right ok i have this working I am running an append query and an update query The problem i have is Im specifying 7 different filelds to append and update The thing is if one of the fields is blank to start with the whole thing wont work. Each field needs to have an entry in it otherwise it...

Right ok i have this working I am running an append query and an update query The problem i have is Im specifying 7 different filelds to append and update The thing is if one of the fields is blank to start with the whole thing wont work. Each field needs to have an entry in it otherwise it...

i have done that and it says query must have at least one detination field?

Morning I Have done a search but have not found an answer I ran a delete query and specied fields to be deleted from certain records. Instead of deleting the field it trys to delete the entire record. Any ideas how i can get it to just delete fields and not the entire record.?

Brian that is blinding. the example db showed me where i was going wrong. I have a form with two subforms with are all related to the one asset number. What do i put in the query to specify it as a subform rather than the main form?

i have inputted this but now it tries to apend 0 rows.???