From: Bre-x on 10 May 2010 10:14
Thank you very much.
"KenSheridan via AccessMonster.com" <u51882(a)uwe> wrote in message
> Roger Carlson has simple solutions for both single and multi-user
> environments at:
> while my slightly more complex solution at:
> also allows the number to be 're-seeded' with a number at which the
> 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
>>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
>>main_receipt starting from a number in another table.
>>> 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]
> Message posted via http://www.accessmonster.com