🚀 go-pugleaf

I believe what the poster is looking for is how to create a table, using
VBA, so that it has an Autonumber field in it, not how to simulate one in
code.

The reference David posted, to Dev Ashish's "The Access Web", indeed shows
how to create such a table in code.

--

Doug Steele, Microsoft Access MVP
Beer, Wine and Database Programming. What could be better?
Visit "Doug Steele's Beer and Programming Emporium"
http://I.Am/DougSteele/


<randy_putnam@my-deja.com> wrote in message
news:8n98uv$6m0$1@nnrp1.deja.com...
> 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.