changing autonumber initial value

  • Thread starter Thread starter Brad Reichert
  • Start date Start date
B

Brad Reichert

I'm got a table with an autonumber field. There is a 1-1 relationship
between that field and a field with the same name in another table. The
initial value is 1 but I'd like to change it to 10000. How do I do that?

Thanks,

Brad
 
Have Autonumber field start from a value different from 1
http://www.mvps.org/access/tables/tbl0005.htm

MVPS.org has some good information. Besides this one page, I would suggest
browsing around.

Additionally, FMS has some whitepapers on VBA coding that are also helpful.
http://www.fmsinc.com/tpapers/index.html

HTH


--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
The autonumber I want to change is called EquipmentID and is the primary key
in the Building/Room table. It is related to other tables. I created a
table called table1 with 9999 was the value in the EquipmentID field( the
only field). I then created a query with field EquipmentID in table 1 in 1
column and EquipmentID, Building/Room as the table, and Equipment ID as the
Append to in the other column. I ran the query and nothing happened. What
did I do wrong?

Thanks,

Brad
 
Back
Top