how to create an AutoNumber field in VBA?

[gc]

I use DAO to create a temp table. But I don't know how to create an Autonumber field in that table directly. Microsoft has a code using function to create the autonumber field. This means after create the temp table I should call the function to add the autonumber field in the temp table.
Is there a way to add some code in Create table statement instead of calling the function?
Thank you very much in advance!
George

 

[Malchik]

hi
Its not very obvious, but to create an AutoNumber field you have to use as data type COUNTER Mal'chik