Text box auto takes serial no when items select form combo box

Question

1.00/5 (1 vote)

See more:

i built one program but facing problem what i try to do is when i select items from combobox eg. Primary vertical(PV), secondary vertical(SV) etc. next textbox will auto take serial no. like PV-01/today_date, next entry will be PV-02/today_date and so on and when next day again i try to add entries serial no. started from PV-01/.....
I AM USING VB 2010 with access database for this.

What I have tried:

dont know what to do i am new in vb

Posted 31-Aug-21 9:15am

GOBIND KUMAR SHARMA

Updated 1-Sep-21 23:05pm

Add a Solution

Comments

CHill60 1-Sep-21 3:36am

There is insufficient information here for us to help you. As you are using Access do you have an Autonumber column on your table - that will automatically increment as you add new records. Add the "PV-" and date in the UI

GOBIND KUMAR SHARMA 1-Sep-21 10:46am

in access database id column is there but i want another column which is serial no but serial no is in form PV-01/01-09-21, PV-02/01-09-21 and next day again started from serial no which is PV-01/02-09-21

Maciej Los 1-Sep-21 14:48pm

Does your database is used in multi user environment?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2021-09-01T23:05:00

This is not a good design, because anything you try to do will not be guaranteed to work in a multi-user environment. By this I mean that you are essentially counting the number of rows entered today so far, and adding one. But what if another user is inserting a record at the same time? You will get two identical references.

You might be tempted to "capture" somewhere the last auto-number id of the previous day and subtract that from the auto-number generated for each record - but it sounds like you want the numbers to be sequential, and auto-numbers are not guaranteed to be that, so this would also be a bad design decision.

Consider - how important is it that you store this "id" in this format? If you need to know how many records have been added in a day then query for that information rather than recording it.

Is it important that it is done immediately? If not then consider updating the previous day's records with a sequence - this will work for a multi-user environment (assuming only one user can run the update job) because you can't time travel to add new records for that day.

The only other solution I can think of is that you have another table that will be used to generate the sequence which you can reset at the beginning of each day. But that is even clunkier

By far the better solution is to just use the auto-number generated automatically when you add a new record, and capture the date the record was inserted. Then you can format that anyway you like. Just accept that there can be gaps in the sequence and it won't restart daily - don't try to combine MI into a persisted data item.