Re: Creating an autonumber field using VBA and DAO

Article View: comp.databases.ms-access

Article #559

Back to comp.databases.ms-access Previous Next

#559

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

34 lines
1903 bytes

My last post referred to using Access to autonumber.
I had a similar problem, I wanted a number field to increase by one.  I
created a button that runs a macro.  The macro opens the table, moves
to the last record (movelast) read the value, increment by one, move to
the next (new) record (movenext) and insert the value into the field.
It is slow for my system but it works.  The same type of logic should
work in VBA.

Anyone else got ideas?

In article <3995ce32.0@news1.mweb.co.za>,
  "David" <habanero.burns@mweb.co.za> wrote:
> 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: <8n98uv$6m0$1@nnrp1.deja.com>

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

References: <3995ce32.0@news1.mweb.co.za>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f8db2,46b938df45b1c783
X-Google-Attributes: gidf8db2,public
X-Google-Thread: 10f31b,46b938df45b1c783
X-Google-Attributes: gid10f31b,public
X-Google-Thread: ff0ac,46b938df45b1c783
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10a93f,46b938df45b1c783
X-Google-Attributes: gid10a93f,public
From: randy_putnam@my-deja.com
Subject: Re: Creating an autonumber field using VBA and DAO
Date: 2000/08/14
Message-ID: <8n98uv$6m0$1@nnrp1.deja.com>
X-Deja-AN: 658188462
References: <3995ce32.0@news1.mweb.co.za>
X-Http-Proxy: 1.0 men_proxy, 1.0 x66.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 17:06:44 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