Creating Autonumber Field

's Computer Specifications

How can I create an autonumber field using VBA, and set it to the primary key
field?

eg) newtable.createfield("KeyCode", dbAutonumber) --- something like this???

please help?

's Computer Specifications

Never Mind, i figured it out.

"James" wrote:

> How can I create an autonumber field using VBA, and set it to the primary key
> field?
>
> eg) newtable.createfield("KeyCode", dbAutonumber) --- something like this???
>
> please help?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating an Autonumber field	Ed Cohen	Microsoft Access	2	9th Jun 2008 05:17 AM
Creating autonumber field programmatically	Amy Blankenship	Microsoft Access Form Coding	2	11th Jul 2006 11:45 PM
Creating a table with an autonumber field	=?Utf-8?B?TUNocmlzdA==?=	Microsoft Access VBA Modules	1	22nd Jun 2005 11:19 PM
AutoNumber Field's value when creating a new record	=?Utf-8?B?TGVzbGVl?=	Microsoft Access Form Coding	1	22nd Apr 2004 04:35 AM
Re: Creating an 'autonumber' field in a report	Cheryl Fischer	Microsoft Access Reports	0	16th Sep 2003 07:44 PM