How do you generate a Autonumber function without the datatype one in ACCESS?

[ketanlad]

Hi,

I am trying to generate a autonumber function in access without using the Autonumber datatype field. I have limited knowledge of access and I have been advised by looking on the web that I need to use something similar to:

Nz(DMax("val([PalletNo])", "PRODUCTION") + 1)

Where do i put this code? Can any give me steps plz?

Thanks

[ollyb303]

Hi,

I think your question has already been answered on this forum. Try these threads:

Auto Increment and Reset Number Sequence in a Table
Generate Autonumber in Textfield On Form of Access

Good luck :)

[missinglinq]

It goes in the code window behind your form. In the Form's Design View, on the menu goto View - Code then paste this in, being sure to erase any line numbers that get pasted as well.

Private Sub Form_Load()
If Me.NewRecord Then
   Nz(DMax("val([PalletNo])", "PRODUCTION") + 1)
End If
End Sub
 

This way the new number is only generated if the record is a new record. Existing records are ignored.

Welcome to TheScripts!

Linq ;0)>