Chage the starting value of an AutoNumber field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen - 29 May 2006 16:05 GMT

I'm trying to change the starting value. I've followed the help program but
getting "About to append 0 rows" and it doesn't work

Reply to this Message

KARL DEWEY - 29 May 2006 17:53 GMT

Bad idea. I suggest you read the post on why relying on autonumbers is bad -
omissions in sequence.
You did not say where you wanted to start the autonumber. If you qant to
start at 50 then create an append query with two fields.
XX: 49 YY: "Test"
Set the ZZ to append to your autonumber field and YY to any text field.
Run the append query.

> I'm trying to change the starting value. I've followed the help program but
> getting "About to append 0 rows" and it doesn't work

Reply to this Message

Ken Sheridan - 29 May 2006 18:41 GMT

You'll find a demo of a resettable custom generated sequential number at:

http://community.netscape.com/n/pfx/forum.aspx?nav=libraryMessages&tsn=1&tid=238
39&webtag=ws-msdevapps

Ken Sheridan
Stafford, England

> I'm trying to change the starting value. I've followed the help program but
> getting "About to append 0 rows" and it doesn't work

Reply to this Message