I am working on doing a Copy and Paste in Excell. I need a way for the user to input the range for coping form the first sheet. So I created two text box. But now I can not figure out how to combine the text box values as to create the range. Here is what I am woking with.
Private Sub BUILD_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BUILD.Click
Dim moApp1 As Object
[Code]....
I am trying to follow the book 'Sams teach yourself VB 2008'. It was going well until the end of hour 4. For exercise 1 I have created the form with a button and two text boxes, but cannot work out the code I need to move text between the two boxes. The Object Browser does not seem to help - am I reading it wrong?
View 14 RepliesI need to create a form with radio buttons, text boxes, labels, etc.. This information needs to be pulled from a database. For instance, I have a form that displays information that needs to be inputed to a database, based on what test is being done for a specific product. Each product requires different tests. So each product may or may not have the same information that needs to be inputed..
What I have done is made a database and filled a table with each product and what tests apply. I then call that database after the product has been selected for the tests. It will then fill an array for that products information for what texts boxes and labels need to be shown. I wanna take this further and have it create a form through code and align all the controls to specific spots so that it will look nice. For example I wouldn't wanna create a control and have it be cut out of the form, or have other controls overlapping others.
[Code]...
how to move info from text boxes on one form to binding source text boxes on another form. I am displaying array info in text boxes on one form and i need to add them to the database on another form. How do I do that?
View 5 RepliesI have 81 text boxes on a form and would like to create a text array in code that will equate to these boxes on the form. Once I've assigned each text box from the form to the array entry, I'd just like to work with the array - then have the actual text boxes on the form reflect the changes made to the array.
View 4 RepliesSo as the name states; I am a newer coder.
This is the code i have:
Public Sub RandomNumbers()
Dim s(4) As String
Dim RandomNumber As Byte
I don't know if you can tell what I am trying to do here, so I will try to explain. I what to create for random numbers and place them into for different text boxes. I also would like to do this with combo boxes and their selected indexes. So if the combo box has 10 items in it; the new selected index would be the random number generated above.
I have a pop up form that contains a listbox. Right now I am telling it exactly which text boxes I want to be able to drag and drop to, but I was just told to have it drag and drop to every text box on the main form.The main form with the text boxes has a bunch of tabs on it that hold each section. Each section has text boxes, so how would I code it so they are all capable of allowing drag/drop without specifying each one separately?
This is the code from my pop up form:
vb
Private Sub txtDropIn_DragDrop(ByVal sender As Object, _ ByVal e As System.Windows.Forms.DragEventArgs) Dim DropInTextbox As TextBox = CType(sender, TextBox) Dim TextToDrop As String = CStr(e.Data.GetData(GetType(String))) 'get rid of leading " - " if there isn't 'anything in the textbox If String.IsNullOrEmpty(MainWin.TextBox1.Text) Then TextToDrop = TextToDrop.TrimStart(CChar(" -
[code]....
I've found ways to read from a .txt file into Excel, but (having created and loaded an Excel sheet via vb.net 2008) I want to do the opposite which is to read each cell and row into a .txt file csv format like this: "Surname","Andrew","2","Mr","Hon.Member","PERCUSSION" I guess I need some way of knowing when the last row of data ends. Once in a .txt file I can load data in a variety of ways into several ListBox/s and labels without loading and reading the original Excel file.
View 3 RepliesI have a form that needs to create textboxes based off the count of rows in my dataset table. The amount of rows could vary from 10 to 20, so I need a loop to add the textboxes to add the textboxes on load. Right now I have the loop down and other things shown below.[code]...
View 7 RepliesI am using VB.NET vb 2008 . I am trying to create text boxes dynammically and remove them here is the code i have written so far
Private Sub setTextBox()
Dim num As Integer
Dim pos As Integer
[Code]....
I am able to create the textboxes but only a few of them are removed. by using For Each ctrl In Panel1.Controls it doesn't retrieve all the controls and some ae duplicated as well.
My problem is after I created 5 rows of text boxes, I want to add random numbers to all of the text boxes in one time when I click the button.Here are my coding to create text box dynamically:
Private Sub btnAdd5Row_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddFiveRow.Click
For Me.count = count To 5
[code]....
I have a text file containing 10 pieces of information. I want to read the information from the text file and put it in text boxes on a form, so that the user can view the information and edit if required. What is the best way of approaching this?
View 4 RepliesI'm trying to validate input boxes for numeric value and range value. If I validate for either numeric value OR range value there is no error (for example, comment out one of the validation statements), but if both statements are present and I enter "a" I get an error "Conversion from string "a" to type 'Double' is not valid." Can anyone tell me what I'm doing wrong?
[Code]...
I am using many text boxes in a form. How do i validate them, In certain text boxes I have to use only text and in some I have to use only numbers. Is using ASCII is a right method or is there any easier method to do this. If so please let me know the coding.
View 5 RepliesI want to add more text boxes in login form i try to do it by customize create user setup and added also but it not creating database table.
View 5 RepliesAdding text boxes to a form
View 2 Replieshow to permanently save to text files then re-open all of the information again using SFD and OFD. Now my teacher has come back at me and said that i need to be able to save the information from multiple text boxes and have the text in certain labels to also be saved into the one text file (the labels need to be done because it is a database and these labels are like the fields and the right text box needs to match the right label)
View 39 RepliesSo i watched this video here. [URL]
And i want to do this for like 40+ text boxes, how can i do it?
I have 100 text boxes on another form I have to populate. I don't want to use 100 Form3.txt1.Text = Mid(answer,1,1) as shown below, i would like to put them in a loop, like a For loop. But when I try I get Error1'txt' is not a member of 'WindowsApplication1.Form3'.Is there another way of doing this?
[Code]...
I've coded a Login form with two text boxes and two buttons goes to a Users database to validate the userid and password. When I click the OK button (button1) I get an error message on the highlighted line below(Dim Reader).
It states that no value is given for one or more required parameters. What parameters are they talking about?[code...]
I want to have 5 numbers randomly selected from 500.I've set up the form with five text boxes and a button but I have no idea how, when the button is pressed, to get five random numbers to appear in each of the five text boxes.
[Code]...
The form has First Name, Last Name, Course and Email text box fields. First/Last Name must have no spaces, Course must consist of a three letters and two numbers in that order and nothing else(I want to avoid the use of masked text box), and Email must have the "@" sign and a dot. How would one make it so after clicking, say, Submit button and if there was a violation of any of the above rules then message box should pop up and tell the user which fields contain incorrect information.
Private Sub buttonAddNewStudent_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles buttonAddNewStudent.Click
'validation must be performed before the corresponding text box items will be placed inside an array
[Code]....
First i am pretty new to coding and everything so yeah...I wish to make a distance and fuel calculator as my project. Included will be multiple combo boxes with different sets of information (The manufacturer of the vehicle, model of vehicle, the vehicles fuel use per 100Km, its transmission type, users choice of where they will depart from and arrive etc.) Is it possible to achieve this without using a lot of combo boxes? I've experimented using if statements for example:
if combobox1.selected item = "Holden" then
combobox2.visible = true (it's bad i know)
Then from this they would choose their model type in another combo box and then choose their transmission type etc..I don't want to use this because then it will mean i will have to do it for each and every combo box for each and every different set of data because making one 'visible = true' i will have to make the other 'visible = false' and this will cause problems when i start adding a lot onto it.
I want to display (DataGridView's) selected row contents (each cell value on appropriate text box) on text boxes on the form. This should be fairly simple task for experienced i am sure.So far i haven't been able to find a single working solution to accomplish that as most of the articles are written for VB / VB 2005/ VB 2008 and not VB 2010.
Here is what i have already tried. (I tried putting an image but i can't due to my privileges over flow) TextBox1.Text =DoctorsDataGridView.CurrentRow.Cells(0).Value.ToString It strangely works for first 4 selected rows and populate text boxes but fails for the rest of the DataGridView.
[Code]...
I have a reset button created in my VB form, but don't know how to code it so that it will accomplish what I want. I want it to clear the form's text boxes so that new input can be entered. I could just code an end statement but this closes the form, and I want to keep it open to continue working with it.
View 6 Repliesive got code like the code below that creates textboxes dynamically. I want to be able to click a button and delete all of these textboxes i make, however im not sure how to do this. When i tell the program to remove the TBIndex control it does not do anything. The only way i get it to work is if i put the command in the same sub as this code. This code runs in a loop by the way.
So if the loop runs one time and creates the TBIndex control and i have a line of code right after to remove the textbox, then it does not show up on my form. But if i put the command in to remove the textboxes somewhere else and run the code the loop runs abunch of times and creates all teh textboxes and the loop is complete, then the remove control part is called and nothing happens. I just need a way to clear all the textboxes off my form with like a button. I also tried painting over the textboxes with a big grey rectangle but that dindt work.
TBIndex.Width = 54
TBIndex.Height = 20
TBIndex.Visible = True
[Code]....
What I want out of this program is to have a saved file open up in another form and displayed in 4 text boxes so they are able to be modified. my code is as followed:
[Code]....
I have successfully navigated to the page I want and now I need to know how to fill in text boxes on the page. I used SendKeys.Send before but that was when the first box was already selected. I can't seem to get the box selected by tabbing at all. I can find the textbox id if that helps.
View 4 RepliesIn VBA I am able to search a text in an excel range like this:
Code:
Workbooks("Book1").Activate
With Worksheets(1).Range("C1:C10000")
[code].....
I have upgraded to Visual Studio because of the jobs I am to carry out. So I am translating all the codes from "VBA" to "VB.NET" (Visual Basic 2008)But I haven't been able to use "Find Method" in VB.NET. I am using Microsoft Office XP Standart Edition (2002 Version). I downloaded and installed Office XP PIAs. After that I referenced them in my project. I used the code Code:Imports Microsoft.Office.Interop.ExcelBut I can't do what I want Now, how can I use "Find Method" in Visual Basic 2008 to find a text in an excel range in one of my workbooks?
I made a form with text boxes in a 6x6 square pattern. It will do a streamreader from a text file a number that indicates the size of the array. Then fill in the boxes with the numbers of the array. Then it will calculate the rows and columns to see if they add up to a single answer. Then it will display to an output window if it is a magic square or not. Meaning if all rows and columns add up to a single number its magic. If they dont add up to the same number then its not magic. Then it will repeat this check and output from the information of the other arrays from the text file.
I know how to code for the streamreader and get it to add the rows and columns. Im not sure about what code I need so it can check the answer if its magic or not and repeat it till the end.
Here are the contents of my text file which it will read from.
CODE:
