VB Program : Make An If Statement?
Dec 14, 2010
I am trying to make an If statement. I have 4 radio buttons
Part Time
Full Time
Part Time Temp
Full Time Temp.
I am calculating Fringe and Calucalted Funds.I also have 6 constants
Const PEIABasic_RATE_Decimal As Decimal = 5.06
Const PEIAFAMILY_RATE_Decimal As Decimal = 778.0
Const WORKERSCOMP_RATE_Decimal As Decimal = 0.0049D
[code]....
I have two text boxes where a user can enter the hours worked and hourly rate. and Salary rate. If a user clicks the Full time radio button the calculation for fringe should be FICA const * salary Works comp const * salary.Then u would add the fringe to the base salary. Part time the user needs to click the part time button along with another button, either TIAA or State REtierement.
If FullTimeTempButton.Checked & TIAARadioButton.Checked Then
FringeTextBox.Text = (FICA_RATE_Decimal * SalaryTextBox.Text) + (WORKERSCOMP_RATE_Decimal * SalaryTextBox.Text) + (TIAA_RATE_Decimal * SalaryTextBox.Text)
[code]....
View 12 Replies
ADVERTISEMENT
Jul 15, 2010
Is there a way to make a VB case statement evaluate all the cases? Similar to a java switch statement (without the break).
View 5 Replies
Jul 11, 2010
I'm building a listview search feature in my app. (See the code below). It works really well, except if you search "T" then the code removes all items, if you search "t" then it removes every item except for those starting with "t". Is there any way to make a 'like' statement, or use some kind of wildcard to make the statement not case sensitive?
For Each itm As ListViewItem In ListView2.Items
If itm.Text Like TextBox1.Text & "*" Or itm.SubItems.Item(1).Text Like TextBox1.Text & "*" Then
Else
[code].....
View 2 Replies
Feb 6, 2012
How do I insert an If Else Statement here when I want to display the studentID and loginID if there is no student name/address.[code]...
View 2 Replies
Jan 6, 2011
i have a query here run in SQL server 2008 which produces the error "Conversion from string "INSERT INTO Faculty (emp_id, lna" to type 'Double' is not valid."
"INSERT INTO Faculty (emp_id, lname, fname, mname, nickname, date_of_birth, place_of_birth, gender, address, civil_stat, contact_num, citizenship, e_add) VALUES ('" + enumm + "', '" + txtlname.Text + "', '" + txtfname.Text + "', '" + txtmname.Text + "', '" + txtnick.Text +
[code].....
View 4 Replies
Oct 7, 2009
I am using this code for my project. What I am not sure is that when I search on the net, they use the "@id" for the insert statement.[code]...
View 3 Replies
Oct 26, 2011
I want to make an if statement inside a button. So basically its this Private sub Button1_Click ....
If Button2.click then
blah blah blah
else if button3.click then
'blah blah blah
End If.
How would I do this because I can't seem to solve it with any code of mine, i searced through all the allowed values that vb offers and nothing ...
View 7 Replies
Jun 16, 2010
i want to make condition statement in my function. i use this method : [code]if i try to insert a data already in the database, the function will directly go to the updateDatabase()the problem is, if i try to insert the data that currently not in the database, the function will directly go to update database as well.
View 1 Replies
Feb 18, 2011
i need a update statement to make a record = 1 example : the colum what need to change is active and it must stand on 1 to show you in to a listview (that part works) but i need to do it manualy to make them active now i liked to when the login is a succes then the record = 1 for you this is my code :
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim adapt As MySqlDataAdapter
Dim sqlquer = ""
[code].....
i get this error : Object reference not set to an instance of an object.
View 8 Replies
May 2, 2011
i want to make crystal report of profit and loss statement i have a column of "vr_type" and there are 4 types in it "sale invoice", purchase invoice" now i want that put a 4 formula s where i select that "sum (vr_detail.debit) where vr_detail.vr_type} sale invoice it make Sum of al these types so kindly tell me what formula i should use to get the result in simply i want sum of sale,sum of purchase,sum of expense?
View 2 Replies
Sep 29, 2010
how do you make a statement that sets the focus to the txtPassword control?
View 1 Replies
Jul 12, 2010
I am trying to clean up my code a bit.
I made the following function:
Public Sub sqlUpdate(ByVal table As String, ByVal column As String, ByVal var1 As String, ByVal column1 As String, ByVal var2 As String)
Public CN As New MySqlConnection
Public cmd As New MySqlCommand
[CODE]...
Which is fine, if I want to use mysql update all I have to do is call something like: sqlUpdate("test", "test", 0, "test", test) I was wondering if I could do the same with the SELECT statement and make a function. I cant think of a way to do it though...
sqlConnect()
Dim cmd As New MySqlCommand
With cmd
.CommandText = "SELECT * FROM users WHERE username=""" & lblAccountName.Text & """"
[CODE]...
The data I would want to extract would be different every time.
View 3 Replies
Apr 11, 2012
I'm not quite sure why, but this program doesnt work as intended. It's kind of difficult to explain but if you tried it, it doesn't work properly.
Private Sub btnApply_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnApply.Click
'clears the changes box before going through if statements
Me.txtChange.Text = ""
[CODE]...
View 3 Replies
Mar 22, 2011
I have a form that contains multiple conditional or if statements on several defferent for controls.
Example: Radio Buttons, TextBoxes and CheckBoxes.
I am intending to create an order form(demo) where the user can select multiple products.
I have a default order number that changes by one everytime an order is successful.
An order is only successful if all the information on the form is entered correctly.
My question is where do I insert the code for the order number?
Basically for the order number I have a counter that count by increment of one if an order is successful.
Meaning when the user hit place order, and all the infromation is right, then the order numer goes to 1 from zero.
Where do I add the condition for the order number since all the fields must first be completed.
Do I have to create a whole line of if else statements?
View 5 Replies
Oct 1, 2010
I want to insert a record using SQL and one of the fields needs to contain a carriage return, [code]...
View 2 Replies
Apr 21, 2012
I have this sql statement to update a column in access db from vb but when I run the program it shows that there is a syntax error in the statement. [code]...
View 2 Replies
Feb 17, 2009
i am using vb/vb.net and the database is visual foxpro 6.0 then i want to create the tables from the application using sql statement.i need to add the number field into the table. i can not add the number field in the tableres.open "CREATE TABLE Customer ( CustName char(50), CustId int(2))",conXavier
View 2 Replies
Nov 9, 2011
Can i insert in two tables data with one insert statement in .net VB 2008?
View 1 Replies
May 11, 2009
[code] The problem in my case, this is not working with this code. All I need are random numbers outside the above boundaries.Please note when I remove 'Not' in 'Loop While' statement, the programme runs indefinitely!!
View 11 Replies
Jun 6, 2009
I cannot find a way to make a program that I write make a shortcut in the start menu for all users.My final goal is to make an MSI and deploy it in group policy to all users on a computers OU. Is this possible?
View 5 Replies
Aug 23, 2009
How do i make my button open a program and make it windows size?
View 6 Replies
Jan 6, 2012
End A statement which as far as i know doesn't close you program properly and hides errors. Right now i'm being forced to use end because i don't know how else to close my program properly. I'm not sure where my problem is but some of you should be able to fix it. I'm trying to make a game using directx with a game loop. This code is the skeleton of what i'm making.
Public Class Form1
Private ProgRunning As Boolean = True
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Me.Load
Me.Show() 'Make the form appear
Me.Focus() 'Give the form focus
[CODE]...
This code runs alright because end is being used but if you rem end out the error which it's hiding comes out. The error is "Object reference not set to an instance of an object." I'm not totally sure but i'm guessing that the error is refering to the form.
View 9 Replies
Feb 25, 2010
If e.CommandLine.Count > 0 Then
Dim IncomingCommand As String = e.CommandLine.Item(0).ToString
If IncomingCommand.Substring(0, 2) = "-1" Then
form1.close()
End If
End If
I am trying to make the program close if the -1 string is sent with the program. See my installer allows for me to run certain programs before it actually installs, but it doesn't shut down copies of the program itself. So I have a next startup instance set to shut the program down if the -1 is received. But if the program is not running it starts up instead. This is not desired. form1.close doesn't work. e.cancel = true doesn't work, etc etc. What can I do to make the program not start during this instance.
View 1 Replies
Jun 1, 2010
I made vb.net program for 1440x900 resolution, if i run my program on 800x600 or 1024x768, my program's resolution is bigger then windows, so i have problem with resolution. Now i want to change my program's size and i am interested in, wich resolution is correct to make program, 800x600 such as minimum?
View 9 Replies
Aug 26, 2009
How do I make a program that opens a file in the folder the program is stored?
View 6 Replies
Apr 3, 2010
I want to make a program that searches for a RGB color and clicks on it, WITHIN the program.
View 2 Replies
Dec 30, 2010
what im trying to do= make a program that will make multiple accounts
[code]...
ok what i type in textbox(es) "1" i want it typed on a "3"{a website=www.justin.tv/signup} when i hit the "2"[button1]i really dont have any idea what im doing i know ill need to have a webrowser to load the justin.tv/signup but i have no clue what the name of the boxes are called on the webpage
View 4 Replies
Jun 9, 2011
Me and a friend are making an app which we need to play a sound when Form1 is started. How do we do this? I don't mind code.
View 2 Replies
Aug 15, 2011
How to make a computerized examination program using vb.net...
View 1 Replies
Oct 4, 2009
I am new the Visual Basic and just downloaded 2008, and I am wanting to make a program with a button that will run a .exe that is in the same location as the program/
View 2 Replies
