Re: Creating an autonumber field using VBA and DAO

Article View: comp.databases.ms-access

Article #558

Back to comp.databases.ms-access Previous Next

#558

From: randy_putnam
Date: Mon, 14 Aug 2000 00:00

43 lines
1910 bytes

If you want a field autonumbered:
  in design view, type in the field name
  under data type, use the drop-down list and select autonumber


In article <39961050.1103857@news.syspac.com>,
  tomvs@syspac.com (Tom van Stiphout) wrote:
> On Sun, 13 Aug 2000 00:33:49 +0200, "David"
> <habanero.burns@mweb.co.za> wrote:
>
> Check out:
> http://www.mvps.org/access/tables/tbl0016.htm
> And bookmark that site! It's a great source of information.
>
> -Tom.
>
> >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
> >
> >
> >
>
>


Sent via Deja.com http://www.deja.com/
Before you buy.

Technical Details

Message-ID: <8n98bp$663$1@nnrp1.deja.com>

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

References: <3995ce32.0@news1.mweb.co.za> <39961050.1103857@news.syspac.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,46b938df45b1c783
X-Google-Attributes: gidff0ac,public
X-Google-Thread: f8db2,46b938df45b1c783
X-Google-Attributes: gidf8db2,public
X-Google-Thread: 10a93f,46b938df45b1c783
X-Google-Attributes: gid10a93f,public
X-Google-Thread: 10f31b,46b938df45b1c783
X-Google-Attributes: gid10f31b,public
From: randy_putnam@my-deja.com
Subject: Re: Creating an autonumber field using VBA and DAO
Date: 2000/08/14
Message-ID: <8n98bp$663$1@nnrp1.deja.com>
X-Deja-AN: 658184753
References: <3995ce32.0@news1.mweb.co.za> <39961050.1103857@news.syspac.com>
X-Http-Proxy: 1.0 men_proxy, 1.0 x62.deja.com:80 (Squid/1.1.22) for client 12.2.11.83
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Mon Aug 14 16:56:28 2000 GMT
X-MyDeja-Info: XMYDJUIDrandy_putnam
Newsgroups: comp.databases.ms-access,free.database.access,it.comp.database.access,microsoft.public.access.3rdpartyusrgrp
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95)

Reply to Parent Message