How to make auto number start from 2000
-
Hi, Have you noticed for example this article: How to programmatically create an AutoNumber field and set its "New Values" property to Random[^]. Hopefully that gives you a good starting point. However there are very rarely reasons why setting starting point would be meaningful. Typically the value itself is meaningless as long as it's unique.
The need to optimize rises from a bad design.My articles[^]
-
Hi, Have you noticed for example this article: How to programmatically create an AutoNumber field and set its "New Values" property to Random[^]. Hopefully that gives you a good starting point. However there are very rarely reasons why setting starting point would be meaningful. Typically the value itself is meaningless as long as it's unique.
The need to optimize rises from a bad design.My articles[^]
-
Yes, the article covers also database creation etc, but the point is that with a little macro you can modify the properties of your tables columns. I don't have Access at the moment but I would guess that some macro like:
CurrentDb.TableDefs("TableNameGoesHere").Fields("FieldNameOverHere").DefaultValue = "2000"
would be worth trying.
The need to optimize rises from a bad design.My articles[^]