 |
| Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
August 26th, 2006, 06:12 AM
|
|
Authorized User
|
|
Join Date: May 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Autonumber problem
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.
|
|
August 26th, 2006, 09:38 AM
|
|
Friend of Wrox
|
|
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
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
|
|
August 26th, 2006, 10:46 PM
|
|
Authorized User
|
|
Join Date: May 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
August 26th, 2006, 10:55 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
It should work... At which point did it not work? Perhaps I skipped a step of something?
Mike
EchoVue.com
|
|
August 27th, 2006, 07:55 AM
|
|
Authorized User
|
|
Join Date: May 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
[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]
|
|
August 28th, 2006, 10:09 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
|
|
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
|
|
|
