Member Avatar for Tito_3

i have a simple database where i want to sum Amount of one one text box at the footer of my form textbox. Am using access as the database

  • 4 Contributors
  • 8 Replies
  • 489 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by Minimalist
Member Avatar for Reverend Jim

And what part is giving you trouble?

Member Avatar for Tito_3

i want the text box in my footer to show grand total whener i add new record

Member Avatar for rproffitt

That's not the real problem. For VB, you could write an on change event handler that you sum it up and change the text box value as you wish. I often find folk struggling with this if they didn't complete a programming course or finish a book on programming in vb.net.

Answer: Use an on change event handler.

Member Avatar for Tito_3

are you helping or judging? i havent gone to a programming course just learning on myself

Member Avatar for rproffitt

Your choice. Now that I know you haven't completed eiither I hope you'll research the on change event and code that to do what you want.

Member Avatar for Reverend Jim

Typically, if you want to display multirow data from a database you use a DataGridView rather than a Textbox. I'm assuming multirow otherwise you wouldn't need to do a sum.

Member Avatar for Minimalist

O.K. I assume that you have added a totalsum row to your database which will give you a field that contains the total. If not then check this out:
https://www.gcflearnfree.org/access2016/how-to-create-calculated-fields-and-totals-rows/1/

To display this one field in your textbox you need a query against your database and display the result. Here is how to do this:
https://www.daniweb.com/programming/software-development/threads/461537/how-to-show-access-database-value-in-textbox

Edited by Minimalist
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.