Here is an example of how you would use recordnumber in string concatentation:
"Entry#" + CStr(recordnumber, 0)
You will have to figure out how to get those zeroes on the left of the number.
Two options off the top of my head:
1: figure out how many digits there are in recordnumber and then say
"yourStr" + numZeroes + recordNum.
Requires some calculations, but it shouldn't be too difficult since they are 3 digits maximum.
2: figure out how to pad the number (in string format) with zeroes, then join it to "YourStr"
EDIT: on second thought, the two ideas are pretty much the same thing.
Edited by Keikoku - 27 Jun 2011 at 3:11am
IP Logged
