Prev: Error message when adding a new record
Next: Stuck on Simple Query and Form from 2 Tables
From: Bre-x on 10 May 2010 10:14
Thank you very much.




"KenSheridan via AccessMonster.com" <u51882(a)uwe> wrote in message
news:a79d8fd9ee7c7(a)uwe...
> Roger Carlson has simple solutions for both single and multi-user
> environments at:
>
> http://www.rogersaccesslibrary.com/forum/topic395.html
>
> while my slightly more complex solution at:
>
> http://community.netscape.com/n/pfx/forum.aspx?nav=libraryMessages&tsn=1&tid=23839&webtag=ws-msdevapps
>
>
> also allows the number to be 're-seeded' with a number at which the
> sequence
> will re-start when the next record is added. This could be adapted to re-
> start the sequence with your number from another table.
>
> Ken Sheridan
> Stafford, England
>
> Bre-x wrote:
>>I coundn't find what I am looking for, most of the instructions are to
>>reset
>>the autonumber.
>>I am looking for a way to auto increment a field.
>>
>>After a few hundred records have been inserted I need to find a way to
>>auto
>>increase the
>>main_receipt starting from a number in another table.
>>
>>Help!!!!!!
>>
>>Bre-x
>>
>>> If you are using Access' Autonumber data type, be aware that it is ONLY
>>> designed to provide a unique identifier. It is not guaranteed to be
>>[quoted text clipped - 28 lines]
>>>>
>>>> Bre-x
>
> --
> Message posted via http://www.accessmonster.com
>


First  |  Prev  | 
Pages: 1 2
Prev: Error message when adding a new record
Next: Stuck on Simple Query and Form from 2 Tables