Creating an autonumber field using VBA and DAO

Article View: comp.databases.ms-access

Article #555

Back to comp.databases.ms-access Previous Next

#555

From: David
Date: Sun, 13 Aug 2000 00:00

17 lines
1631 bytes

Hi

I can create fields and tables programmatically using VBA.

When I create the field, I can determine whether it is long, text, boolean
etc.

However I have no idea how to make one of the fields that I add an
autonumber field

Please help and thanks




--
DME

Technical Details

Message-ID: <3995ce32.0@news1.mweb.co.za>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 13a981,46b938df45b1c783,start
X-Google-Attributes: gid13a981,public
X-Google-Thread: 1143dd,46b938df45b1c783,start
X-Google-Attributes: gid1143dd,public
X-Google-Thread: f8db2,46b938df45b1c783,start
X-Google-Attributes: gidf8db2,public
X-Google-Thread: 10a93f,46b938df45b1c783,start
X-Google-Attributes: gid10a93f,public
X-Google-Thread: 1142f6,46b938df45b1c783,start
X-Google-Attributes: gid1142f6,public
X-Google-Thread: 10f31b,46b938df45b1c783,start
X-Google-Attributes: gid10f31b,public
X-Google-Thread: ff0ac,46b938df45b1c783,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1137ed,46b938df45b1c783,start
X-Google-Attributes: gid1137ed,public
From: "David" <habanero.burns@mweb.co.za>
Subject: Creating an autonumber field using VBA and DAO
Date: 2000/08/13
Message-ID: <3995ce32.0@news1.mweb.co.za>
X-Deja-AN: 657616254
X-Trace: 13 Aug 2000 00:22:42 +0200, vic-dial-196-31-176-24.mweb.co.za
X-MSMail-Priority: Normal
X-Priority: 3
Newsgroups: comp.databases.ms-access,free.database.access,it.comp.database.access,microsoft.public.access.3rdpartyusrgrp,microsoft.public.access.chat,microsoft.public.access.developers.toolkitode,microsoft.public.access.devtoolkits,microsoft.public.access.exte
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200