Possible To Have Separate Combo Boxes That Will Give Separate ID Values But Using Same Table?
Apr 30, 2010
I'll get straight to my problem - I'm currently coding in Visual Studio.I have a table (countries) with the columns ID | Name. The table is filled with around 28 records.I also have a form with 4 combo boxes (set up as 1,2,3 & 4) that I want the user to select. These combo boxes will display the names from the table countries. I then want to use the selected names in the combo boxes to Insert into their corresponding ID into another table. For example England would have the ID 1, USA the ID 2 etc.So, is it possible to have separate combo boxes that will give separate ID values but using the same table? At the moment I can't seem to find a solution.Eventually the form will have more than 4 combo boxes so I don't want to use separate bindingsources for each combo box.
View 5 Replies
ADVERTISEMENT
Feb 23, 2012
I created a telephone number form where the user enters the telephone number in a text box as (nnn) nnn-nnnn. The first 3 digits in parenthesis are the ISD code, the next three are the area code and the last four are the local number. I need to separate out these three fields of the phone number and display in three separate text boxes labeled appropriately. Now, suppose the user enters the phone number in a text box as a continuous string of 10 digits, where the first three represent the ISD code, the next three represent the area code and the last four represent the local number. I'm lost as how to change this string into the form (nnn) nnn-nnnn. This is what I have
[code]...
View 3 Replies
Sep 17, 2010
I have a TabControl object on my form with many tabs created in code (TabPages) and my problem is that the same objects that are in the initial TabPage needs to be in the other TabPages created in code, I have this done in code when the user clicks the 'New Tab' menu option, however the same code is used for any new tabs created. The problem created here is that I have an event against one of the objects that appear in the other TabPages, but because the same code is used to create any new tab pages, the event will only work on the newest tab page, if that makes sense? By the way these objects that appear on the other TabPages are properties at the top so events can be handled against them in the respective subroutine.
[Code]...
View 5 Replies
Nov 11, 2009
I'm trining to loop through two separate list boxes to find a match for the textbox then display a message in the display label. Right now it just works on the first two zip codes in the $15 shipping zip code list box. Here is my code:
Option Explicit On
Option Strict On
Option Infer Off
[Code]....
View 2 Replies
Apr 3, 2009
Using the datetime function to determine lapse time. (Subtracting one from another.) Then placing the answer into two text boxes one with the date and one with the time, later to be placed in a database as two seperate fields. Was thinking I could convert the date/time to a string if necessary then use simple stringmanipulation.... however fear it won't be good programming and will effect resources and end program speed.
View 2 Replies
Dec 17, 2009
i need to take two integers from two text boxes and put them into two separate integer arrays then add them right to left carrying if over 10. here is what i have so far but just looking for the addition i think i can figure out the rest if i get the addition working...
' Project Name: Big Integer Project
' Project Purpose: User enters two integers up to 30 digits each then performs operation.
Option Explicit On
[code]....
View 2 Replies
May 13, 2009
I want to be able to have a dozen or so text boxes be emptied into separate columns in a row of a datagridview. This way the text boxes can be cleared and have new values entered then save the new values as a second row in the datagridview. This is so my VB gui which which runs everything through an old cmd line program, can do batches instead of one run at a time.
The problem is I have absolutely no idea how datagridview works. I've tried searching google and only found some vague things and stuff about databases. I also tried the MSDN library and that was of no help either, couldn't find anything on simply adding stuff and if I had it'd probably be to complicated to be of use to me.
View 17 Replies
Oct 27, 2011
I have a few forms that have a lot of really intensive updating along with a great deal of user interface (text boxes, button clicking etc) Is it possible to open a separate form as a separate UI thread from the start up form that called it to "show" or open or whatever the new method might be?
View 6 Replies
Sep 20, 2009
I am trying to make a simple smtp client and I would like to have it so it can add more then one recipient to the emailso I wanted to learn how to split a string using delimiters. I have only used delimeters in batch with a FOR loop but I don't know howThis is a sample I found on the net.
Private Function SplitStringIntoWords() As Integer
Dim strComplete As String = "This-is a complete sentence"
Dim strWords() As String
[code].....
View 5 Replies
Feb 27, 2009
I used this code to created 2 combo boxes General and Specific...and Only show Specific (Combo when Combo A is chosen.....What i need now is to know how to assign specific values to the items in combo b (Specific).??? If i chose a sode, Fanta, i want the total price to be $10.00 (this price will show up in the finial price box..
View 4 Replies
May 22, 2012
I am developing a program that makes it easier for users to log on to a website and search for specific data. I have the first portion finished in which I have a form with the Ax Web Browser control.
The web browser control navigates to a local website and automatically logs in for the end user. This is done by using code which automatically fills in the username and password and then submits the form to logon using something similar to this: WebBrowser1.Document.Forms.Item(, 0).elements("txtUsername").value = "user"
Once logged on - there is a search page which contains a combo box and list box. I am trying to set specific values for the combo box and list boxes.For example - the combo box on the website is titled: cbxDate and contains the following values: Today, Yesterday, This Week, This Month.
A list box titled: lstArea contains the following values: Zone A, Zone B, Zone C, All.I am trying to figure out if there is a way through code to select, in this example, "Yesterday" in the cbxDate and "Zone B" in the lstArea on the webpage.If anyone knows of a solution, please feel free to let me know. Be advised that I am using the Ax Web Browser Control.
View 2 Replies
Jun 4, 2009
Create a combo box that contains the values:
- Year 7
- Year 8
- Year 9
- Year 10
Thats easy enough, but i need to then need to do the following:When a option is selected, i want to display a seperate table for that year.For example, if i select "Year 7" a table specificly for "Year 7" is displayed.(Using visual studio)
View 11 Replies
Jun 4, 2009
I am currently updating an application I wrote to view Car Insurance Policies, using a backed SQL database and a front end vb.net GUI. I now need to make a change.
I haev added a new table which has all Active Policies, and i have the old table with every policy there has been active or not. We do an import from a separate company, and there is no Active/Not Active field.
I need a query/code that will populate an "Active/NotActive" field in the old table. For example:
CODE:
View 3 Replies
Jun 22, 2010
I have a class, called myClass.vb. I have a sub in it. this sub has a string variable, which has got some value. Now, i want this value to be transferred to the button_click event of a very seperate form called myForm.vb.
View 3 Replies
Aug 16, 2010
I've got a variable which contains a string like: dim test as string
test="bjcbhiabab,1,1,50,0,1,telepathie2,1,60,0"
Now I need to seperate all those values (each seperated by a comma) into new variables let's say value1 to value9 What's the most easy to use coding for this? I haven't got a clue which coding to use for this :S
View 1 Replies
Nov 7, 2011
I have been trying to find out how to do this for days now, so I am finally asking how. I am newish to programming. Here is my problem.
I am trying to extract x,y,z coordinates from a text file arranged as such:
x,y,z
x,y,z
x,y,z
etc.
I need to be able to extract the x column into an array, the y into an array, and the z into an array. I learned how to pull it into a string, and how to split for every line, but i don't know how to split after each comma and separate them.
View 1 Replies
Jan 3, 2011
I currently have an arraylist holding many separate numbers and I need to loop through the array and change each number, the number will be changed depending on other determined settings but I can't seem to get this to work,
For i = 0 To Me.TextBefore.Length - 1
intTemp = CInt(Me.textarray)
intTemp = intTemp + intUsr
Me.intarray.Add(intTemp)
Next i
View 4 Replies
Jan 16, 2012
If I had multiple entries under my value in my dictionary, is there anyway I can put each value in separate tags to create an xml document?
Is there anyway to split the 3 values into their own tags?
View 2 Replies
Feb 15, 2012
how can i Refresh ComboBox After Adding New Values via a Seperate Form in vbnet.
View 13 Replies
Mar 10, 2010
I'm just starting out at vb.net but have done programming before. i am trying to use a treeview to display information in a seperate table on the same form dependant on which nod of the tree is clicked. Secondly is it possible to import the information from an excel spreadsheet or does the information have to come from an access table.
[Code]...
View 2 Replies
Aug 15, 2011
I have produced some VBA in Access that creates a spreadsheet.I have also created an SQL query that retrieves records from an Access table.I have 48 tables (each table for a specific institution centre).I have created another bit of VBA code that creates a spreadsheet and loads the records from the query in to the spreadsheet.Each centre has a unique Sequence Number (Indent Number)At the moment though, all I can do is import one table (records for one institution) in to a spreadsheet. I want to end up with calling the function and having an output of 48 spreadsheets being saved to my desktop, each spreadsheet containing records of a different center.I have thought about putting a loop in, but not sure how I would quite go about it.
Here is my code to create the spreadsheet:
Public Sub ExcelExport(lngIndentNumber As Long, strFolder As String, strCrit As String, strReport As String)
', ctlLabel As Label,
DoCmd.SetWarnings False
[code]....
View 2 Replies
Dec 26, 2010
I have a login form that consists of 2 text boxes: txtUser, txtPass. Now these are not bound to any data table & I don't what them to be bound. When a new user enters his user name & password, I want to add these on a data table that has two columns: User, Pass. Data table information: Data Source = Login.accdb, Data table = LoginTable, Connection = LoginCn. I use visual basic 2010. So how do I do this?
View 1 Replies
May 13, 2011
Bind multiple combo boxes to same data table with minimal code
View 19 Replies
Sep 27, 2010
None of the Microsoft videos I have watched, or the other posts I have seen, have given me the pieces I need to understand this process. This is the one key piece of understanding that I need to finish about 4 different programs I have started in the last 2 years. All of them key on understanding the following processes:
View 1 Replies
Feb 7, 2012
I want to insert data to a table in SQL DB.I have a combo box with the values "5" and "6". When you click one or the other in the combo box i want these values to be inserted in a database( MS SQL Server 2008).I also have some textboxes which are bind correnctly and have no problem. The problem is with the bindings(i guess) of the combo box. I get sql exception.
Here is a snippet.
Private Sub BindFields()
txtSurname.DataBindings.Add("Text", ObjDataView, "surname")
txtName.DataBindings.Add("Text", ObjDataView, "name")
[Code]....
View 1 Replies
Oct 27, 2011
I am a beginner programer. I am working on a windows form in vb.net Visual Studio 2010I have several text boxes, dropdowns, radio buttons and check boxes in my windows forma.
View 1 Replies
Nov 3, 2010
So 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.
View 5 Replies
Jan 23, 2011
I'm in the middle of creating an application that will be used to input customer information whilst the customer is speaking to someone over the phone. This involves the customer giving the employee information such as name, address, postcode etc and the employee inputting that information into text boxes and combo boxes that are in the application.
What I would like to be able to do is after the customers information is given over the phone, I need to be able to send that information to a database which will probably most likely be done by button click. In this case, I'm using Microsoft Access. I'm also hoping that I can do this within Visual Basic coding.
The database is set out with multiple tables which include a customer table and a ticket table and both have multiple fields such as first name, surname in the customers table. Both of these tables are in use with the information that the customer gives over the phone.
I've already asked on other forums and people are where replying giving me third party programs that I could use to implement this, something I don't really want to do.
View 9 Replies
Jan 23, 2011
I'm in the middle of creating an application that will be used to input customer information whilst the customer is speaking to someone over the phone. This involves the customer giving the employee information such as name, address, postcode etc and the employee inputting that information into text boxes and combo boxes that are in the application.
What I would like to be able to do is after the customers information is given over the phone, I need to be able to send that information to a database which will probably most likely be done by button click. In this case, I'm using Microsoft Access. I'm also hoping that I can do this within Visual Basic coding.The database is set out with multiple tables which include a customer table and a ticket table and both have multiple fields such as first name, surname in the customers table. Both of these tables are in use with the information that the customer gives over the phone.
View 1 Replies
Jul 25, 2009
i want to separate bellow lines by ; using vb.net
Name=203596:0
sigTs=16
CIC=100,7FFF7FFF
LinkSet=001
userID=01
View 1 Replies