Adding an Auto number to existing data

[brettvba]

Hi Guys, How can I add an auto number ( or something like it) to new

entrys, I know that if you start from fresh Access will auto number for you if

you set the field to auto number but what do you do with existing data?

Is there a self incrementing macro that can be made or is there a factory option?

Brett

 

[SydneyGeek]

Hi Brett, is the existing data coming in from Excel? And if so, is it related to data in other tables?
The reason I ask is that bringing in an existing Number field from an external source makes it forever a Number, not an Autonumber -- and I assume that's your hassle.
With the existing data -- is it important to keep the existing ID numbers? If YES, I have a workaround that does the job in a booking/invoicing system that I put together. It involves a query and a bit of code, but no too tricky. Reply if you need more info on this.
If NO, delete the existing IDs and replace them with a new Autonumber field.

Hope that helps.

 

[brettvba]

Thanks, I didn't need the existing numbers so deleting the field worked.

Cheers

Brett