自动编号-指定起点 [英] Autonumber - specify starting point

问题描述

MS Access 2007

MS Access 2007

我正在尝试将AutoNumber设置为5,000，并为每个条目将其增加9.有什么办法吗?它不一定必须与AutoNumber一起使用，如果Access中有另一种方法可以做到这一点，那也很好.请帮忙.

I'm trying to start AutoNumber at 5,000 and increase it by 9 for each entry. Is there any way to do this? It doesn't have to be with AutoNumber, if there is another way in Access to do this, that would be great too. Please help.

推荐答案

您可以在ADO下使用DDL来设置自动编号种子和增量. (但是，呼应@ mwolfe02的评论……为什么?)

You can use DDL under ADO to set the autonumber seed and increment. (However, echoing @mwolfe02's comment ... why?)

Dim strSql as String
strSql = "ALTER TABLE YourTable ALTER COLUMN YourAutoNumberColumn COUNTER(5000, 9)"
CurrentProject.Connection.Execute strSql

还请参见前面的堆栈溢出问题是否对您有用:如何重置自动编号种子-MS Access/VB6

Also see if this previous Stack Overflow question is useful to you: How to reset autonumber seed - MS Access/VB6

这篇关于自动编号-指定起点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！