Replace multiple lines in a table

[N1ck9141]

Situations - i ahve a large LAST names database i want to changed all the "CURRENTS" to "NEW" casue they got married lol...

is there something i can add to the critia box so that, it gives me two pops up firstly

"enter current name"
so i type "CURRENTS" and it shows me them all

then a second that says

"enter new name"
so i type "NEW" and it changes them all for me

but keeps the rest of the data in the record the same like first names for example

thank you

 

[maxmangion]

Hi,

As already suggested in another thread you can do that with an update query.

In the query put the current data in the criteria row and put the new data in the Update to row. When you run the query the data will be updated.

 

[N1ck9141]

not right

this does work and i thank you however it requires me to change the query every time i want to update something else is there anyway to set those to different every time like with pop up boxes for example, so its asked for the critiera and then asked what to change it to etc...

 

[maxmangion]

well you can do that a form level. Use textboxes to accept the data and then in the query reference the controls of the forms i.e. [Forms]![frmName]![ControlName]

 

[N1ck9141]

help

i have no idea what you just said lol...

sorry im quite a newbie could u explain a little deeper than that i would be very greatful thanks for the help so far

 

[maxmangion]

create a form and have two unbound textboxes one for the current data and another for the new data you want to update. Eventually, placed the references of these controls in your query criteria and update to fields i.e. [Forms]![FormName]![TextboxName].

Once you have this setup place a button on the form which runs the query.

 

[N1ck9141]

still not working

this still didnt have the desiged affect either im doing it wrong ( which is likely ) but it jst gives errors of it not working however i do like the theory is there anything else you can advise or like a step by step on how to do incase i am doing it wrong thanks

 

[N1ck9141]

yippy

Ignore me i was being stupid i got it workign i made a major stupid error and configured the critias the wrong way round lol it now works perfectly just like i wanted thank you very much u ahve been a great help

 

[maxmangion]

you're welcome, i'm glad that you managed to sorted out