Autonumber

[onlyty]

Hi please help

I have a created a DB to use for enrolling students onto courses.

I have now imprted the old list from excel into a table but I am having a problem setting the autonumber to one after 2260 - the number on there now.

I have read other posts but still cannot find the answer

I tried an append query taking the details from the imported table and appending them to another but I have a "you tried to assign a Null value to a variable that is not a Variant data type" error

lost now

 

[rainman89]

Autonumbers should normally not have any relation to your data. They are there to uniquely identify your records..

what is this autonumber supposed to be used for?

 

[themastertaylor]

Hi please help

I have a created a DB to use for enrolling students onto courses.

I have now imprted the old list from excel into a table but I am having a problem setting the autonumber to one after 2260 - the number on there now.

I have read other posts but still cannot find the answer

I tried an append query taking the details from the imported table and appending them to another but I have a "you tried to assign a Null value to a variable that is not a Variant data type" error

lost now

Not sure if this will work in other versions but in access 2007, copy your existing table, and paste a copy, you should get a dialogue asking if you want to copy the structure or the data and the structure, if you just copy the structure and paste your data from excel column by column ignring the autonumber field it should start from 1. then rename the tables so that your copy is called whatever the otriginal was for the sake or queries forms etc

edit - just re-read it and unsure if you mean start at 1 or 2261 - if you mean 2261 i used the following method

http://office.microsoft.com/en-us/access/HP051887741033.aspx