AutoNumber Increment - Append Query Not Working

[jnice814]

I am trying to create an AutoNumber that will begin at a number that I specify. I have followed all instructions in MS Access Help, but it is still not working. I continue getting an error message that 1 record has a validation rule problem, but I cannot figure out what it is. I don't have anything in the validation rule fields on either table. I've checked everything in both tables. What can I be missing? This is very frustrating...

I am simply trying to set my AutoNumber to begin at 1000 instead of 1. My temporary table begins the numbering at 999 and is a "Number" in the field type. My primary table that I am trying to append to is field type AutoNumber. The field names in both tables are the exact same.

HELP!!!

[FishVal]

I am trying to create an AutoNumber that will begin at a number that I specify. I have followed all instructions in MS Access Help, but it is still not working. I continue getting an error message that 1 record has a validation rule problem, but I cannot figure out what it is. I don't have anything in the validation rule fields on either table. I've checked everything in both tables. What can I be missing? This is very frustrating...

I am simply trying to set my AutoNumber to begin at 1000 instead of 1. My temporary table begins the numbering at 999 and is a "Number" in the field type. My primary table that I am trying to append to is field type AutoNumber. The field names in both tables are the exact same.

HELP!!!

Hi, there.

No matter whether field names of both table are the same or not. Access refuses to append records bkz you try to set value of appended records autonumber field which by all means is read only.
If you don't care your temporary table numeration will be replaced with autonumbers, then exclude temporary table number field from the append query.

Regards,
Fish

[jnice814]

Hi, there.

No matter whether field names of both table are the same or not. Access refuses to append records bkz you try to set value of appended records autonumber field which by all means is read only.
If you don't care your temporary table numeration will be replaced with autonumbers, then exclude temporary table number field from the append query.

Regards,
Fish

Fish-
I still don't see how this will work. If I exclude the temp. table number field from the append query, then how will I accomplish my end goal, which is to customize the autonumber field in another table to begin with 1000 instead of 1.

Thanks,
jnice

[wvmitchell]

If you've got Table1 and the autonumber field is ID: Create a new query, don't add any tables, but switch into SQL View and paste in this, and then run it:

INSERT INTO Table1 ( ID ) SELECT 999 AS Expr1;

After you run that, subsequent appends will begin with 1000. After you do your first append, you can go back and delete the 999 record.

Hope that helps.

[FishVal]

Fish-
I still don't see how this will work. If I exclude the temp. table number field from the append query, then how will I accomplish my end goal, which is to customize the autonumber field in another table to begin with 1000 instead of 1.

Thanks,
jnice

Add dummy records until autonumber get to 999, then delete them, then run your query.

[jnice814]

wvmitchell-

It worked!!! thank you, thank you

Fish- thanks for your helping get to the right direction as well.