Start at

I am doing an inventory Database and I need my product id number to start at
1 but it has started off at 8. I messed up on it due to wrong info so I
started over and it picked up where I left off.

Why do you need the product id number to start at 1? You should never attach
any significance to the value of an Autonumber field. If its value matters
to you, you probably shouldn't be using an Autonumber field.

The only purpose of an Autonumber field is to provide a (practically
guaranteed) unique value that can be used as a Primary Key. 8, 10, 11, 12
serves that purpose just as well as 1, 2, 3, 4 does.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"IfeelSilly" wrote in message
...
I am doing an inventory Database and I need my product id number to start
at
1 but it has started off at 8. I messed up on it due to wrong info so I
started over and it picked up where I left off.

Empty your table then do a compact and repair. It should reset the seed.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"IfeelSilly" wrote:

I am doing an inventory Database and I need my product id number to start at
1 but it has started off at 8. I messed up on it due to wrong info so I
started over and it picked up where I left off.

As Doug has pointed out, if the values are significant an autonumber is not a
suitable solution. If you really do need to maintain sequential values the
only reliable way is to compute the values when a record is inserted via a
form. Roger Carlson has an example which also prevents conflicts in a multi-
user environment at:

http://www.rogersaccesslibrary.com/f...19 89c53d7ffb


and there's a slightly more complex one of mine, which additionally allows
the next number to be used to be 'seeded' at:

http://community.netscape.com/n/pfx/...g=ws-msdevapps


Ken Sheridan
Stafford, England

IfeelSilly wrote:
I am doing an inventory Database and I need my product id number to start at
1 but it has started off at 8. I messed up on it due to wrong info so I
started over and it picked up where I left off.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200909/1

If all you have is a TblProducts and you have not entered any data yet that
uses ProductID as a foreign key, then open TblProduct in design view. Delete
the field ProductID. Then reenter the field ProductID. ProductID will start
at 1 and be sequential for all the products in TblProduct.

Steve



"IfeelSilly" wrote in message
...
I am doing an inventory Database and I need my product id number to start
at
1 but it has started off at 8. I messed up on it due to wrong info so I
started over and it picked up where I left off.

"Steve" schreef in bericht
m...
If all you have is a TblProducts and you have not entered any data yet that uses
ProductID as a foreign key, then open TblProduct in design view. Delete the field
ProductID. Then reenter the field ProductID. ProductID will start at 1 and be sequential
for all the products in TblProduct.

Steve




--
Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 10.000 pageloads... it's
a shame !!)


For those who don't 'agree' with this mail , because $teve was 'helpfull' with his post...
We warned him a thousand times... Sad, but he is not willing to stop advertising...

He is just toying with these groups... advertising like hell... on and on... for years...
oh yes... and sometimes he answers questions... indeed...
and sometimes good souls here give him credit for that...

== We are totally 'finished' with $teve now...
== Killfile 'StopThisAdvertising' and you won't see these mails....

Arno R