Auto Number

[Parra]

I would like to have the auto number or "something" like it, but I would like it to start from a higher number other than 1.

Something like 100000 and then every increment would grow by 150.

100000
100150
100300
100450
100600
100750
100900
101050
101200

Any Suggetions?
Thank Parra

 

[SydneyGeek]

The ID field needs to be Number, not Autonumber (make it a Long Integer). Try this:

(1) Build a query that returns Max([MyFancyID]). The query field will be called LastValue.
(2) NextValue is a calc that increments LastValue by, say, 150.

Then you'll need some code that goes to [MyFancyID] and inserts the value for you.

Sub Form_Current()
If .NewRecord then
DoCmd.GoToControl("MyFancyID")
[MyFancyID]=[MyIncrementQuery]![NextValue]
End If

You may need to disable the control after saving the record, so nobody can play with the numbers.

 

[bat17]

Autonumber ID's are really only for use within the database and not for things like invoice numbers as you can "Lose" numbers if someone cancels a dataentry once started.

To display your number you could just calculate it from a standard Autonumber:-
100000 + (Autonumber * 150)

HTH

Peter