Calculator in Form

[sisterpete]

working with a database at our food ministry.

I have a button to call up the windows calculator, but i would like to have it as part of the form... or better yet (maybe) go to the income field, have a drop down calculator that would input the total

normally we have only one income so no big deal, but several times we have multiple incomes from a family, that we have to total, so we open the calculator, add them up and then manually input the total in the income field.

thanks for any input....

 

[ghudson]

I believe their is a calculator form in the samples section. If not, search the forum for I have seen previous threads asking for what you want.

 

[PNGBill]

Could you add 2 or 3 extra unbound text boxes to your form with labels "Income1", Income2" etc. Type in the incomes and either the last text box will sum the others or if possible, the text box you would have entered the total in has the sum.
Following on, why not just enter the data into the new text box or boxes and the sum is what the form will pickup.

This assumes you only need simple addition on your calculator. Multiplication will also work but you don't want to have 20 new text boxes all over your form.

 

[sisterpete]

Could you add 2 or 3 extra unbound text boxes to your form with labels "Income1", Income2" etc. Type in the incomes and either the last text box will sum the others or if possible, the text box you would have entered the total in has the sum.
Following on, why not just enter the data into the new text box or boxes and the sum is what the form will pickup.

This assumes you only need simple addition on your calculator. Multiplication will also work but you don't want to have 20 new text boxes all over your form.

not really what i was hoping for, but sounds like it would work fine... i'll give it a try... thank you...

 

[vbaInet]

As ghudson mentioned, search the Sample Databases section and you will find sample databases for this purpose.

http://www.access-programmers.co.uk/forums/search.php?searchid=6612665

The search keyword was simply "Calculator" under the Sample Databses section.

 

[AccessBlaster]

sisterpete,

Have a look at this small popup.

http://www.mvps.org/access/downloads/calc.zip