deagon
Posts: 31
|
Posted: 07/28/2009, 9:36 AM |
|
I have setup automatic job numbering by adding one to the last job number, it works great.
If Jobstorage20.JobNumAdd1.Value <> "" Then
Jobstorage20.JobNumAdd1.Value = Jobstorage20.JobNumAdd1.Value
Else Jobstorage20.JobNumAdd1.Value = CCDLookup("Max(Jobnum)","Jobstorage","",Conn) + 1
End if
Because we have started adding alpha numerical numbering instead of just numbers it errors out when a alpha numerical number is used. Example 3012.i instead of 3012. This clearly is a issue with adding a number one to a number with characters. Is there a way to change the code so that it adds a number 1 to the last number used but disregards the letter i or r?
Thanks for the help.
|
|
|
|