TINA - autonumber

[Tina Marie]

Hi ... I've tried setting the autonumber of a field (studentid) back to 1
using the help explanation in microsoft ... but it does work?

says, change a couple of settings in the original table
then create a temp table with same field as autonumber (but as a number)
then add 1 record to it (in my case 0 since I want it to start at 1)
then run an append query to append that studentid=0 to the main table ...
not working???

 

[Richard]

Tina,

The autonumbers only purpose is to provide a unique number thats it. If you
need a number to progress from 1 2 3 4 5 6 7 and so on, autonumber is not
going to do it. This is a kinda trap we all go through. You could setup a
textbox with some code in the after update event that can handle that nicely.
Autonumber is best left alone unless it goes into the negitive numbers.

HTH
Richard

 

[Tina Marie]

Hi Richard ... I agree ... but I do know it can be done ... because I've done
it ... I must be missing a step or something ... but anyways, the client has
decided it doesn't matter since I told them that when they use the word
document I designed to import data into the database, it generates a random
number anyway ... and its usually really big so the sequence would be thrown
off anyway ... but thanks ... T.