Need Help Creating an Autogen Number

  • Thread starter Thread starter David B
  • Start date Start date
D

David B

I am trying to automate a process that assigns a credit
number to a record dependant on a criteria. If a user
inputs data into a particular text box, then the "credit
#" will assign a value (with text, ie "S-1111") that is
incremental from the previous value assigned (which may or
may not be the previous record). I am also already using
an autogen number for my record ID in this table. Can
someone help me with advice on how I should proceed?
 
David B said:
I am trying to automate a process that assigns a credit
number to a record dependant on a criteria. If a user
inputs data into a particular text box, then the "credit
#" will assign a value (with text, ie "S-1111") that is
incremental from the previous value assigned (which may or
may not be the previous record). I am also already using
an autogen number for my record ID in this table. Can
someone help me with advice on how I should proceed?
Click to expand...

Have a look at the sample database at:

http://www.datastrat.com/Download/AlphaNumeric2K.zip

While not exactly what you are looking for, the increment code should give
you an idea on how to write your own.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top