R
Richard
how do I change the starting value for an autonumber field in access 2007
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Krzysztof Pozorek [MVP]
(...)
DoCmd.RunSQL "alter table Table1 alter column ID counter(X,1)"
X - starting value
K.P.
how do I change the starting value for an autonumber field in access 2007
DoCmd.RunSQL "alter table Table1 alter column ID counter(X,1)"
X - starting value
K.P.
R
Richard
Richard said:how do I change the starting value for an autonumber field in access 2007
R
Rodrigo
How exactly do I do that? Where do I enter that line? Sorry for my ignorance!
K
Krzysztof Pozorek [MVP]
You may use it in a query:
alter table Table1 alter column ID counter(1,1)
or in VBA code (module, immediate window):
DoCmd.RunSQL "alter table Table1 alter column ID counter(1,1)"
K.P. MVP, Poland
www.access.vis.pl
(...)
alter table Table1 alter column ID counter(1,1)
or in VBA code (module, immediate window):
DoCmd.RunSQL "alter table Table1 alter column ID counter(1,1)"
K.P. MVP, Poland
www.access.vis.pl
(...)
C
courtial line
Richard said:how do I change the starting value for an autonumber field in access 2007