i want to make auto generated item number look like this
item001
item002
and so on
when i saved the item001 the next time i try to input new item it will give me item002 and so on...
Thank You.
i am using ACCESS
nullclick 0 Newbie Poster
Saikalyankumar -2 Junior Poster in Training
Where you are saving the items in database or some where else?
nullclick 0 Newbie Poster
Where you are saving the items in database or some where else?
i am using access sir.
debasisdas 580 Posting Genius Featured Poster
since you are storing the data in the DB , need to read the max of existing number and increment the same by 1 to get the new number and concatenate the same with your string.
Saikalyankumar -2 Junior Poster in Training
You follow the process given by debasisdas or else make the auto increment in the access, and the get the incremented value and concatenate to the string, for auto increment to access using vb coding refer to this http://forums.asp.net/t/999557.aspx/1?How+to+Auto+Increment+a+Primary+Key+value+using+Access+and+Forms+View+in+VS+2005
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.