Autonumber

[amfroehlich]

I have a feild that is AutoNumbered. But, I want it to start at 300 how can I do this.

 

[SydneyGeek]

One option is to create a table with EXACTLY the same fields as your existing. Let's call them DUMMY and KEEP for the moment.
OK, in DUMMY, create 299 records. (Just put junk into the first data entry field)
Build a query based on KEEP that has every field except the Autonumber field.
Turn it into an Append query, and append the records to DUMMY.
Now go to DUMMY and delete the first 299 records.
Delete KEEP and rename DUMMY. Note: You'll need to delete any relationships to KEEP before you delete it, then re-establish those relationships afterwards.

There are other, code-based solutions around, but this quick and dirty method does the job.

Denis

 

[bat17]

One thing to bear in mind with autonumbers that it is easy to get missing numbers in the sequence, they are designed to give a unique reference to each record but they are not good for creating numbers that cannot have gaps in the sequences like receipts.

Access assigns the next number as soon as you start creating a record. If you cancel the record (or the PC/Network crashes before you can save it) then you will lose that number and have a gap.

Peter