I am trying to get a number into a cell but as a string not a number. For example if I have the number as '12345678901234' instead of putting that exact number in it changes it to ' 1.23457E+13 '. How do I get it to read it as a string and not an integer? Here is the code that I am using.
Dim
num As String
If pRow.IsProjectNumNull = False Then
[Code].....
Sub adddashes()
Dim j As String
For u = 1 To 10
dashnumber = 1001
Range("D" & u).Text = Range("D" & u).Text + dashnumber
dashnumber = dashnumber + 1
Next u
End Sub
Ok on my sub, i have a list of names and i want to add a sequential dash number
NAME-1001
NAME-1002
NAME-1003..
etc....
However, i just straight up can't find the code to 'join' two variables or add a variable to an existing cell.....
I created a listbox using VB.NET. When the user select an item (it is a string format) in the listbox and click on a button, there will be a number beside the string and the number will increment which time the button is clicked. Anyone know how to do it...?Below is the coding I'd done, but I don't know how to do the increment part. Anyone know what coding I need to add?
Dim no As Integer = 0
listBox.Items.Add(listBox.SelectedItem & no)
I am doing a bar cash register and I want to use a if statement to see if fosters button and number 1 on the number pad are both pressed then multiply constant by quantity number
View 1 RepliesHow can I do for converting 3 in "three". Or converting for example 153 in "one hundred fifthy tree"
View 7 RepliesIF cell phone is connected with PC over BlueTooth or Wireless and someone call that cell phone is it a possible to get caller person number from cell phone ?
View 5 RepliesIn VB.NET, using Interop.Excel, I need to access a cell based on a row number and column letter. I tried my luck with...
pages.title = DirectCast(wksht.Cells(rows, "D"), Excel.Range).Value
Since the parameters took type object, I figured maybe this would work, but got no luck. I also thought of enumerating each letter to a number, but the columns in the spreadsheet aren't as normal. Meaning, they're not
A B C D E F G
They're actually...
A B C D E T AZ
I don't know if this makes a difference in the numbering of the columns. The question should be obvious, but just to reiterate, how can I get a cell based on a row number and column letter?
VB.NET code to change Excel 2007 Column Cell Format from Text to a Number no Decimal.
Right now Column F shows values that look like
3E+13
3E+13
Manually changing it to a Number with No Decimal shows the correct value.
30000046605562
30000041582875
Of course I would like to automate this.
I am working in excel trying to setup a function involving multiplying a cell by a set number and then having the result round to the nearest 10. Here's the beginning of my function statement fx=e3*1.026. say the result is 8654, I need it to round to 8650. Also if it comes back 8655, I need it to round to 8660. I have about 2,000 records I need to do this to so I was hoping that one formula or statement could be used for all my data.
View 2 RepliesI have a problem with a sql query. Through the query I am trying to search database for any occurrences of string (can be anything) in a column using the SQL LIKE command. The problem is that it works fine for most of the strings say john, jim, ji"m , but does not work when i include the following characters which are ( ' , { , } , and a single quotation mark). MYSQL query takes care of these special cases by putting them in [] block whenever user enters them .But i am getting the following error when i go to query the database using the GetSelectCommand() in VB.NET
Exception Details: System.ApplicationException: Number of values provided must be equal to the number of placeholders in query.I have checked the query over and over again .. but its fine .My database server is Sql Server 2008.So my application throws the exception in this command:
Using reader As MustDisposeDataReader = _
pmSystem.DatabaseManager.GetSelectCommand(selectStatementBuilder.ToString(), New Object() {})
Where MustDisposeDataReader is an instance of a class in an internally developed library, which inherits from System.Object. pmSystem is an instance of the class PlanManagerSystem which implements the commandlayer. GetSelectCommand() takes the select command
I got most part correctly but the only part isnt working right is when the last 5th digit match the sum number at the last number.
Private Sub btnVerify_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnVerify.Click
Dim strCardNum As String
Dim strSumNum As String
[CODE]...
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]...
I have a txtbox(for barcode).. if i input a item number in that txtbox and if that number will match in your database, the other information(shall we say, product type, item ID, etc..) will display in my other txtboxes..
View 5 RepliesIn VB if you prompt the user for a number between 1-20, then a word, how do you get a text box to show the word the same number of time as the number selected using loops?... Ex: please select a number: 4 / select a word: cat....the text box should display ::: catcatcatcat ........
I am doing this for a class and my brain has locked up. Prob. just over thinking it though. Thanks in advance for any help!
I am attempting to create a game in Visual Studio 2008 that allows a user 10 attempts to guess a random number between 1 and 50. I have a label box in which I would like to display the remaining guesses as they decrement. The code so far appears below.
My two (I am sure very basic) questions are:
1. How would I pass the random integer generated through the Generate Integer function to the AmIRight button's click function? I was trying to decrement the counter each time the "Am I Right " button is pressed.
2. I would also like to evaluate each "guess" when the "Am I right button is pressed. Is it possible to nest a Select Case statement in a For Next Loop?
vb.net Option Explicit OnOption Strict OnOption Infer Off Public Class frmMain Private Sub btnExit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExit.Click Me.Close() End Sub Private Sub txtGuess_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles
[CODE]...
i wanted to create a random number generator that iterates through a series of number between an upper and lower bound. say between 1 and 100. Basically I want the number generator to pick the numbers randomly and then display them until all 100 numbers are picked without any duplicates. so thats easy I can code that. But what I don't know is how to show those numbers in the order they are generated on a windows form. So i have basically a variable that I will let be changed 100 times (or however many times I want, I don't want their to be a size constraint just using 100 as an example) and each time the number is generated I want it displayed on screen (in a list or something not sure what. Hopefully some type of scrollable list) and each successive number also to be displayed in same format beneath it so that I can see the list in its entirety. What type of form control do i use for that? I could do messagebox.show for each iteration but then user is required to hit ok after each iteration and that would obviously be a bad idea if user selected a large number to work through. Anyways, code isn't exactly necessary just point me in the right direction, i.e.what control (if any) to use.how to format the change in data?
View 7 RepliesI need to write a program that requests a high number and a low number from the user, then the program searches the array and finds all elements within the two numbers. The program is used to search for past presidents, so if I type 43 for low number and 44 for high number, the program will display:
George Walker Bush
Barack Hussein Obama
I think I have an idea of how to search up to a certain point, but not to stop at a certain point....Here is the code that I have for that particular sub procedure:
Quote:
Private Sub btnDisplayRqst_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDisplayRqst.Click
Dim sr As IO.StreamReader = IO.File.OpenText("PRESIDENTS.TXT")
[CODE]...
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.
Trying to upload a picture file from an online source and store it in a byte array but am having the error: "Number of Indices is less than the number of dimensions in the indexed array".
Dim Bytes() as Byte
Dim Inet1 as System.Net.Webrequest
I want to convert numbers from 0 to 15 like that
[Code]...
Problem is that when we convert 2 to binary number it gives only 10 in binary, but i want to convert 2 to 4 bit binary number 0010.
converting the number of frames (in a video) to a number/time format. For instance, say a video has 110,212 frames at 23.976 fps, it works out to 01:16:36 (hh:mm:ss) with 18 frames remaining. I would like to format the result in a Textbox like the following:
[Code]...
how do i count the number of rows that are affected when I updated a table, and display the number of affected rows in a message box ??
here is my code for updating the table ...
For Each row As DataGridViewRow In DataGridView1.Rows
req = row.Cells(Column1.Name).Value
If row.Cells("Column1").Value = True Then
[Code].....
I am trying to draw textboxes when the user enters the amount of textboxes to be drawn on one form and the textboxes get displayed on the another form. I have found these codes online but it works with inbuilt codes I guess. That is, the number is already hard coded in the form.
[Code]...
validation in vb.netemail_id validation,name,mobile number,Telephone number,zip_code,address i want to all code the textbox
View 3 RepliesI am supposed to create a program in my VB.net class to do the following:
1. Prompt the user to enter the beginning number and the ending number.
2. Find the sum of the even numbers between these two values, inclusive.
[Code]...
We are currently using for next statements in the class. I know how to prompt for and utilize the numbers that are input etc. My problem is the EVEN numbers part. I obviously have to determine if the number is even and then use a step value of 2 from there. But not sure how to determine if number is even or odd (guessing to use mod, but totally lost).
I am wounder if anyone might have a web site or no where I can find the information so I understand how to prompt the user to enter the beginning number and the ending number. And then to find the sum of the even number. Now does anyone know what a name convention is ? I have tried to look it up on the forums but cant find nothing on it.
View 9 RepliesI am trying to create a lotto simulation, but don't know how to continue.I am using numericupdowns to allow users to select 6 lotto numbers. and labels to display what they have chosen, but i'm not sure how to prevent duplicates without creating a large number of If statementsMy question is, is there an easier way to prevent duplicates without writing a bunch of if statements?here is my code:
Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Lotto1, Lotto2, Lotto3, Lotto4, Lotto5, Lotto6 As Single Lotto1 = Val(NumericUpDown1.Text) lblLotto1.Text = Lotto1 Lotto2 = Val(NumericUpDown2.Text) lblLotto2.Text = Lotto2 Lotto3 = Val(NumericUpDown3.Text)
[code]....
I don't understand how to save the user selected numbers, let the computer generate 6 random numbers, and match the two sets of numbers together to see how many matches there are. As far as I understand the numbers should be stored in 2 separate arrays and then matched together to find any matches.
I am calling the function below from an Excel spreadsheet and the conversion from hex to decimal using the VAL function in the "manufacturer" variable below is coming back with a negative value. The VBA edition is 6.5.
Public Function decMEID(ByVal sKey As String) As String
Dim manufacturer As String
Dim serial As String
[code].....
Is it possible to call a Skype number that is in a RichTextBox by clicking on the number?I have links activated in the RTB but phone numbers do not appear as a Skype link.
View 5 RepliesI 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....