CUSTOM ID after user restart program it fail auto count

[christing]

When user restart program ID can not continue count.


for example INV001 ,INV002,when user restart the program the ID will recalculate from to INV001.

Dim ids As List(Of Integer) = New List(Of Integer)()
For i As Integer = 1 To 100
ids.Add(i)
Next


Dim idstring As String = "INV" & ids(count).ToString().PadLeft(4, "0"c)
Textbox1.Text = idstring
count += 1

[GinaWhipp]

When the Program reloads or the Form? Wouldn't it add one when they press the Add New button?

Hmm, maybe it would help if you would tell us how this Form works or better yet what are the steps that are applied to cause a new Invoice ID to load.

[davegri]

That's not VBA, looks like VB.Net. In any case, you need to store the inv numbers in a table. Then to continue, the code needs to find the highest existing inv number and continue from there.

[christing]

Yes this is not a vba it is a vb.net...if user continue add a new data the inv id will calculate continue. if user restart the program the auto id (INV001) will return back to inv001

[christing]

the process is when the program start and user key in data successful it will auto give a new id and continues until user restart the program the id will recalculate from INV0001

[GinaWhipp]

My bad, saw it was in the Access > Forms section... moving along.

[davegri]

I haven't used VB.Net much since 2010, so I can't be any more help than the generalization in post#3. Access is not a tool for web development, as VB.Net is. You'd have better luck at a web development forum.