 |  |  |  |  |  |  |  |
Auto generate ID Number
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
i want to auto generate an ID like 1, 2, 3.
and anytime i close my application and open it again it should start from the Id it stopped.
if i enter up to 6 the next one should be 7.
Can anybody help me?
and anytime i close my application and open it again it should start from the Id it stopped.
if i enter up to 6 the next one should be 7.
Can anybody help me?
Use to save the last number auto number in a separate table so that whenever you add another record, get the last number and then add one number for a new auto number and then update the last number in the Autonumber Table again. In this way, you can simply make auto number.
eg. lastno=Last number stored in the table
lastno=Val(lastno)+1
You can Save the Last Auto number using database table or using Text File.
eg. lastno=Last number stored in the table
lastno=Val(lastno)+1
You can Save the Last Auto number using database table or using Text File.
•
•
•
•
Originally Posted by K.Vanlalliana 
Use to save the last number auto number in a separate table so that whenever you add another record, get the last number and then add one number for a new auto number and then update the last number in the Autonumber Table again. In this way, you can simply make auto number.
eg. lastno=Last number stored in the table
lastno=Val(lastno)+1
You can Save the Last Auto number using database table or using Text File.
Hello i hav tried but i can get it please can you send me a sample code
•
•
Join Date: Feb 2008
Posts: 520
Reputation: 
Solved Threads: 89
Posting Pro
Similar Problem already discussed in the following thread http://www.daniweb.com/forums/thread135921.html
Selva 
Dear All,
Plz focus on the exact problem.
When u r posting in this forum, first do give the backend u r using, table structure if possible, some sample code in front end which u r having problem with. 'll definitely help us to help u all.
regards
Shaik Akthar
Plz focus on the exact problem.
When u r posting in this forum, first do give the backend u r using, table structure if possible, some sample code in front end which u r having problem with. 'll definitely help us to help u all.
regards
Shaik Akthar
•
•
•
•
Originally Posted by aktharshaik
Dear All,
Plz focus on the exact problem.
When u r posting in this forum, first do give the backend u r using, table structure if possible, some sample code in front end which u r having problem with. 'll definitely help us to help u all.
regards
Shaik Akthar
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
|
Similar Threads
- How to generate auto increment number? (VB.NET)
- Auto generation of numbers.. (C#)
- Generate Primary Key in VB / Delete Record Status (Visual Basic 4 / 5 / 6)
- generate unique primary key (MySQL)
- Need to know how to create a database that will generate a random number (Database Design)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: how can i minimize my all form
- Next Thread: How to get a quotient & a Remainder
Views: 5514 | Replies: 6
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 2007 access activex add age append application basic beginner birth bmp c++ calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver struct subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
