|
Subject:
|
Autonumber problem
|
|
Posted By:
|
mankoti_mankoti2000
|
Post Date:
|
8/26/2006 6:12:56 AM
|
sir,
i have a field namly Diary_number it is autonumber. Autonumber field always starts from 1 but i want it to start from 1401, is it possible, if possible then please help me and tell me how.
|
|
Reply By:
|
echovue
|
Reply Date:
|
8/26/2006 9:38:09 AM
|
There may be a better way of doing this, but what I do is....
Setup another table with the same fields, except set the autonumber field as a number.
Enter a single record in that table with 1400 in the field that used to be the autonumber.
Next to an Append query to insert the row into your original table.
Now the next row should be 1401, and you can go ahead and delete the first row.
Hope that helps,
Mike
Mike
EchoVue.com
|
|
Reply By:
|
mankoti_mankoti2000
|
Reply Date:
|
8/26/2006 10:46:04 PM
|
sir,
thank you very much for replying my query. but sir it doesn't work. have you sir any other option it any please send me the option so that i can solve my problem
thanking you
harish mankoti
|
|
Reply By:
|
echovue
|
Reply Date:
|
8/26/2006 10:55:53 PM
|
It should work... At which point did it not work? Perhaps I skipped a step of something?
Mike
EchoVue.com
|
|
Reply By:
|
mankoti_mankoti2000
|
Reply Date:
|
8/27/2006 7:55:58 AM
|
[quote]Originally posted by mankoti_mankoti2000
sir,
i have a field namly Diary_number it is autonumber. Autonumber field always starts from 1 but i want it to start from 1401, is it possible, if possible then please help me and tell me how.
[/
respect echovuo Sir,
thank you very much for giving me right inforamtion and right time but i could not understand right time now i have solved my problem with the help of you, with you help it was not possible to me]
|
|
Reply By:
|
SerranoG
|
Reply Date:
|
8/28/2006 10:09:30 AM
|
Hello. I think you misunderstand the use of autonumbers. They are not meant to hold any meaning at all. Therefore, it does not matter what number they start with. Their only function is to relate data from one table to another via a unique identifier. Users never see this number.
If you need a number to make sense, then make Diary_Number NOT an autonumber. Make it a number of type Long and set it yourself via VBA code during run time or have someone be able to assign it via a form textbox.
Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
|
|
Reply By:
|
Hennie
|
Reply Date:
|
8/29/2006 12:28:36 AM
|
Hi mankoti_mankoti2000
Try this link http://www.techonthenet.com/access/modules/sequential_nbr.php
I think this will solve your problem.
Cheers,
Hennie
|
