i need to use a MACRO or VBA PLEASE HELP!!!

[Firespawn]

hello
i have i database. And now I want to run an macro.I have 7 columns and now I want to FIND AND REPLACE all the "ch** (". Is there a method to do this THANKs alot

maybe somebody has already i MACRO or VBA done it would be very cool THANKS ALOT !!

( the VBA is only suppost to find it in the 7 coumns !! )

THX

if you have more question let me know thX ALOT !

 

[dirkg]

do you mean find and replace in the records of your table or the field names or...???

 

[Junior1544]

how would you feel about sql? i may be able to help you there, i've done it once with help with sql, and can help you with that...

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[Firespawn]

THE SQL stuff would be cool THX !!!

yeah i mean it is a FIND REPLACE FUNCTION !!!

THANKS alot !!!

 

[Junior1544]

ok, make a select query that will only find the records you want to be updated... run it to make sure...

turn it into an update query, and put this in the update to part...

Mid([REMARKS],1,Len([REMARKS]))

my field name is REMARKS, that's why that's in there... change that to whatever your field name is...

the way that is will take out 2 char's i think...

change the 1 to a 2 and it'll take out 3 i think...

just make sure to make a backup of your data befor doing this...

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[Junior1544]

one thing i forgot to tell you...

when i say put it in the update part... i mean of the field you want to remove the first two char's off of...


--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[Firespawn]

hello and thank u

maybe u can help a little bit more! and show me how to make an update query thanka alot ~

 

[Junior1544]

have you made the select query that just finds the records that will want to change??
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[bustell]

Read FAQ faq705-1824 for a function that does a replace, this will help you with your update query.
Pat B

 

[Junior1544]

Thanks Bustel...
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[Guest_imported]

i have no clue how to do that

thanks alot !