Restart auto number after deleting records
The autonumber is my primary key and doesn't really have anything to do with the other data in the table (i.e. I don't care if the auto number changes on a record, provided the other data doesn't change).
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I am sure Im not the first with this question or issue. I did search through a couple hundred entries about auto number before I posted this question
In the property sheet I chose Limit To List "Yes".
I can only add the words good, bad or unknown, which was my goal. But access creates new records into my querry. When I chose unknown it saves unknown [auto-number 4]. So the next time I can choose between good [auto-number 1], bad [auto-number 2], unknown [auto-number 3] and unknown [auto-number 4].
Therefore I save the information but I cannot use it in the end because every record has a different auto-number.
Can someone please help me, I already spend 6h try and research on the internet but I could not find an answer
We used auto numbering for each record, the auto number is the first field in the database ( I believe this is my primary key as well). when a user deletes a record - say record 4 for example - the database does not renumber the records it just shows the records in order as 1, 2, 3, , 5, 6, etc. skipping number 4. So this puts my users in a position where they have no idea how many actual records are in the database.
Is there a way to have access re-number the records? I assumed when I setup auto numbering for column 1 that it would do this.
However - I have an auto field - record number - this obviously remains at the number of the last record in the (deleted) database.
Can I re-set the numerical origin of this field to start again at one ? Or do I have to delete it and set up another auto record number field ?
This is not an urgent enquiry - probably a bit basic for many on the forum - but just to add to my knowledge of Access.
Fields: Autonumber (Primary key), [SUbmission Number 1], [Submission Number 2], Relationship
Using Access 2002
I want to remove duplicate records where for two records, [Submission number 1], Submission Number 2] and Relationship are the same. It is easy to find the duplicates, but is there any wayto remove one of the duplicate records?
Next time if I enter a record I want the is to be 91.but its as 101.
I want to paste records that have unique reference numbers from an excel sheet into my access data table.
However when I do this Access changes the reference numbers as the relevant column in the table automatically generates a number series.
Is there any way of turning off this auto generate feature