TINA - autonumber

  • Thread starter Thread starter Tina Marie
  • Start date Start date
T

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???
 
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
 
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.
 
Back
Top