I have 14 values, that change constantly. I need to know how to check each value against each other to see if they are within 250 of each other. [code] I want these two values in the listbox to blink red in the list box. but i always want each value to check every value in the list box. i dont even know where to start short of programming each possibilty with a if than statement and that would take forever
View 1 RepliesI have a need to verify SSN's that are entered based on a reserved range (these are used for advertising and will never become valid). The input is from a masked text box formatted as 000-00-0000. I may be wrong, but I figured the most logical method would be to remove the hyphens and convert the string to an integer, then compare the starting point and end point of the range.
'Valid SSNs
'Currently, a valid SSN cannot have an area number between 734 and 749, or above 772, the highest area number which the Social Security Administration has allocated. This should not be confused with Tax Identification Numbers which include additional area numbers.
[Code] .....
I have the following error for every cell: "the number in this cell is formatted as text or preceded by an apostrophe" To duplicate the error: I have to store this results that come from a Web services as strings array: Sample: (3 by 3 array)
[Code]....
I have several records in a database that have Start and End Dates
09/15/2011 - 09/30/2011
10/15/2011 - 10/22/2011
11/01/2011 - 11/15/2011
When user stores a record, I need to make sure dates don't overlap.My simple code checks date ranges within a specific record (e.g. user enters 9/16/2011 or 10/21/2011, I throw an exception.)But, on the slim chance a user gets creative (e.g. 10/14/2011 - 10/23/2011 or even 10/14/2011 to 11/16/2011), now they have circumvented my check.BTW, the user could enter 10/14/2011 to 10/23/2011 if they were editing the record that contained values 10/15/2011 - 10/22/2011.So, I'm trying to solve this riddle with a linq query. However, what I have isn't working exactly right.
UPDATE Nevermind about code not working. While trying to provide an example to expand on Miika's repsonse, I found my answer. So, giving credit to Miika for pointing me in the right direction and posting my working code below:
Here's my code:
Private Sub CheckForOverlap(myMonth As Messages.MyMonth)
Dim am As New MyMonth()
Dim amCollection As Messages.MyMonthCollection
[code]....
I am new to writing Macro's. I need to know how can we separate individual values from a range (say 3-5, 0-4, 5-2 etc.)
View 2 Replieshow do i generate random double values between range, for example:value between 2.50 to 3.50?
View 7 RepliesI am coding a lottery number generator for a homework assignment. My project needs to have functions that return random values based on a range given. The first function I am coding is for a pick 3 lottery game.The function should return three random numbers between 1 and 9. I have coded the function but it only returns one number. When the debugger runs it says my function does not return a value on all codepaths.
[Code]...
Iam trying to Check Values Of 2 textboxex .. n then Print A certain Amount.
[Code]...
I'm trying to make a small program that helps cashiers to practice typing barcode on their machine. Barcode consists 12 numbers, and it can start with 0. Below are the code I worked on so far.
[Code]...
i'm trying to do a filename compare, sort of fuzzy match.Here's what code i have.First of all i load 2 directory's into 2 listbox's as strings and remove the filepath. Directory1
Code:
TextBox1.Text = FolderBrowserDialog1.SelectedPath
If TextBox1.Text = "" Then
Else
Then when i click the compare button i am trying to pass listbox1 and listbox2 through Distance and return the resulting fuzzy file matches.
Code:
Dim MyObject As New StringSift2
Dim ReturnVal As Single
ReturnVal = MyObject.Distance(ListBox1.SelectedItem, ListBox2.SelectedItem)
[code]....
But i get this error.
Code:
TreeView1.Nodes(lb1).Nodes.Add(ReturnVal.ToString())Specified argument was out of the range of valid values. Parameter name: index
I want to check if two combobox values are equal. The comboboxes are in a datagridview.I found you need to use datagridview_EditingControlShowing to add a handler to the comobo boxes for selectedindexchanged. I can do this with this code.
Code:
Private Sub dgridRegisters_EditingControlShowing(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewEditingControlShowingEventArgs) Handles dgridRegisters.EditingControlShowing
Dim combo As ComboBox = CType(e.Control, ComboBox)
[code]....
However, the message box comes up for every combobox in my datagrid when I change the index, not just the cmbPort2. I would like to have something like this...
If cmbPort1.selectedindex == cmbport2.selectedindex then
'do something
endif
..but it doesn't seem possible.
Im trying to check to see if a value of a label changes over time. however I can't seem to get it right.
dim val1 as string
dim val2 as string
private sub form1_load()
dim val1 = label1.text
end sub
[Code]...
problem is it will only check it once after ten seconds when the timer is set to 10 seconds i need to to check it every 10 seconds becuase these values display altitude, and if the server freezes the altitudes dont change. I need to make sure they are updated and not frozen.
I have a form where when the user clicks the button the values of the form are stored in SQL database. I want to write code in order to check if a specific textbox-value already exist in the database table (in the field "Name"). I 've tried writing something but it doesn't work properly.
View 2 Repliesam new to VB.NET and i was wondering if anyone here knows how to check for duplicate values in strings?
View 11 RepliesHow I could go about checking a typed value in a combo to the values in the combo box. I am making a system to select lockerID and Supplier ID I want the user to be able to enter the value in the combo box as well as select the value form the list in the combo box. Here is the code I have been trying.
If cboStockID.Text = "" And cboStockID.Text <> cboStockID.Items.ToString Then
MsgBox("Please enter Stock ID")
Exit Sub
ElseIf cboSupplierID.Text = "" Then
MsgBox("Please Enter Supplier ID")
Exit Sub
End If
I'm basically putting some validation logic around an undo button on my form and i'd like to check whether any fields on the form have had their values changed so i can ask the question "abandon changes?". This seems like something pretty standard to me but I can not see how to check whether a value has had its contents changed (without recording a before value and comparing it to the after value which for large forms would be quite horrendous to code).
In the language i used to use we used to walk the object tree (so we dont have to specify each object individually like text box, combo box etc) and check any object that have value-changed = yes to indicate the validation was required.
I have tried to solve this myself and I know I am probably doing something really silly here what I have is two different registry values that control what is displayed in the combobox on my form RegistryKey1 has the following values:0,1 or it does not existRegistryKey2 has the following values2,3, or 4 the combobox has the following values 0,1,2,3 However here is the problem if the RegistryKey2 is 2 then it further has to be checked if RegistryKey1 is either 0,1 or does not exist
if it is 1 then the selectedindex = 0
if it is 0 or does not exist then the selectedindex = 1
if RegistryKey2 is 3 then the selectedindex = 2
[code].....
as title says. and if it has the same values, delete one of them and add (2)
so itll be like: - before the filter:
[Code]....
Access database: Inventory
Column 1: Pprice
Column 2: Date
Now what I want to do is on a button click, I want to search the database for a date range, lets say September/01/2010 thru September/30/2010. Then I want to pull all of the Pprice values and add them together to come up with an inventory parts cost for the month.
I've mainly been recording keystrok macros... I created visual basic code that allows the user of a template to hide table gridlines - which works fine. The code to show gridlines does not work if the table has only one row. Here is the code - it is getting "stuck" on the
.LineWidth = wd
LineWidth050pt for a horizontal border, as there isn't one. I don't know how to change the code to not execute the command if a horizontal border line does not exist.
With Selection.tables(1)
With .Borders(wdBorderLeft)
.LineStyle = wdLineStyleSingle
.LineWidth = wdLineWidth050pt
.Color = 5592405
[Code] .....
I have a form where two fields on the first page of the form make up the primary key. I want to check for duplicate values before attempting to insert the record, since I don't want the user to go all the way through the form only to find out they can't submit it. So I'm trying to check for duplicate values when the user tries to go to the next page of the form. I wasn't quite sure how to do it, and sure enough I'm getting an error. ("Object reference not set to an instance of an object.") The problem is apparently in my if statement, "If myValue.Length > 0 Then", but I'm not sure what needs to be in place of that.
Protected Sub CustomValidator1_ServerValidate(ByVal source As Object, ByVal args As System.Web.UI.WebControls.ServerValidateEventArgs) Handles CustomValidator1.ServerValidate
'get values
[code].....
I have declared a class in VB.NET using VS2K5 with some shared variables and made that class a dllI made use of that dll in another project and tried to make use of those variables. Even though I can able to make use of them, Im unable to view the values of those variables like the values of normal variables when Im debugging. Is there any way that I can watch the values of those shared variables during debugging.
View 1 RepliesI have a DataGridView1 populated by sql searches. On the rare occasion that nothing is returned, my app cannot make use of data so I'm trying to check for null values. My code below is not correct because IsDBNull is not a member of the of the DataGridView1.
If DataGridView1.SelectedRows(0).IsDBNull Then
MsgBox("Nothing to display")
Exit Sub
End If
Basically I have a form which has 2 drop downs. In the 1st drop down I am selecting City category. When the city is selected I want to update the 2nd drop down values in correspondence to 1st value choosen in 1st drop down. I have done like this,This adds the value in the 1st Drop Down:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim s As String = "connection String"
sqlconn = New SqlConnection(s)
[code]....
I've never really used the Check List Box in the past, however, for the recent program I am developing, I am using this control rather than individual check boxes scattered across the form.Anyway, I want to be able to program through code which items get checked in this checked list box. Specifically, I have a variable that contains the text of each check box that I want checked.With a normal check box, I can simply say:
Dim strNames As String
strNames = "John Doe, Mark Johnson, Mike Brown, Cindy Smith"
If strNames.ToString.Contains("Mike Brown") Then[code]....
So I'm writing the equality operator overload (Operator =())for a custom object, and the resulting mess of If conditionals is just an eyesore. But so far, it seems like the only sane way to check the values to as to match the specific behavior of this object.
The rules are:Num1 is required, period, and both the left and right operands and must be equal for True. Else, False.Num2 is optional, but if specified, must be present for both the left and right operands, and must be equal for True. Else, False.Num3 is optional, but can only be specified if Num2 is also present. Else, False.Num3, if specified, must be present for both the left and right operands, and must be equal for True. Else, False.
[Code]..
I also know that I could cache elements of the checks into booleans and then use those to reduce the amount of text. But that seems like a waste of cycles just for code readability. So I wanted to know if the SO community had better thoughts on reorganizing it, just in case I'm being too verbose with my checks.
Per this UserControl that can be added to a blank form, I would like to use the HorizUnits array below to map custom grid x coordinate from a mouse x position.For a given input value 13, what syntax would I use to obtain a value of 2 where 13 lies between Value 10 and 16 for which 2 (Name) would be the custom grid's displayed coordinate position?
View 1 RepliesIm trying to write a program that will do:
1.The average of the four numbers. This answer will be placed into a text box reserved for that value. This text box cannot be changed by the user.
2.The maximum and minimum values. These will be denoted by changing the color of the largest number green and the smallest number red.
3.The range of the numbers. The range is defined as the difference between the largest and smallest numbers. The range will be placed into its own text box, labeled as such. This text box cannot be changed by the user."
Im using visual studio 2008 and it has to be written in VB
I am trying to copy the values to another sheet but not in any sequence eg.A1,B2,C4,D7 ........and so on. I am trying this slick way of doing it by the code below ( found on the web) without success so far but I got a feeling I am close to the solution. I am new to any kind of Programming. This is my first attempt. (so a chuckle or two is ok after seeing my "difficult" problem)
(This is an excel VBA Prblem)
Sub justdoit()
Dim s As Variant
[code].....
How do i read through a textfile line by line checking for and removing duplicate values?
View 1 Replies