How to ADD 1 to start number down a column ??

[Head Freeze]

Hello all.

I need a little help please.
I was able to do this back in 2000 but have forgotten how I did it.

I am running Access 2010 database for customers that we deliver to every week.
Customer name
Address
Date
Docket Number
etc, etc.

First customer may get docket number 195226
second one gets 195227.and so on. (previous number plus 1)
I am entering these docket numbers manually all the way don the column and it's wasting time.



How am I able to get Access to enter the next number automatically each time I hit Enter or the down arrow please ?

[ssanfu]

Maybe use the Form current event.

Private Sub Form_Current()
    If Me.NewRecord Then
        Me.DocketNumber = DMax("DocketNumber", "YourTableName") + 1  '<<< change YourTableName to the name of the table that holds DocketNumber
    End If
End Sub

For the control, you might consider setting the Enabled property to False and the Locked property to TRUE.


BTW, DON'T use spaces in object names.
"Date" is a reserved word in Access and, by itself, not very descriptive. "Date" of What???? Birth date? Date of entry??

[June7]

Generating a custom unique identifier is a common topic. Here is one https://www.accessforums.net/showthread.php?t=23329