i have a question on how to add two values of placeholder on different forms. in the forms i put a placeholder for "correct answer" and "wrong answer" so one of this placeholder will have a value of integer. how can i add a value on the first form to the other placeholder of the other form.
View 5 RepliesI am currently building a mortgage application and currently have two forms, the way the system works so far is the user selects an option from a series of radio buttons whilst a score is kept based on the options chosen, this is then displayed in a text box to the user, on the second form there are more choices, and a textbox to display the final score, what I can't figure out is how to get the value from form one to the textbox on form two when the user clicks next on form1 to get to form 2.
View 3 RepliesI have a groupbox with a number of textboxes. I want to loop through all the textboxes, get their value( text) and add them all together and show it in a final totaltextbox outside the groupbox. This is what i have done but it does not work. The totaltextbox values do not change. Here is my code :
Private Sub AGroupBox_VisibleChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles AGroupBox.VisibleChanged
Dim xxx As Integer
[Code].....
When calculating currencies in textboxes and labels, what's the best way to go about it?As it appears the $ sign and the , presents a problem when calculating.I thought it best to create a variable without those items when doing the calculation.
View 9 RepliesIm trying to calculate TextBox values, but asnwer = 0. I think strings are too big/long.
Example : TextBox1.Text is 0.2777777777 and TextBox2.text = 60
TextBox3.text = Val(TextBox1.Text) * Val(TextBox2.text)
then TextBox3 Text is 0.
[code]i need to calculate the item on my datagrid(gallon_qty) but im receiving the error when running it
View 1 RepliesI have to calculate values of several equations in an application. For example, one these equations could be:
d = a + b*z + c*z (this is what is being displayed to the user, assume that 'a', 'b' and 'c' are provided as textboxes, assume that z is a hardcoded value for now)
Now, the user could enter a=1.5, b= -0.5 and c = -0.6 (or even 'a' could be negative). So, I just tried a sample code for simple values but to no avail...
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Dim val1, val2, val3_calculated, first, second As String
first = "8"
second = "3"
Dim arr(10) As String
[Code] .....
Error:
But it throws an error saying that I am not using any databind control.
Concerns:
First of all, is it necessary to use this "eval" operator in here? Is there any way to keep "-0.5" with the sign in asp.net using vb?
With the application i'm building i have to do some calculating, ive so far not had to do anything like this so i could use some pointers. Here's the simplist of calculation i have to do, if i could get some help pointing me in the right direction i could probabaly figure the rest out.
It would be Box1value * box2value / 144 = box3 But if box 3 returns a value of less than 2.5 it rounds up. The rounding function is very important to subsequent calculations i will have to make.
So the this simple form would work where the user inputs a number into box one and two and the calulation appears in box 3. Attached is a mockup of the form design.
I am making this for a homework assignment and i need to calculate the average for values entered in textbox1 and place them in other textboxes. I dont understand how to do this with numbers all placed in the same spot. here is my code thus far:
Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click
End Sub
[Code].....
I have one text box that contains a value for the "Start Time" and another text box that contains a value for the "End Time."Both of the values are expressed in a format for military time (i.e. 1200, 1300, 1430, etc.).When the "End Time" text box loses focus, I would like the "Elasped Time" (expressed in minutes) to appear in a third text box.Seems easy enough...right?Well the problem I'm having is since the first two numbers in military time are base 24 and the last two numbers are base 60, a standard calculation subtracting the "End Time" from the "Start Time" does not yield an accurate result.
View 3 RepliesI have a monthly forecast showing expense accounts by cost centre so columns headings look like:
Cost Centre, Account Number, Jan, Feb, Mar etc
Using VBA code to automate the process, I need to calculate the total for each month of each account number where the 2 left characters of the cost centre are the same. I have a formula which will calculate this (for one cost centre grouping/account) which looks like this:
=SUMPRODUCT((LEFT('Sheet2'!A6:A5136,2)="BE")*('Sheet2'!C6:C5136=AccountNumber)*('Sheet2'!D6:D5136))
I am not sure whether there is a more efficient way than using a formula like that (at the moment this would be used for 12 months on about 6 cost centre groupings with about 500 accounts each - though this would vary). Its not massive, but could be slow to calculate. I don't think the subtotals command is powerful enough, and I haven't used arrays for a long time (especially for what would appear to need a dynamic, mulch-dimensional array).
I try to calculate some values that I have stored in textboxes..I made 2 variables as double and tried theese two lines of code.
View 2 RepliesIm just wondering if some one can take a look at my insert statement, as is not working,
Im trying to add values to SQL from 4 textboxes. Public Sub Insert(ByVal textbox3, ByVal textbox4, ByVal textbox5, ByVal textbox6)
Dim conn As New SqlConnection
Dim comm As New SqlCommand
conn = New SqlConnection("Server=Scott-VaioSQLSERVER;Database=Testing;Trusted_Connection=True;")
conn.Open()
[Code]...
how to INSERT FROM in vb.net if you are getting values from textboxes?
View 2 Repliesi have a textbox where i get numbers by looping...i get 1,2,3,4,12,345,32 and 67..
but i get only 67 in textbox..i want to add all the numbers and display the result at the end...
[CODE...]
how can i add after each loop.
Iam trying to Check Values Of 2 textboxex .. n then Print A certain Amount.
[Code]...
i am having trouble with the inserting of new values though the textboxes. it gives me the error Syntax error in INSERT INTO statement., OLE DBEXCEPTION was unhandled at da.Update(ds,[code]
View 1 RepliesI have 10 text boxes and I'm trying to create an array to store the values entered by the user, I then need to add the totals of all of them, get the average, highest and smallest of all the 10 values entered by the user?
Public Class frmNumberAnalysis
Dim tbArray(9) As TextBox
Private Sub btnCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click
[code].....
I started editing an existing code (basicaly to learn vb) without any real previou experience. Well let's get to the point; I have a form that gathers data from db ordering by user ID (on click count). I have one DataGridView with a list of user, some have data in db, some have not. I came so far that if I CLICK on a user that have data, all data is dissplayed in 6 dinamyc textboxes. If user has no data inly first (emty) row with 6 dinamyc textboxes is created.
Then I have a button that simultaneously adds a row of dinamyc textboxes bellow and multiplyies textbox04 (name is clickcount & 4) and textbox05 and displays the result in textbox06. I want to add a messagebox that shows if textbox04 & 05 are empty and in that case exits sub. Of course if they are not empty, their sum should be multiplyed in textbox06 (on 2 decimal places exact) Here is my code so far:
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Reset warnings
[Code].....
I have 2 textboxes where the values are filled with this code(the data is collected from 2 different
[Code]...
When I now tries to update the data in the box743 i get an error. Who says that I can not convert the strng to double.I use the tableadapter to update the database and both box498 and box518 updates without problems.But when I try to upgrade the 743 box I get the error.
if i have 10 textboxes on my form with numbers inside 5 of them have the number "0" other 5 lets say 100 50 40 30 10 i need to get the smallest value but not the "0".
View 2 RepliesI have textboxes which is placed inside accordian (ajax control).In pageload event i have written the code to load values in textboxes. But onload event one error is coming as object not set to instance of a object. Values are not coming in textboxes.
Then i tried to initialize controls in textboxes .Then the error cleared. But
Values are not coming in textboxes. What may be the reason for this?
If i have multiple textboxes with the same Id and name in a form, how to fetch there values separately in vb.net? in javascript iv used fetched them like this
[Code]...
if textbox1.text =S1, S2 then on button click event the S1 and S2 column value of Table in MSSql2005 database will be updated with the value "b" where date=1/3/2012
But the update is not working...
My MSSQL2005 Database structure :
id date S1 S2 S3
1 1/3/2012 b b NULL
How do i get data from a database and put it in to multiple text boxes?Basically i have abilling form with; name, address, etc.But i have a 'retrieve' function underneath which allows a name and post code to be entered and then the information above is automatically filled in if the name and post code exists. At the moment i just setup a connection with the variables. not sure how to do the rest
objCommand.Connection = objConnect
objCommand.CommandType = Data.CommandType.Text
objCommand.CommandText = "SELECT CustomerName FROM Customer WHERE CustomerName = @CustomerName AND PostCode = @PostCode"
[code]....
This is my first time joining a site like this and I'm trying to learn vb .net. Im very new to the concepts and this was my last resort because I cant find the answer im looking for. Below is my code, and all I want to do is display the calculated resaults in a summary. Weather it be a message box or a diffrent form it really doesnt matter.[code]...
View 2 RepliesHow can we multiply the values of the text boxes(reportitems) in rdlc report?
Ex. The expression of TextBoxResult report item is:
=Reportitems!TextBoxPrice.Value * Reportitems!TextBoxQuantity.Value
I have two text boxes that i divide together and i get a answer of 0.434931506 i want it to be 43 as a whole number or say 43.49.[code]
View 10 RepliesI am trying to create a form that adds two text boxes together, I have achieved this however when running the program if you forget to enter numbers in both boxes the program crashes! I don't want to display an error message I just want the program to ignore empty boxes.
View 10 RepliesI am using VB2008 now, couple of simple questions.
1) Is there some way to limit what my user puts in their textbox to numbers only? Or is there some way to check afterwards that the string only contains numbers and delete it if it contains anything else?
2) How to open a file, save the values of 5 text boxes into the file and then close the file?