Store Totals In Lines And Also Summed Total In Header?
May 20, 2010
I have the age old scenario where I have parent child related data. The child data contains many records with a cost field that goes into making the total cost on the parent record.
Is it good/bad practice to store the totals in the lines and also the summed total in the header?
The system will require that the child records be manipulated and therefore, the summed total will change. I also have a requirement where the summed total will need to be calculated and displayed on several forms and reports. I am able to code the system either way just wanted peoples opinion.
View 6 Replies
ADVERTISEMENT
Jan 29, 2012
How would i get this to work on a listview to count the total in the header colums called Cost.
This is a code for DataGridView how do i get it to work in listview?.
code
Dim index As Integer = 1 'column index
Dim total As Single = 0.0F
[Code].....
View 8 Replies
Dec 29, 2009
i wrote an application in VB.NET and since i charge by the line, i would like to calculate how many lines i wrote. i have about 100 different vb files with my code. how do i count all the lines?
View 8 Replies
Apr 15, 2012
I am trying to get the first store to calculate the total 5 payroll inputs but it is only calculating the first entry I am not sure what I am doing wrong. Also if I click on the cancel button in my inputbox it bombs.
Private Sub calcButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles calcButton.Click
' Dim storeTotal As Integer
' Dim store As Integer
[code]....
View 8 Replies
Mar 4, 2010
For the code below I get an error for the 1 to 5 part. It says end of statement expected. Is the way i've set out the syntax wrong, e.g the 1 to 5? [code] Also other than storing text to a rich text box what else can store numerical data in multiple lines?
View 6 Replies
Nov 24, 2011
this is the code working 100% for (merge , remove duplicate lines and Store ) two text file using vb.net Imports System.IO Public Class Form1
[Code]....
View 4 Replies
Jun 7, 2010
How do I code the total cost to give me a pound sign with the total cost at the moment when the total comes up for an example it gives me 3.6 when I need it to show £3.60 here is the code I have so far. [code]
View 2 Replies
Mar 22, 2012
I am coding a program that will allow the user to input 5 payrolls for Store 1, Store 2, and Store 3. The total of the 5 payrolls are then added together and shown in the respective Store's labels. A total label is also there to add up all the totals into one number. The numbers in the label must be in currency form. My problem is the numbers don't add correctly when I hit calculate. The first two numbers add together, but then after that the number just seems to subtract a random amount.
So far I have this --
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.Close()
End Sub
[CODE[...
View 14 Replies
Oct 6, 2010
The pay rates for the project are:
a. Level 1 - $10.00
b. Level 2 - $12.00
c. Level 3 - $14.00
d. Level 4 - $16.00
e. Benefit Deduction Rate - 0.10
f. Overtime Factor - 1.5
For ease of program maintenance, all of the above rates and factors must be stored in module level constants. All references to pay rates in the program must refer to the module level constants.
When the Calculate button is clicked:
a. The value in the Hours text box must be validated to insure that it is numeric value greater than zero.
1. If the value is not valid, a message box must appear as shown below and the user must be offered the option to continue processing or quit the program.
2. If the user chooses to continue processing, the focus must be set to the Hours text box.
3. If the user chooses to quit, the program must close immediately.
b. If the value is valid, the program must calculate and display the total pay in the Total Pay label.
1. The pay rate is determined by which Job Grade radio button is checked.
2. For hours less than or equal to 40, the total pay is the hours times the pay rate.
3. For hours greater than 40, the total pay is 40 hours times the pay rate plus the hours in excess of 40 hours times the pay rate times the Overtime Factor.
4. If the Full Time radio button is selected, the total pay must be reduced by the Benefit Deduction Rate.
5. The value displayed in the Total Pay label must be formatted with a dollar sign and with two decimal
places.
6. The focus must be set to the Hours text box.
Why i get an error when i try to run this code
Code:
Also the message box, both yes and no close the program.....
View 10 Replies
Oct 28, 2008
I am working with VB 2008. I want to be able to run this program say in N: and it will show me in an excel sheet the following:
Folder Path Size(GB) Count of Files
N:Clients 0.53 308
where clients contains subfolders and files and the size is the total of all those files within each folder and the count is the total within each folder also.
This works fine as it is but i have to select one by one the top level folders and some of them are huge so it takes forever to give me an answer.
1) I would like to see in my spreadsheet the following by only select the network drive n:
Folder Path Size(GB) Count of Files
N:Clients 0.53 308
N:Software 10.7 15430
N:Billing 0.98 105
2) I would also like to know if this is the faster method.
3) I tried adding a progress bar so that the user can have an idea of how much this will take but i had to remove because it was not working.
4) I would like to see the folder name, size of folder and count of files in the listview.
Here is the code:
Imports Microsoft
Imports Microsoft.Win32
Imports Microsoft.Win32.Registry
Imports System.Collections
[code].....
View 5 Replies
Sep 24, 2009
Is there a way to access the field header name of a databound repeater within the header template. So insted of this....
<HeaderTemplate>
<table >
<th ></th>
<th >Forename</th>
[code]....
View 3 Replies
Jun 8, 2011
I am using visual basic 2008 amd creatomg a datagrodview format like below [code] Now I wnat to get total balance in total column after less discount in percentage with ENTER EVENT proceedure and get the whole total column balance in a textbox i.e Net BalanceTextBox. Please tell me how to calculate discount in percent % and get total in total column and also tell me how to move cursor in next cell instead of bottom row in datagridview.
View 2 Replies
Apr 22, 2011
I have 3 columns in a unbound datagridview, "length" "height" and "Total". Total = length x width and the final total in TextBox outside of the Grid. I found question simalar in this forum and tried the code but i am getting errors.The following is the code i am using
Public
Class Form1
Dim UnboundColumn[code]...
View 5 Replies
Oct 21, 2009
I'm using the following code to populate a DataGridView with a worksheet. This is working fine, however, I'm unsure how I can get the Text from the page header. (not to be confused with the column header). Later in my code when I am exporting into an existing workbook with a new worksheet, I'm wanting to use the header text as the tab name. The header text being "September 2009" so that when I import/manipulate/export october, the new tab will be "October 2009" etc. [Code]
View 1 Replies
May 3, 2012
in my application i created table called houseloading which has field called housename.which is inserted into the sqlserver database. my table will look like this
///column name house
values red
green
what i want now is i want to display the values red green as column header in datagridview
which will look exactly like this
red green
View 1 Replies
Nov 21, 2009
I'm new to forums as well as new to VB 2008. I'm in process of making a order calculator which will total any values you selected in combo boxes/checkboxes and then display it in a selected area. There are 3 things that I want to achieve: 1. Be able to add another total to an existing total (currently I'm able to see only one total when I hit "Calculate" button)2. Display how many orders I have made so far (new total counts as one order)3. Be able to add up checkboxes selected to an overall total. (when I try to add up one checkbox with another it seems to be stuck on 1.5 pounds which I assigned for each "side order")
View 4 Replies
Apr 10, 2012
I have an assignment to create a website that people can use to make dinner reservations. We are using Visual Basic code for the forms. It's supposed to keep running totals of each type of dinner. I'm having trouble getting the running totals to not reset to zero. I have them declared outside of the button click event. Not sure where I went wrong. Here's the code:
Option Strict On
Partial Class _Default
Inherits System.Web.UI.Page
[Code]....
View 3 Replies
Nov 29, 2009
I have the program written and it is so close to functioning correctly, but a the end where I am trying to add the totals for the costs.
[Code]...
View 19 Replies
May 2, 2011
I have 10 Numericupdown boxes in my Form from numericupdown1 to numericupdown10. I would like to instantly display the total amount of all ten numericupdown in a Textbox (textbox1) on the form. I don't want to have to push a button to get the total value of the numericupdown boxes.
View 4 Replies
Apr 12, 2009
I have yet another question. I have set up a series of radioButtons to create a menu of choice for a class project and am trying to set it up so that there would hypothetically be a discount on a purchase of two or more t-shirts, I have the coding set up so that if any one item is checked and the calculate button is clicked, then the dollar value or "total" will show up, however I am not able to set up a total for more that one item, it clears the previous "total" and sets up a new total for the most recent t-shirt value checked.
[Code]...
View 4 Replies
Oct 28, 2010
Can anyone possibly take a look at my code (below) and tell me what I'm doing wrong? I have been sitting here for hours trying to figure it out. I'm very new at this and I'm thoroughly confused. I am using a book for Visual Studio "Programming in Visual Basic" and I have gone through all of the tutorials and code examples and followed them exactly (at least as far as I can tell). However, whenever I run the program, I am not getting the sum of the quantities I assigned to the constants showing up in"AccessoriesTxtBx" as I'm trying to. It shows up as $0.00 even when I have checked the boxes.[code]
View 4 Replies
Jun 14, 2010
How would you take a numerical input from 10 text boxes and total it up and send it to a label. Then average the 10 numeric text boxes and send it to its own label. I am not asking for any code, I just need a hint or two to jog my memory. If this is not clear for you, I'll provide more detail.
View 1 Replies
May 5, 2009
An ADOX (Access) database has five columns. ID, Date, Category, Store, Amount paid.It is possible to specify ten different items in the Category column: Apples, Oranges, etc.
View 3 Replies
Mar 27, 2010
I am very new to Visual basic. I don't know if I even have everything in the correct order. Here's my problem. I am trying to take user input on 3 input boxes, get discount from select case and then calculate out the following. My problem is I can get the code to do a simple addition, but If I try to do any calculation at all calling the discount I get an error where the output totals to zero. I don't know if I am missing something associated with the sub getDiscount() or if there is a problem elsewhere.Ultimately this is what I want my calculation to end up as.
First calculation
Price * Entered Input * Discount = Full Discount Value
Second Calculation
Price * Entered Value - Full Discount Value = Total
[Code]...
View 2 Replies
May 1, 2009
I've been working on a class project for quite a while, and I have not been able to figure out this step on my own. What I'm trying to do is connect the totals from three forms to a fourth page where I can then tally to those totals and then add 7% sales tax on the final total on the last page (I don't think I'll have a problem with the final part of add the 7% sales tax, but I'm not completely certain how to go about moving the totals through to that final form. Also, some of my forms use radiobuttons and one uses checkmark controls. I'm going to show some of the code that I have for each page in case this will make a difference. I think I need to do something with a public variable, but I'm not sure how to title that variable, and the public variable should have sub variable sections in each form, or if one specific public variable should be placed at the beginning of each form.I had also considering using a module to connect the totals in the forms together, because someone had suggested this, but I am not familiar at all with this method.
Code form1
Option Explicit On
Option Strict On
Option Infer Off
[code]....
View 6 Replies
Mar 8, 2011
I am trying to get the totals from a datagrid, the code that I have (does not work) is:
Dim currentRow As DataGridViewRow
Dim Thetotal As Double = 0
For Each currentRow In MyFITNESSSDataGridView.Rows
[Code]....
View 2 Replies
May 19, 2009
im doing a project ive got most of completed just for some reason its not calculating the totals?
View 1 Replies
Oct 13, 2010
this place looks pretty reliable and helpful so i thought i'd give it a shot.anyway, i'm a student looking for help. i have to write a program that calculates costs for a catering company. i have that part down, but whats stumping me is that i have to make a summary button that adds everything up into a grand total from the previous calculations and display it in a message box. displaying and calculations aren't really my issues, but getting the data to calculate is.
i have an idea of what to do i just don't know how to go about it. i know i have to store the data somewhere, but i dont' know how to keep adding it up so i can get a grand total, so i'm thinkin there needs to be something there to count.
[Code]...
View 2 Replies
Jul 21, 2011
how do I get the Header text of the header the user clicked in the datagridview.I know I have to use the column header click event but I can't work out or find away to extract the clicked header data?
View 4 Replies
Mar 29, 2011
Everything in my program is working correctly so far. The only problem I have is trying to update my totals for the program. I need to show total sales, total pay, and total commission for the program by using the file and then summary key. How the program works is that you get a base pay of $250 and you get a commission rate of .15 if you reach 1000 sales. I have done running totals before but not for one with multiple functions.
Option Strict On
Public Class CommissionForm
Const QuotaInteger As Integer = 1000
Const BASEPAYInteger As Integer = 250
Const COMMISSIONRATEDecimal As Decimal = 0.15D
[Code] ......
View 1 Replies
