Automatically Add Next Number

SP76

Registered User.
Local time
Today, 17:44
Joined
Apr 18, 2008
Messages
19
I have a text box, in the box I manually add the next available number for example: 02

Is it possible to have something set up to automatically add the next available number?

:confused:
 
Perhaps some greater detail would help. When/how would you like the number incremented?
 
I have a text box, in the box I manually add the next available number for example: 02

Is it possible to have something set up to automatically add the next available number?

:confused:

Would an autonumber work in this case? Or do you need to start from a particular number?
 
I wouldn't use an autonumber for something that needs to be in incremental order always. Autonumbers are really only good for getting a UNIQUE number and not much else because of the possiblity that they will slide into random mode or you lose one when you start a record and then cancel, etc.

I would look into the DMax + 1 method here. And, there was just a post yesterday (I'll see if I can find it) where Paul (pbaldy) had responded about this and suggested the single record in a table method of this to keep users from colliding.
 
Perhaps some greater detail would help. When/how would you like the number incremented?

The numbering would start at 01 and I want it to go up in ones every times a new document to add is selected.

01, 02, 03, 04 etc
 
Looku up the DMax function (+1) it's the easiest though not necc. the best way
 
The numbering would start at 01 and I want it to go up in ones every times a new document to add is selected.

01, 02, 03, 04 etc

It will be 1, 2, 3, 4 and you can FORMAT it any way you like, so you can format to see 01, 02, 03, 04 (but with the leading zeros it will be text and not numbers).
 

Users who are viewing this thread

Back
Top Bottom