I am working in Visual Basic 2010 Express and have a table with 3 columns created using a SQL dataset called 'test' if you like.The table columns are called A B and C If someone enters a value of 10 in A and 15 in B, is it possible for column C to automatically add them up and come up with 25? - if so how do I start?The above is only a simple example of the problem I have, but once on the right track I am sure I can apply the same logic to the table I actually have?
I have an Access database that has thousands of records. The fields in the database are EMPID, FIRST, LAST, JOBTYPE and PAGES. I would like to know how to loop through the database and for each individual EMPID to calculate the sum of the PAGES foreach JOBTYPE. There are four JOBTYPE's: "E", "K", "O" and "R".
I have an Access database that has thousands of records. The fields in the database are EMPID, FIRST, LAST, JOBTYPE and PAGES. I would like to know how to loop through the data table and for each individual EMPID to calculate the sum of the PAGES for each JOBTYPE.There are four JOBTYPE's: "E", "K", "O" and "R".Here is some
Dim WebAllEmployeeQuery As String = _ "SELECT ELPallEmployees.[EMPID], ELPallEmployees.[FIRST], ELPallEmployees.[Last], ELPallEmployees.[JOBTYPE],
OK, so my accumulator is now adding and showing properly in the form as a total. However, something is wrong in my if... then statement and it's not throwing it to the 2nd level after reaching the 125.*Edit to show updated with the Do While Loop. Now causing issues with my input error msgbox... *
do while decTotalCredits < 125 If IsNumeric(txtCredit.Text) Then ' This statement will convert the string entered to decimal and establish the
I seem to occasionally find myself trying to compare two List(of T) to see whether or not they contain the same elements. A quick check of the documentation shows the SequenceEquals method, but that appears to check whether the two lists have the same length, and have the same elements in the same order. I don't care about the order. I want to know whether two collections have the same elements. Doing this is not terribly difficult, and seems common enough, so I was expecting that there would be some function that handles it.
I have a database (SQL Server 2008) with multiple tables and records. 1 Table contains all kinds of invoice items, which have a unique id, Client ID and invoice number.
My goals is as following: - I want to show the invoice items in an datagrid, all merged as 1 invoice item (showing date, total without VAT, total with VAT, VAT percentage, VAT value and if the invoice has been paid or not.) - The datagrid should only contain the invoices for a specific client. - Should add up totals (Amount paid, Amount not paid, Amount Overdue, Total Amount) - Should be withing specific date range.
Everything in this table has been saved as varchar except invoice id and unique.
I'm trying to make a program that uses Ohms circle to calculate varying data regarding electricity, I think that if you look at my code you'll get a good idea. The problem that I'm having is that I'm using On Error Resume Next so the program will automatically find the valid calculation to calculate the value for the variable, but what's happening is that when it divides by zero (the default value for variables with no value) it gets Infinity, which it has decided IS a value, but I don't want it to be, I need a runtime error so it will bypass that calculation and go on to the next one.
'Skip erroneous statements and continue on to next line of valid code On Error Resume Next '-------------------------- 'VARIABLES '-------------------------- 'v = voltage [Code] .....
I'm writing a program for my class, which pretty much is an energy cost calculator. It takes 4 inputs from 4 text boxes and multiplies them, and the result is the cost. Well, now I have to come up with a way to check for empty text boxes and display a prompt to enter a number. I've tried inserting multiple codes to display a prompt and to no avail nothing has worked, I also receive the error "when casting from a number, the value must be a number less than infinity" error.
It's being some years since i actually wrote a program in VB, last time was VB 6.So it's being a long time, and things have changed a bit.And i am still very rusty, so i need to get back into it.I got a few problems which i cant remember very well.1st question.I got several text boxes, in these text boxes there will be prices of products.The very last text box is inactive, and is supposed to show the total of all of the above.I have to declare the text boxes to contain numeric values only, so there will be no mistake when doing the calculations.But i cant remember what it was, and what the best option is to add up all the values from the text boxes.
Which is the most efficient and speedy data structure in order to carry out calculations on it?. I have seen, collections, arrays, list arrays, databases and more. I would prefer to write just straight forward code that will be effective and which I can still understand. What I would like to do initially is have the ability to add new draws to the end of the file, edit the individual files and delete lines if required.
File would then be reformatted to show the corrections made. Some kind of data entry window is envisioned. As far as number crunching goes, I would like to make counts of each number in each of the columns , calculating averages, times since last drawn and so on.
Without being too long winded, I would eventually like to find triple combinations and maybe use them as predictions. So there you have it. This way I won�t have to go off on the wrong path, on a data structure that may not be able, or be too slow for the tasks at hand.
This is the Project that i have to make. Create a project that will input an employees sales and calculate the gross pay, deductions, and net pay. Each employee will receive a base pay of $900 plus a sale commission of 6% of sales.
After calculating the net pay, calculate the budget amount for each category based on the percentages given in the tables below:
Your Form should use text boxes to input the employees name and the amount of the sales and also use text boxes to display the results of the calculations. Provide buttons for Calculate, Clear, and Exit. Display a message to the user for any bad input data. Now i want to know for constants its going to be : commission sale, deductions and everything in Budget? I am also guessing that for the gross pay its going to be the" Gross pay = base pay * Commission" ?
I have 1 access database with 3 tables How do I make the combobox get data from one table and input it to another table?ex.I have a table with all my Carriers and another table with jobs that are assigned to Carriers?
I do this in Oracle databases just in a snap, but now I have to do it in VB using ADODB and I don't know how to do it.
I have two Access 2007 tables. Table A contains: Col1 (text), Col2 (text), Col3(date), Col4(amount), Col5(text)
Table B contains Col1(date), Col2(amount) What I need to do is to insert into table B the records of table A (col4 summed) grouped by date of table A. The date is a variable contained in a text box so it cannot be hardcoded into the SQL statement.
I have a DataGridView which displays info from a Database. I need a couple of the columns to be able to do basic calculations such as +, - etc - nothing more complicated really. I am a bit stuck as to how to gte this working.I have tried the code below with no joy:[code...]
I am doing homework, but i've done the work already. My Issue is, I cannot get my program to compile the calculations for the payments properly. Maybe I'm just too tired to see it, but It should be working from my view. Here is what i have so far...
Module MortageCalculatorWK5 'Loan Amount Input Dim LoanAmount As Decimal = 200000
I'm very new to programing and am having problems trying to perform some calculations with a list. I have read in an array into a list with a count attached to each item example: "xxxxxx(intcount)". What I'm trying to do it use two xxxxxx(intcount)'s at xxxxxx(intcount+5) and xxxxxx(intcount+25) and use these two variables to calculate yyyyyy(intcount) but it isn't working. I understand this may be a stupid question but could someone please point me in the right direction.
I'm developing an app in which there's hundreds of different calculations involved and would like for my app's admins to be able to tweak these calculations by specifying the formulas.For example, my database table contains price and quantity. One of the columns 'X' might contain "(price * quantity) over the past 7 days". How can I allow my app's admins to change the calculation from "7 days" to "14 days"?
Is there some way to make calculations dynamic within VB.NET or do I have to rely on stored procedures and write some code to alter those procedure if a change is needed? What are the best practices in this type of a scenario?Ideally, I would like to use something similar to the "Tags" box used when posting questions on here to bring up the available fields and add mathematical operators in between them to perform calculations. It might be adding more complexity, but would be great if an existing calculation isn't overwritten so that it could be used in building a new formula.
i used this code to assign the brand dbs to a value of 200
[code]Private Sub xModelComboBox_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles xModelComboBox.SelectedIndexChanged If xModelComboBox.Text = "DBS" Then
I have to use some calculations now and then and sometimes those will give me inf, and sometimes they work, this makes my app very inaccurate...Now i dont know what is causing this, im not dividing zero so far i can see..
(3 + Math.Sqrt(5)) ^ ...
It works for single numbers, But how would i retrieve the ?double? of bigger numbers without getting INF?With bigger numbers i mean really big, like 1477014138.
i want to add calculations in 1 private function I have a textbox named lbldisplay.text when i enter a number.. the number is shown as a string so.. -private number1 as string when i press the button "+", "*", "-", or "/" the number1 must return into a double. So the number in the textbox is now a double.. so for example i press the + button, and i need to fill in a new number.. but this new number is also a string!
I cannot figure out why my calculation is not working. I am doing for 1 to 12 and it gives me 12 inputs but counts my entries as 13? What am I missing. If I change it to 0 to 11 same thing. I am not sure what the issue is, but I cannot see it, and am not sure where to look.I need to end up with 12 cycles through and intEntries to be 12.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'initialize accumulator Dim decEntries As Decimal[code].......
As part of an assignment, I need to add numbers which are displayed in a rich text box. The numbers are read from a text box. The user needs to be able to input the numbers as many times as possible. Since, the numbers all come from the same text box, I am unsure how to retain the old information and add the new information to it.Since I am not really able to make my point clear, I attach this picture: RTB.PNGAs you can see, I also have a problem with the heading repeating itself. Is there a way of forcing it to only appear the first time?Here is the
Private Sub AddMoreItemsToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AddMoreItemsToolStripMenuItem.Click 'Retrieve number from textboxes
I got a program I am working on. It does some calculations using quantity and price in such. Heres the calculation module. Private Sub calculations() If AdultsizeRadioButton1.Checked = True Then adulttotaldecimal = quantityinteger * adultpricedecimal * hoursinteger ElseIf ChildsizeRadioButton2.Checked = True Then childtotaldecimal = quantityinteger * childpricedecimal * hoursinteger [Code] .....
Ok, everything has worked when I display the information.... up until the accumprofitdecimal variable. When i display that value its NOT what it should be. For instance i'm putting in a quanity of 1 and an hour of 1 for an adult then for a child, the extended price comes out properly as $2.15 now the code accumprofitdecimal += extendedpricedecimal SHOULD add the extended price (2.15) to the accumulative total. but when i display the accum profit total it shows a number that makes zero sense... is accumprofitdecimal += extendedpricedecimal not correct code?
I have an older program that I wrote some time ago in VB then late updated for VB.Net. The program calculates the ephemerides of comets based on orbital elements downloaded from the Minor Planet Center website. I am now trying to make an iPhone/iPad application using the same idea and the same calculations. Unfortunately I am too new at objective-c that trying to convert the extensive calculations is proving quite difficult for me.
I am doing a diet program in VB.net and I have 3 forms which have food and drinks as text boxes which can be selected by the user! I have coded them to be sent to list boxes on another form called 'results'. How can I set it up so what is selected on each form is added to a list box then adds up the calories etc. form what the user selects. I have made a calculate total button to add whats in the list boxes and I need to show the results to the user! How would I go about coding how to do this?
I was working with a calculator i made.. and then i was thinking of making all my calculations to be displayed in the listbox..Here is my program for the calculator..
Public Class Form2 Dim Nm1, Nm2, nnn As Long Dim Opr As String Dim FF As Boolean = False
I am unable to get the correct calculations out of my variables. If I input say fgh2 and enter 5 for monthly sales everything displays fine. enter fbd2 and 5 for monthly sales again everything is fine I get a result of 10 but as soon as I deviate from that formula like ftp1 and 3 in the monthly sales textbox it comes back as 13 in the newCarLabel when it should be 3
Option Explicit On Option Strict On Option Infer Off Public Class MainForm 'global variables