code for storage in my form

Question

0.00/5 (No votes)

See more:

I have a form in visual studio 8.0. In my form I have
two text field(ID,amount),
a button(Order). I have a table(Items) in Ms.Access having two Field
ID and amount and having two records. First record 1 in ID and 40 in amount. second record 2 in ID and 100 in amount.
when I Enter 1 in text Field (ID) 20 in text Field (amount), and then press button order.
I want it to be added with the previous Amount that have ID 1 Saved in the table.Means If previous amount that have ID 1 is 40
then the result after saving must be 60.

when I Enter 2 in text Field (ID) 200 in text Field (amount), and then press button order.
I want it to be added with the previous Amount that have ID 2 Saved in the table.Means If previous amount that have ID 1 is 100
then the result after saving must be 300.

Posted 19-Jul-11 4:35am

sokkong

Add a Solution

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)

Richard MacCutchan · Answer 1 · 2011-07-19T09:53:00

Solution 1

This is a fairly basic piece of programming. Use the ID field from the text field to read your database record. Take the amount from the second text field and add it to the total and write the record back to the database.

Posted 19-Jul-11 9:53am

Richard MacCutchan

Comments

sokkong 20-Jul-11 23:51pm

do u have any code of this?

Richard MacCutchan 21-Jul-11 4:04am

If you cannot figure this out and write the code for yourself, or use Google to find a sample that you can modify to your requirements, then you really need to consider whether this is the right career path for you.