Search results

i will see you then . Thanks alot besides whether the code is gonna work or not . Genuinely , thanks

Hey VBAinet. One more thing is that i will be leaving now but i will be online in 2hours. So Would you be available then ?

Yes you are right rate is a number and region is a string . i forgot to make you awarre of that . apologies.

when i changed "and" to "or" . the counter is storing all 1's in it.

HI VbaInet . Thank YOu first of all for sending it. It is working partly. The code worked fine and it is working based on the region actually. Like in this case , the region is 01 for all the three records, ID is also 1 and CIN is also the same Condition worked with...

Existing records in the table.

In the below provided table, Counter will contain nothing. I need to populate that field with incremental number by using code. In the First 2 rows, there is change in the rate column but keeping all the fields same. So For the Region =01 with CIN=XX12345X , ID =1 has two records 9222,9223 ...

Hi Rate and COunter are both separate fields . I need the counter field to be incremented based on CIN, Region,ID and Rate.

Thanks a lot for responding in such short time . I need one more help which is a bit complicated. I need the same thing to be incremented but now based on four fields actually ( Region, CIN, ID , Rate) .See in the bolded data, with region and cin changing , the increment should be unique ...

Hi , I got a table with all the records in it. I have four fields specifically, Region (which stores numbers n like 01, 02, 03) and ID( format is XX00000X) , Id ( which has values starting from 1) and rate ( vlaue such as 9223,9224,9225). i need a counter based on the above specified fields...

Hi, THere are seven tables linked to each other by primary key. I have an Unbound form with an one unbound textbox and one bound textbox , users enter values in the unbound Textbox so . the Values entered in the unbound textbox should be added to all the seven tables . I used this code...