I have a userform that I use to enter data for Calls to fix faults.
Once the form is filled and submit is pressed, I want a Call reference number to be generated. This call reference number is a 6 digit number starting 100001 onwards.
Once generated, it should store this number in the database. (i hv a column named Call_Ref_No for it)
Can someone please help?
Cheers
PJ
Once the form is filled and submit is pressed, I want a Call reference number to be generated. This call reference number is a 6 digit number starting 100001 onwards.
Once generated, it should store this number in the database. (i hv a column named Call_Ref_No for it)
Can someone please help?
Cheers
PJ