Add 1 or = to same as

[hendrikbez]

I have a form with a few textboxes where I add info to a table.
I want to know if I have a textbox that always shows "123mag1212" is is possible that when I add a new record it can ask me (button with +1 or =) if I want to increase the number by one "123mag1213" or leave it the same.

 

[sneuberg]

You can pull out the numeric part of the string out with the Right or Mid functions, converted it to a integer using CInt, add 1 to it and then concatenate it back together.

But why is the textbox always showing "123mag1212" and is the only other value you want to assign to it "123mag1213"?

 

[hendrikbez]

Sneusber, I have added it that is will show int the textbox when I press the new button, Can you please give more more information on what you ask me to do. I do not understand what I must do.
Sorry English is not my first language.

 

[sneuberg]

Please answer my question, "Is the only other value you want to assign to it "123mag1213?" If not please explain in more detail how this is to work.

Also how should this interact with the user? Via a message box?

 

[sneuberg]

Sneusber, I have added it that is will show int the textbox when I press the new button

How? Is it the default value?

 

[jdraw]

hendrikbez,

It would be helpful to readers if you would describe your application in plain English. We need some business context for your question.

For example:
What are you trying to accomplish-plain English no jargon?
Where does 123mag1212 fit?
How does it get valued?
What exactly is its purpose?

Good luck with your project.

 

[hendrikbez]

hendrikbez,

It would be helpful to readers if you would describe your application in plain English. We need some business context for your question.

For example:
What are you trying to accomplish-plain English no jargon?
Where does 123mag1212 fit?
How does it get valued?
What exactly is its purpose?

Good luck with your project.

I do have about 14 textboxs inputs.

The 123mag1212 is one of my records info, I getting stickers from a company to use for tapes that I send out to them. The last 4 numbers is the only ones that will change. I can use the number for 1 tape the next number for two tapes or next number for 4 tapes (I put 1 to 4 tapes together)

At the moment I have set the value in the textboks to show when I press add new record.

The purpose is that for each tape, I have to change the last few numbers and if I have a button for add +1 number or button for = to keep the same number for the new tape record. I have to put quit a lot of records in per day, and just want finish it quickly.

I did think about this weekend. It must get the 5421MagXXXX number from the last record in my table.