When you're creating a table definition, what is the constant to make a
field an autonumber vs an integer?

TIA;

Amy

How are you creating the table?

If you're using DAO, you need to set the field's Attribute to include
dbAutoIncrField

Set tdf = dbs.CreateTableDef("Contacts")
Set fld1 = tdf.CreateField("ContactID", dbLong)
fld1.Attributes = fld1.Attributes + dbAutoIncrField

If you're using DDL, the type is COUNTER.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Amy Blankenship" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When you're creating a table definition, what is the constant to make a
> field an autonumber vs an integer?
>
> TIA;
>
> Amy
>

Thanks a bunch!

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:%(E-Mail Removed)...
> How are you creating the table?
>
> If you're using DAO, you need to set the field's Attribute to include
> dbAutoIncrField
>
> Set tdf = dbs.CreateTableDef("Contacts")
> Set fld1 = tdf.CreateField("ContactID", dbLong)
> fld1.Attributes = fld1.Attributes + dbAutoIncrField
>
> If you're using DDL, the type is COUNTER.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Amy Blankenship" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> When you're creating a table definition, what is the constant to make a
>> field an autonumber vs an integer?
>>
>> TIA;
>>
>> Amy
>>
>
>