how do I change the starting value for an autonumber field in access 2007
K Krzysztof Pozorek [MVP] Jan 18, 2008 #2 (...) how do I change the starting value for an autonumber field in access 2007 Click to expand... 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 Click to expand... DoCmd.RunSQL "alter table Table1 alter column ID counter(X,1)" X - starting value K.P.
R Richard Jan 18, 2008 #3 Richard said: how do I change the starting value for an autonumber field in access 2007 Click to expand...
Richard said: how do I change the starting value for an autonumber field in access 2007 Click to expand...
R Rodrigo Feb 14, 2008 #4 How exactly do I do that? Where do I enter that line? Sorry for my ignorance!
K Krzysztof Pozorek [MVP] Feb 18, 2008 #5 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 (...)
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 (...)
C courtial line Sep 18, 2008 #6 Richard said: how do I change the starting value for an autonumber field in access 2007 Click to expand...
Richard said: how do I change the starting value for an autonumber field in access 2007 Click to expand...
