By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,806 Members | 1,327 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,806 IT Pros & Developers. It's quick & easy.

How to create customized sequential numbers

P: 1
Does anyone know how I can create a customized sequential number? For example: CP-001, CP-002, CP-003

What I need is for access to automatically create the consecutive number for each new record.

PLEASE HELP!

Thanks!
May 31 '07 #1
Share this Question
Share on Google+
1 Reply

ADezii
Expert 5K+
P: 8,750
Does anyone know how I can create a customized sequential number? For example: CP-001, CP-002, CP-003

What I need is for access to automatically create the consecutive number for each new record.

PLEASE HELP!

Thanks!
  1. This line of code will produce the next Sequential Number for the Format you specified:
    Expand|Select|Wrap|Line Numbers
    1. Debug.Print "CP-" & Format$(Val(Right$("CP-002",3)+1),"000")
  2. OUTPUT:
    Expand|Select|Wrap|Line Numbers
    1. CP-003
  3. If you are not sure as to how to incorporate it into your application, let us know.
May 31 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.