Auto number will start from 10 not in 1

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

I have created a Data entry form wherein they enter outgoing faxes. They are
already in number 51775, which they call the reference number and they are
writing this manually in a book. They want that to be automated but they want
that the next number to appear is 51776.

I have been trying to make this work but i still end up with 1. I cannot
find within the help command any mention on how to solve this problem.

Can you please assist me in this. Thank you.
 
Hi Neil,

it is possible to start an autonumber field with another number then 1 (see
Access help), but it won't help you much. Whenever you enter a new record,
find out you make a mistake and restart, the autonumber that was created is
lost, and you have a "hole" in your numbering. A better solution in this
case is to create a normal number field - type long and then fill it with a
counter such as
myField = Dmax("myField","MyTable") + 1
or work with a separate numbering table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Verify value overwrite in Auto Filled fields 2
Partial text returned from a query 0
Form for Parts-Tools Lists 0
The next Grand Theft Auto title has been officially announced 0
Auto filling fields in a sub-form (Access 2003) 1
AutoNumber - Start at number larger than 1 2
Creating sequential numbers in subform 7
Display number of records 2

Back
Top