This code work perfectly well to change all the first character from DB to W. The problem is, I have one more data that I don't want to change the first character.
Tried stackoverflow's solution but can't get it work (Cannot give link due to new comer). Any idea to solve my problem?:banghead:
My code can change all first letters to W, but i dont want to change the NYB123 to WYB123, i want that data untouched. i managed to change the first letter to W, so i think the code perfectly working.
So, the end result should be like this:
What i want to change is data number 1 & 2, change only the first letter from E & S to W. What i dont want to change is data number 3. So the end result should be:
1. E1234 -> W1234
2. S1234 -> W1234
3. NYB123
What my code do here is, it change all the first letter to W.
The screenshot is what i'm trying to follow.
Screenshot is the result of my code. POE Item is the original name of the data, the ERPCODE is the changed name. So what I want to do here is, any POE Item name start with E-* and S-* change to W-*, any name start with NYB* should not be touched or remove, leave the ERPCODE as POE Item. The code start from Mid to closing bracket is not touching after the first character.
The rules for this are:
1. Shows every available data.
2. Change first letter of the data form E-* and S-* to W-*.
3. Shows data start with N but not change the first letter.
I'm sorry if my explanation this time still confusing you all. I'm not good explaining problems and this is the first time I'm exploring MS Access.