Autonummering i en tabel

You will need to make your own number system. Autonumbers normally start from 1 but this can be altered, but it can NOT be a number if it must start with 0

You can try this in the dbug window (CTRL+G)

docmd.RunSQL "INSERT INTO YourTable VALUES (10001)"

This is JUST and example.
You need to alter the name of the table and also the start value (which MUST be numerical) and then add th eother fields to the VALUE list!

Hmm, could you be more specific on what I am gonna do. I am not good at programming...

What do you mean by Start Value and Value list?

Når autonummereringen må starte med 1, kan du i feltets egenskab Format indtaste:

>"10000"

Så vil den først oprettede post blive 10001, næste 10002 o.s.v.

start value is the value you want to begin (begynde)from, for example 10000.

The value list is the VALUES which you want to insert into your table. For example, if you have the following table.

tblTest
-------
ID Autonumber
txtField Text
NrField Number

Then the Value List could be for example

VALUES (10000, 'Some Text', 12345)

So your SQL would be

"INSERT INTO tblTest VALUES (10000, 'Some Text', 12345)"