View Single Post
  #3 (permalink)  
Old March 6th, 2005, 06:43 PM
dartcoach dartcoach is offline
Friend of Wrox
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post


How about this - Create the table first with a column of type number.
Use vba to create a procedure.
1st. - Sql = "Delete * from Table;"

2nd. - Set a variable to 0.
3rd. - For each record in the main table,

SQl = "Insert into table variable+1, etc, etc, etc,"

What do you think? This way, He wouldn't have to add the autonumber everytime he created the table?


Reply With Quote