Re: Set Autonumber

Thanks for your response - given your caution, what is the best way then to
have a field that will increment by one for each records?

Thanks
A

"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in message
news:RpPwf.23214$UF3.8579@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Alex H wrote:
>> I want to use the autonumber as a serial number, but need it to start
>> at 1005. is this possible please?
>>
>> Thanks
>> A
>
> Use an append query to insert a record into th4e table with a value of
> 1004 and then delete that record afterwards. The next record will then
> use 1005.
>
> Hopefully you understand that AutoNumbers will not reliably produce a
> sequence of numbers without gaps. The general use of AutoNumbers involves
> having zero concern for their value other than that they be unique. If
> you are counting on anything beyond uniqueness you are likely to be
> dissappointed.
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>


.

Relevant Pages

  • Re: Set Autonumber
    ... > Thanks for your response - given your caution, ... > then to have a field that will increment by one for each records? ... users simultaneously entering records doing this in the BeforeUpdate event ...
    (microsoft.public.access.tablesdbdesign)
  • Re: autonumber
    ... If you need to work with autonumbers, then check next links how to do this properly. ... There is no reason to create variables to increment this value and it is not reliable way. ... Dim toadd As String ...
    (microsoft.public.vb.database.ado)
  • Re: Making an autonumber field start at a set number
    ... parts of the key display on the form and don't know how to make the number ... increment starting from a given number say 550000, can anyone help, ... The intent of Autonumbers is that they ... newsgroups at http://groups.google.com with various related search words ...
    (comp.databases.ms-access)
  • RE: Autonumbering Primary Keys
    ... Try a groups search for "increment number ... primary key" or "increment autonumber" or "simulated autonumber" or something ... > Access suggests that I have a separate column for OrderID using Autonumbers. ...
    (microsoft.public.access.gettingstarted)
  • Re: How to retrieve id of last inserted record in Access without using @@identity?
    ... I am using Increment and not Random. ... >> highest ID if you are using autonumbers. ... but not necessarily if the NewValues property is set to Random. ... Prev by Date: ...
    (microsoft.public.access.queries)