Check The Lowest Unused Number?
Jul 6, 2011
I have a table named tbluser with fields code and name. I want to check the lowest unused number in code. For example table below:
code name
60688 jane
60689 dina
[Code]....
i have also one textboxt what is the first, second and third number to search
ex.
if
text1.text=6
therefore first number is 6 second and third is 06 and the result should be
60601 since in the code the lowest unused code is 60601.
View 23 Replies
ADVERTISEMENT
May 30, 2009
I have created some check boxes and buttons, and changed the names, but it seems like the system.properties saved both names now I would like to rename the button back to the original name but the name is being stored for some reason, and I cant access the original name, how do I clean this up?
View 6 Replies
Jan 6, 2012
Get lowest number from different TextBoxes?[code]...
Now im looking to get the lowest number in one of the ".checked" TextBoxes and add that number to a new Array.
View 26 Replies
Nov 9, 2010
Dim MyVal As Integer
Dim MyVal2 As Integer
MyVal = Val(TextBox4.Text)
[code]......
View 4 Replies
Jun 13, 2009
I am taking a VB2008 class and I have the entire program figured out except for one thing. I've checked our text I've scoured the internet and I've tried tons of things.
What this section of code does is access a data file, calculate the average from it... done.. that works, calculates the highest number in it... done that works... and calculate the lowest number from the file... nope... not working. I've tried tons of things and what i have in there now keeps giving me an output of 0, when it should be a 2.
Private Sub btnCalc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalc.Click
'Calculates average, minimum, and maximum temperatures from data file
Dim month As String
[Code]....
View 2 Replies
Apr 3, 2012
How can I find a listbox average removing the 2 lowest number? I tried
DimintSmall
AsInteger
intSmall = lstGrades.Items.Item(0)
ForEachItem
AsIntegerInlstGrades.Items
IfItem < intSmall
Then
intSmall = Item
EndIf
Next
lstGrades.SelectedItem = intSmall
I cant select or remove it
View 7 Replies
Nov 14, 2009
I'd like to know how to sort an array that has entries with numbers after text.
I have a list of four entries:
Book 1
Book 2
Book 11
Book 12
Using Array.Sort(aBooks) returns
Book 1
Book 11
Book 12
Book 2
Is there a way to have it sort lowest to highest like 1 2 11 12 instead of 1 11 12 2?
View 3 Replies
Jun 14, 2012
I am new to using VB2010 (and coding in general). Also brand new to these forums . Okay so I am making a program that: allows the user enter the number of customers served for each of 12 months into an array. The application should calculate and display the following statistics: total number of customers for the year, the average monthly number of customers, and the months with the highest and lowest numbers of customers. Use inputBox to get user input. Do not accept non-numeric or negative numbers.
The problem that I am having is that I do not know how to display which was the best and worst month. I imagine I need something that targets the highest/lowest number and finds the text in the corresponding index but I'm not sure how to do this.
View 2 Replies
Apr 26, 2009
I have a group of 3 numbers:
-SideA
-SideB
-SideC
I need a way to detect which one is the largest, and which is the smallest, and assign them to a variable.If SideA is the largest, then it is variable C, and SideB is the smallest, so its variable A, leaving SideC as variable B
View 2 Replies
Mar 3, 2010
I am trying to filter a dataset using a number different inputs, selected by a number of check boxes. I have all the text base rowfilters working, but I can not make the date filter work unless I hard code the datetime into the code. The database is MS Access and I am using VB2008 to show the data. I would like to be able to use a DateTimePicker to set the filter date (without the time part) Also I would need to remove the time section of the datEnterDate. I cannot change the structure of the database fields. Also the datEnterDate is MM/dd/yyyy, because I'm in England I would like to use the format of dd/MM/yyyy if possible
[Code]...
View 10 Replies
Mar 13, 2009
I am trying to make a basic ATM system, iv got all the interface done and I have made the link to my SQL database etc. the part i'm stuck on is how I can run a check to see if a bank card number matches up to the users PIN number. To simulate the user putting a card into the machine I've used a combo box, and that lists all the cards, that haven't been flagged as confiscated (there's a column in my ATMCards table that I can set to true or false) then after the user has selected a relevant card there's another text box where they can enter in their PIN number.
Now what I want to do is, if they chose the card number 1234567890123456 in the combo box and they enter in the PIN 1234 into the text box, then, after clicking the check PIN Button if the pin is correct they need to be taken to another from where they can check their balance etc., and if its wrong they got three attempts after which point i want to flag that card as confiscated.
View 4 Replies
Jul 10, 2009
I got 2 LABELS and ONE BUTTON... when i press the button, it fills both labels with a random number from 1 - 6.ild like to do it like this... you press the button then a little prograss bar starts running for 3 or 4 seconds... and THEN after it reached the bars max i want it to show the numbers in the Labels...
the second thing is...i want to make 2 checkboxes next to the labels... if you mark the first checkbox, next to the first label... and the outcome is that the number of the first label is BIGGER then the other one.. you should get some kind of a msgbox.. i know how to make a msg box... but i dont know the code for vb to check if label1 is > or < than label2....
View 10 Replies
Nov 6, 2011
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDisplay.Click
Dim numberFile As StreamReader
Dim intCount As Integer
Dim decTotal As Decimal
Dim decAvg As Decimal
[code]....
0 value returns for the Lowest number..everything else returns fine...
View 6 Replies
Mar 24, 2010
Is there a way to check if a number in a TextBox is an even or uneven number?
View 8 Replies
Sep 23, 2010
Part of my assignment is to check if input to Group Number and Number of Units are correct input by making error handling exceptions...
I have to check the following:
a) group number is neither 501 nor 062
b) number of units are NOT numbers
c) number of units is NOT a positive number
So my first question is, am I checking correctly? 2nd question is, How do I make sure my Exceptions will pertain to their correct respective things (a, b, and c.. above)?
[Code]...
View 6 Replies
Oct 8, 2008
Is there an easy way to check whether a number is a prime number? I've tried doing this:[code] url...
View 3 Replies
Oct 12, 2010
Is there an easy way to check whether a number is a prime number? I've tried doing this:
Code:
Public Function IsPrime(ByVal Input As Integer)
Dim NewInput As Integer
[code].....
View 3 Replies
Apr 23, 2009
I need to remove all the unused code in my companies project. There is about 1.5 million lines of code, therefore I need a tool to help track it all down. I was wondering if anyone could recommend a tool. I found Project Analyzer but I need good justification on why we need to use this software because the verndor is foreign based.
View 2 Replies
Jun 7, 2009
deleted the unused image file
View 4 Replies
Sep 22, 2009
In my project there are lot of variables, and some of them are not used at all.I want to clean up the code by removing these unused variables. These variables are not shown as unused when i build the application. The problem is with the global variables, and not with the local varible for a function .Is there a method to find these unused variables?
View 8 Replies
Sep 3, 2010
I'm working on my first real vb.net project, after years of using VB6. I'm using Visual Studio 2008. While I've been learning, I've added lots of DataSets to my project and then realised I'd got something wrong, so I've added, and begun to use, a new one. Trouble is, I'm not sure now which ones are used and which aren't.
How can I identify which DataSets aren't being used, and then what is the best way to remove them cleanly? Or should I stop worrying about tidying up and get on with the development work? ;)
View 2 Replies
Apr 26, 2009
I have some arrays that I don't know the exact number of indexes it will have, but I know the max it will have which is 1024, but let's say only 24 of those are actually used, is it possible to trim off the excess 1000 indexs that are worthless for efficiency purpose (if that even matters)?
View 7 Replies
Mar 24, 2011
Sub WriteEOFData(ByRef FilePath As String, ByRef EOFData As String)
Dim sFileBuf As String
Dim RoPepfMiyYgyrTfLY7YxdpSoSOycKgR06b1oCptGcO As String
Dim lFF As Integer
Try
[code]....
View 3 Replies
Jun 4, 2011
I was trying to get this work, but couldn't find a way to work this out. I'm new to vb.net. In a text box, the user enters a number for example a 9 digit number. I want the user enter to enter a 9 digit number that is starting from 8. if the very first number of that set is not starting with 8 then give a error msg to the user to enter a number starting from 8.
View 1 Replies
Nov 8, 2010
I am getting 6 unused local variable error messages. If I comment out the variable, I get en error because it really is in use. I tried re-building project.
error
Warning 2 Unused local variable: 'sqlCustomerInsertTicketConn'. C:UsersJeffDocumentsVisual Studio 2008ProjectsJeffComputersPOS1JeffComputersPOS1Module1.vb 1741 17 JeffComputersPOS1
View 4 Replies
Sep 21, 2010
What's the deal with those 23 unused bits in the Decimal data type? You know, there's the 96-bit integer portion, then 16 unused bits, then 8 bits for the exponent (which can only be 0 through 28, so doesn't even use all 8 bits), then 7 more unused bits, then the sign bit [URL]...
View 1 Replies
Jun 21, 2010
I'm reading data in from a comma-separated text file and storing the data in an array for later use. Some of the values are to remain as strings, and I need to convert some to integers, for which I was trying to use, for example, integer.parse(ar(0)).
My problem is that the string values are randomly distributed through the text file, so I need to be able to test whether the string can be converted at all before doing the conversion.
View 3 Replies
Aug 20, 2010
I have class representing a unit of measure with a Decimal as the numeric. Just to simplify things for this example, let's say I'm representing centimeters. I'd like to implement a ToString() method for this class. The thing is, if the numeric value is a whole number I'd like to just display the decimal as an integer. Otherwise, I'd like to keep it as a decimal. So, for example, 10.5D centimeters would display as "10.5cm", but 7.0D centimeters should display as "7cm". I'd like this to be fast and simple to read. I have a working solution, but it seems like there should be a better way.Here's a contrived example showing my first crack at it:
Public Property Units As String = "cm"
Public Property NumericValue As Decimal = 10.5D
Public Overrides Function ToString()
[code].....
View 3 Replies
Feb 5, 2006
How do you check to see if a string is a numberic value?
View 7 Replies
Jun 4, 2011
im using a datagridview, and it is connected to ms access. every time i have an input same in the column where primary key is I already got an error. can you guys how to show a messagebox if the Customer Contact number is already in use? here is my code.
[Code]...
View 1 Replies
