Generating Order Numbers

[Nick Bradbury]

Hi

I want Access to automatically assign an incremented Order No each time a
new record is entered, I am currently using AutoNumber but ideally I want to
move away from this. Does a function exist in vba for this task.

Thanks

Nick

 

[BruceM]

One way of doing this (using default value rather than VBA) is here:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb
It includes a method of implementing the method in a multi-user environment.

 

[Keith Wilby]

Hi

I want Access to automatically assign an incremented Order No each time a
new record is entered, I am currently using AutoNumber but ideally I want
to move away from this. Does a function exist in vba for this task.

No code needed. Just set this as your text box's default value:

Nz(DMax("MyField", "qryMyQuery")) + 1

Regards,
Keith.
www.keithwilby.com

 

[Nick Bradbury]

Thanks for you help, problem solved

Nick