Append Query - Autonumber ERM??

[evilcowstare via AccessMonster.com]

Ok now Im confused, I changed the starting No of my autonumber the other week,
worked fine. I have now added a few more bits to my db and want to do it
again to clear it all ready for use and its not doing it, maybe me??

I am trying to make it start on 4183, so far all I have amaged for it to do
is create a record with 4182 but then the next autonumber goes to 4203 which
is what I was up to when testing, before the next job would just be 4184.

Ok so this is what im doing, maybe someone can see If i missed anything out.
I deleted all the records in my table
I created a table with one number field (table1), I named it Job Number which
is the field name that I am trying to change in my main table.
I did a new query, it shows one box for "Table1". I clicked append and
selected the main table name which contains the original job number i am
trying to change.
In the grid below the box it shows....

Field: Job Number
Table: Table1
Append To:Main Table

I save it and then double click the query to run it, it says you are about to
change etc etc etc

I go to the main table it shows one entry with a number of 4182.

I open the form and can put info into 4182, I go to new record and it goes
straight to 4203. It still seems to remember where it left off?

Any ideas what Im forgetting to do???

Thank You !!!!!!!!!!!!!!!!!!!

 

[Allen Browne]

It should work if you delete all records from the table, then compact, then
set it to 4182.

Here's a couple of other ways to set the autonumber value:
http://allenbrowne.com/func-DDL.html#AdjustAutoNum
http://allenbrowne.com/func-ADOX.html#ResetSeed

 

[evilcowstare via AccessMonster.com]

Hi Allen,
realised from what you wrote I never compacted it after deletion, works fine
now!
Thanks very much !!!

It should work if you delete all records from the table, then compact, then
set it to 4182.

Here's a couple of other ways to set the autonumber value:
http://allenbrowne.com/func-DDL.html#AdjustAutoNum
http://allenbrowne.com/func-ADOX.html#ResetSeed

Ok now Im confused, I changed the starting No of my autonumber the other
week,

[quoted text clipped - 34 lines]

Thank You !!!!!!!!!!!!!!!!!!!