Re: problems with autonumber fields

Hi,
yes, you can! look at CreateField DAO method in access help, to make autonumber - you need to set dbAutoIncrField attribute for a field.

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"CristianTCDM" <CristianTCDM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:948EEE47-8349-45D3-8335-E86F0FCB778A@xxxxxxxxxxxxxxxx
Hello ,

Is it possible to append an autonumber field (autoincrement) to an existing
table with a certain number of records , using VBA or query in access 2007?

Thanks to everyone who can help

.

Relevant Pages

  • Re: Retrieve select record from AutoNumber field
    ... wildcard "*". ... Check Access HELP on wildcards. ... record from an AutoNumber field? ... My autonumber is also the primary ...
    (microsoft.public.access.queries)
  • Re: ADO autInc
    ... MS Access will generate this autoinc value only after real post. ... With best regards, Mike Shkolnik ... It seems that AutoNumber is generated after post. ...
    (borland.public.delphi.database.ado)
  • Re: Email Report
    ... Access Help for more information. ... Regards ... Meir ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: List The files in a directory with a command button
    ... Look in Access help for a sample using this function ... Best regards, ... Alex Dybenko (MVP) ...
    (microsoft.public.access.modulesdaovba)
  • Adding records to MS Access 97 Tables using ASP.net
    ... Autonumber and the other two are text type for the last two days and now i am ... I dont have any queries in the table. ... Regards ... Three Cheers to Technet for the Help! ...
    (microsoft.public.dotnet.framework.aspnet)