By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,578 Members | 828 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,578 IT Pros & Developers. It's quick & easy.

AutoNumber Increment - Append Query Not Working

P: 8
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!!!
Oct 17 '07 #1
Share this Question
Share on Google+
5 Replies


FishVal
Expert 2.5K+
P: 2,653
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
Oct 17 '07 #2

P: 8
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
Oct 18 '07 #3

P: 42
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.
Oct 18 '07 #4

FishVal
Expert 2.5K+
P: 2,653
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.
Oct 18 '07 #5

P: 8
wvmitchell-

It worked!!! thank you, thank you

Fish- thanks for your helping get to the right direction as well.
Oct 18 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.