Recent content by Louiscande

Hello, I have been a member for quite some times, but took a long furlong. I'm mostly a Microsoft Access buff and trying to learn VB (basic) Looking forward on hearing all you. Until we meet, take care. Louis

Because my report have different "ItemCode"s (text) and "days old" (numeric), I can't I'm use the conditional formattting option in Access; this only give me three colors, four with the first (if none of the others applies then use this one). I want to create an option where I can more than 4...

I 'm sorry. :confused: The correct post is: In this field shows the following for one record: 203:3~204:7 Which mean: In location 203 a qty 3 of an item and the same item is in location 204 qty 7. I want to break that field at the "~" and have two records with the two different locations...

Hi there, I have a database that has field "location". In this field shows the following for one record: 203:4~204:7 Which mean: In location 203 a qty 3 of an item and the same item is in location 204 qty 7. I want to break that field at the "~" and have two records with the two different...