VS 2008 : Don't Use Int() To Truncate Numbers
Oct 4, 2009
I've been using it and even saw a method in a MSDN search given that suggests that it should be used but have found that there are defects using it. An example of problem occurring.
Dim db As Double
db = Int(10.12 * 100) / 100
db should be equal to 10.12 but the result you get will be 10.11. In the above example nothing is being truncated. If you added some digits right of the 2 it would give a good result. But if you're using a variable and it sometimes is equal to 10.12 or 9.12 etc. then a problem would occur. Also if 10.12 was replaced with 10.03 you'd get a result of 10.02. 10.04 gives a result of 10.03. 10.2 gives a result of 10.19. I'm now using code such as what is seen below instead of using Int() :
bd = Decimal.Truncate(CDec(10.12 * 100)) / 100
You could declare bd as a Decimal and then you wouldn't have to use CDec(). If I try Int(1012) the result is 1012 but Int(10.12 * 100) will give 1011. Pretty weird in my opinion.
View 5 Replies
ADVERTISEMENT
Mar 5, 2009
Using tabs for my web browser, I noticed (since im using documenttitle to populate the tab text) if a site has a long title, it will extend my tab var far, how can i limit this to a certain amount of text?
tab text code it:
TabControl1.SelectedTab.Text = CType(TabControl1.SelectedTab.Controls.Item(0), WebBrowser).DocumentTitle
View 1 Replies
Mar 28, 2010
how can i add two excel sheets with numbers and the equal (similar)numbers to save once
View 1 Replies
Jun 22, 2010
[TEX]Hello[/TEX] How do i use truncate in vb 2008?my database its in Access and i want to implement a truncate table in vb but i don't know how to do it.
View 1 Replies
Sep 3, 2009
is there a simple way to truncate an array ? Something like placing an end characted in the array which would signify its end ?
Basically I have two arrays of slightly different sizes and I want to shorten them so they both have the same size. The end data I am truncating I don't need.
View 4 Replies
May 19, 2010
how to truncate my string value to 17 characters only.
in my program, the acceptable number of characters for First Name is 17. Characters more than 17 should be truncated but it may cut words in the middle. I need to make the length max 17 characters, but, if it cuts a word, it should also remove this half-word completely.
View 7 Replies
Feb 24, 2010
I have an VB.NET app that writes the status to a log file in text format. Over time, the file is getting large and I wanted to know if there is an efficient way to truncate the beginning of the file.
To make things easier, I am looking to specify a file size (say 2-3 mb) and I am writing the log using a StreamWriter:
Using strm As New IO.StreamWriter(filelocation.log, True)
strm.WriteLine("msg to write")
strm.Close()
End Using
I thought about using the strm.BaseStream.Length to determine how much of the file to cut off, but by using the .SetLength it would cut from the end - not the desired result.
View 4 Replies
May 3, 2009
How can I "truncate" a DateTime variable so that only e.g. the current minute remains?
Like in:
Dim myDateTime As DateTime
myDateTime = Now
.... (what would have to come here)
If Now is e.g. 15:43:21 then leave only 15:43:00 in the variable?
View 3 Replies
Feb 25, 2008
I've been trying to find a solution to this problem all morning.This is what I have: 1 comboBox control,autofilled from SQL table [code]...
View 6 Replies
Jun 2, 2009
well i am truing 2 make a button when i click it would truncate the data in table , i am trying 2 do this by vb.net 2005.
View 5 Replies
Jan 13, 2010
i want to set a complex column expression truncate(cdbl(Today()-date2)/30)*(parent(parentchild).field1/parent(parentchild(filed2)))but truncate function is not available !
View 12 Replies
May 2, 2011
Im trying to truncate lines in a .txt file from 19chars to 13chars. Then copy the .txt file to another location and rename the extension to .lst. As below... Iam having issue with getting it to write the truncated number to the new txt file. Its some how returning a Null referance & i cant work out why??
Imports System.IO
Public Class Form1
Sub ProcessFile(ByVal SourceFile As String, ByVal DestFile As String)
[code].....
View 3 Replies
Feb 14, 2012
I wrote a loop that posted an accrued principal cycle to a listbox for a period of 10 years (10 loop cycles). The problem is: not only does the amount of the principal reconfigure for each loop cycle, but it does not truncate into a two decimal place holder as it should. I would like to use the ("F2") but I am not sure where to put it within the code. Here is what I have for the Calculate button event handler.
[Code]...
View 2 Replies
Sep 4, 2010
The RX data from the serial port is as follows:
FE FE FA E0 00 23 45 FD
I need to truncate everything else and just have positions 5, 6 and 7 output in the hex in a TEXTBOX. See below:
452300
Instead it will put the the whole steam in the textbox and it will be in decimal format, not hex.
View 3 Replies
Jun 2, 2011
How to delete multiple rows in a single table i used "truncate" command.
This is my code for deleting:
Private Sub tranc()
Try
Dim dbconn As OleDbConnection
Dim dbcom As New OleDbCommand
dbconn = New OleDbConnection(cnnstring())
[CODE]...
I used access database on it. when i run my prog. i got this error "Invalid SQL statement; expected 'delete','insert.... or 'update'.
View 1 Replies
Jun 21, 2010
I have six textboxes, and upon button press it randomly generates six numbers, one in eact text box e.g. [43] [85] [93] [1] [0] [17]..i create another six textboxes and at the same time allocate these numbers in ascending/descending numbers.I am not looking for any codes whatsoever, as i love the challenge of VB.Net.
View 2 Replies
Apr 7, 2009
Im 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
View 35 Replies
Aug 16, 2009
So how would I use .next (random numbers) to randomly select something from a list of numbers but it can't repeat the number?I could do:
dim num as integer
dim r as new random
num = r.next(1,5)
if num = 1 then
elseif num = 2 then
etc.
That wouldn't work because it would repeat.If I donwload someone's game can I disect it in VS? :0 I tried going to open project, then I went to the folder and clicked open. It brought me inside of the folder so I tried to open the game but there is no form1 there. It says the games name then .exe in the explorer-like thing in the top right?Also, how would I have a value or something in a label and access it from a button.
Example:This is in a label.
Dim number as Integer
number = 0
Then in the button do
Label.number = 0
How would I do something like that? I want to use that a lot as I did in a different language.
View 6 Replies
Mar 18, 2011
I have a program that allows a user to input numbers from an inputbox and it displays the Total numbers entered, the sum of the numbers entered, and the average of the numbers entered. What I can not seem to find it how to have it display the largest number entered. The code I have so far is,
[Code]...
View 11 Replies
Oct 4, 2011
I am making a program, where the user enters 6 numbers in 6 different text boxes, and it displays the larger of those 6 numbers. But I also want to make it where if the user enters a string value (like S for instance) in the text boxes, it gives an message and says "please enter the numbers again" and the user gets to enter the 6 numbers again. But when I do try to do that, it gives an error message saying conversion from "w/e the user entered" to Double is not valid. If the user just enters the numbers, it works fine. However, I am trying to make it if the user does enter non numeric value, it gives a message window and the user can reenter the numbers again.
Here is my code Example
CODE:
This is where I am trying to use IsNumeric to show a message if a user does not enter a string so the user can renter the numbers again, but when the user does enter a string value (say in textbox 1) it gives me an error message saying conversion from "S" to 'double' is not valid.
CODE:
Then right here this is where I have my series of ifs statements, this part works fine, it displays the largest numbers of the 6 textboxes every time. Error free.
CODE:
And do this with variable number 2, 3, 4, 5.
I know there are easier ways to do these with arrays and stuff. But I am not there yet. I am still learning about ifs and stuff.
View 8 Replies
Mar 6, 2011
I have just about completed a .NET project to write a program to randomly select numbers for a Bingo caller. Over the last month or so Ive learned a lot about .NET but heres something that I consider to be odd and maybe one of you guys can offer an opinion.
One of the features of calling Bingo in a small local club is that callers often use little sayings to accompany certain numbers, I expect youve all heard of (say) All the sixes, clickety click for 66 or 5 and 9 the Brighton line for 59 etc. My little program gives an option to incorporate these with a prompt for the caller that can be edited outside of the program. One of these conventional sayings is used when a number is reversed 12 followed by 21 or 45 followed by 54 for example, when the caller might call (say) 1 and 2, one dozen, number 12 And the other way round 2 and 1, twenty one.
So, I programmed in a bit of code to detect this and to over-ride whatever might otherwise have been the quote with And the other way round and set about testing it. Ive been through literally dozens of full 90 calls watching for the occurrence of a reversed number, spent a few hours doing it, and not once has it occurred which is to say the least, unusual.
So, Im wondering about the Rand Function, could it be that it isnt possible for a reversed number to be selected? Just so you know, I randomly pre-select the order of all 90 numbers, I fill each of the 90 elements of an array with a random number first checking that the number selected hasnt already been stored, if it has, I just get the next random number (and check that too of course), but I cant see how that could prevent reversed numbers being selected, especially in light of the fact that frequently it's not the 'next' number that's used.
View 39 Replies
Feb 15, 2012
am writing an system application for a company that must generate inquiry id and order id automatically. Whenever a customer makes a new inquiry or new order by clicking the add button, an automatic number should be displayed in the text box and when it's saved, it should be saved in the database access.
View 9 Replies
Nov 9, 2010
How do you sort strings with numbers when you want numbers sorted based on their dimension?
View 19 Replies
Dec 26, 2010
Sub five()
Dim i As Integer
For i = 1 To 14[code].....
I want the numbers that I was comparing similar numbers. I get equal numbers and ELSE giving all series.I like numbers 2 4 6 8 9 10
View 1 Replies
Aug 18, 2009
I would like to know how I can have an enumeration that has multiple values and can be passed to a function.
Example:
Public
Enum
ActionEnum
NoAction = 0
[code]....
View 9 Replies
Mar 11, 2012
I am working on an assignment that will display the forst 10 fibonacci numbers in sequence. However when my results are displayed, the numbers are all stacked on top of each other like this: 011235813213455. I have tried to play with it but i can't seem to get my numbeers to space out or even maybe have a comma "," betweeen each number.[code]
View 2 Replies
Oct 6, 2011
The program must generate 6 unique random numbers but when I click display numbers sometimes it gives me 6 unique numbers and sometimes I get duplicate numbers. I will add the code I have so far.
Public Class frmMain
Private Sub btnExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExit.Click
[CODE]...
View 9 Replies
Apr 4, 2012
i have one more issues, and hope is the last for now. How can I limit a textboxe's input to only numerical with certain range of values (eg -10 to 10) and with that happening while I type in the values?
View 9 Replies
Jun 4, 2012
I'm trying to make a program that will calculate the sum of consecutive numbers between two given numbers. [code]
View 13 Replies
Jan 10, 2010
I'm using VB08. I've populated a listbox with numbers and I want to add all those numbers together and display the result in a Label. I've heard about using parse but I don't understand exactly how it works.
This is the code that I have that i think should work.
Dim lblTotal As Decimal
Dim sum As Double
For Each decAdded As Decimal In Me.lstRunningTotal.Items
sum += Double.Parse(decAdded)
Next
lblTotal = FormatCurrency(sum)
When I run it, nothing happens. My "For Each" statement I'm not sure if it's doing what I think it's doing. I can't believe I spent 6 hours banging my head against the wall but I finally got it figured out.
This is my revised code:
Dim sum As Decimal
For Each decAdded As Decimal In Me.lstRunningTotal.Items
sum += Decimal.Parse(decAdded)
Next
lbl_Total.Text = sum
Just some suttle changes made the difference
View 1 Replies
