Search results

It won't reach Z, the maximum noOfClaims in normal cases could be 10 (could reach J) as the users claimed Therefore when the function gets noOfClaims > 1 it should automatically start incrementing the letter field in the table, which the current code doesn't do

The Auto number field is sufficient in case of noOfClaims = 1 the concatenating works perfectly as well but the last part of the function where it should increment the letter field is not working the code below doesn't increment the letter field in my table as it should have the following...

This function is supposed to auto generate an alphanumeric primary key. My form is named F_Claim and has a textbox named noOfClaims that determines the number of keys to be generated. In case of noOfClaims = 1 the format of the key would be as follows ("CLM/GC/0001/2010") While in case of...